Crunching 60 Million Variables Into Beautiful PDF Reports

Industry

Coating

Solution

BI Platform

Scope

Development, Design, UX, UI

Platform

Web

Duration

2+ years of partnership

Illustration of a two people and one browser screen, created by Kambu

Introduction

Choosing the correct coat painting for a vessel can be a complex process, as it affects many aspects of the ship’s performance.

Kambu developed a platform that crunches all hard data provided by the client into customizable and user-friendly reports.

Challenge

Kambu built a Business Intelligence platform used by sales reps. The employees can import data, manage vessels, take notes, and need only a few clicks to generate elegant PDF reports that take into account multiple factors. 

The reports are then used to advise future partners on how the coating will impact their vessels’ fuel efficiency, performance, and much more.

The platform handles a massive amount of data, so performance is always a top priority to the devs. We used Azure Batch to successfully optimize the interaction of the system with the database.

The import process is straightforward despite so many variables. A clear interface guides the user to import a text or spreadsheet file, validate missing fields, and map each column to the matching parameter. It’s even possible to create columns with custom calculations on the spot. 

The system then seamlessly crunches all variables, taking into account outliers and environmental factors, to generate performance indicators. The client explained all calculations, and Kambu implemented and tested each scrupulously to ensure they are reliable. 

Key features

What a Sales Rep Does

Manage vessels

Import vessel data

Generate ISO-compliant PDF report

Add reminders to calendar

Chat live with customers

Technology

Project development

When Kambu started working on the platform, there was already a version in place, which provided both benefits and challenges to the project.

On one hand, the existing user interface was not intuitive and asked for an overhaul –  radically changing it, however, could frustrate sales reps who were used to it. 

As such, the UI was gradually worked on. It started with fixing critical mistakes and then moved to minor enhancements, always without straying too far from the original version.

On the other hand, the developer team managed to perform only minimal changes to the core code by performing in-depth assessments of the existing C# repository.

Understanding the project structure and design patterns was complex but allowed the devs to save time in the long run. This way, they only fully rewrote the back-end code when new features were added. All front-end code, however, was built from the ground up.

Logo Node.js Logo React Logo C# Logo ASP.NET Logo MySQL
Zdjęcie z biura - Programista w pracy

Let’s work on your next project

Are you planning to implement an IT system? Let’s discuss your needs and business goals.