Data Warehouse

Engineers Dashboard for a Heavy Vehicle Services Company with > 600 in Fleet

Microsoft Power BI, Azure Data Factory, Azure SQL

The Challenge

The client used a third-party application to manage their day-to-day work. Building dashboards to measure the KPIs (such as machines on the collection, priority tasks, high priority tasks, early warning on delays, etc.) was a manual, time-consuming, and error-prone task. They were looking to automate the entire workflow and needed the data every 30 minutes to be able to effectively manage their process.
They were unable to build a view of the drivers’ efficiency, and early warning when prioritized pickups could get delayed. To make matters more difficult they had no internal expertise in technical aspects of the application they were using, making requirements gathering a tricky proposition.

The Solution

• We got access to their application and diligently went through each screen, performing the same steps as the client would do, all the time collecting the processes that were getting triggered.
• Once the requirements were affirmed, we designed an optimal data model, processing pipelines were designed in Azure Data Factory to process data every 15 minutes and store it in Azure SQL. 
• The reports were developed in Power BI

The Extra Mile

• Their requirement was to provide completely processed data every 30 minutes. We were able to complete the pipeline every 15 minutes much earlier than the required SLA.
• The automation saved a daily effort of about 2 hours of manual effort for manual report generation.