An advanced analytics framework to enable well-organized reporting, rich data visualization, and customizable dashboard layouts for an asset tracking and fleet telematics company
Client: Digital Fleet is a GPS asset tracking and fleet telematics company offering real-time fleet tracking solutions with customizable workflows and integration with operational systems particularly made for the construction materials and ready-mix concrete industries.
Challenge: Since Digital Fleet works in Telematics domain, they have to deal with large amounts of data. Effective management of the rapid increase in data volume was being considered as a challenge to the client. The reporting module required more flexibility and efficiency. To make this upgrade possible, it was important to keep the data storage for reporting module separate from the production module. SSI pooled resources with Digital Fleet to build a product for the better management of the increasing data volume using SQL server. It was advised to use MongoDB in sync with SQL Server in real time because the reporting majorly consisted of near real-time tracking of construction vehicles on maps.
Solution: SSI implemented its own developed analytics framework that enables well-organized reporting, rich data visualization, and customizable dashboard layouts. It has three main features:
- Query Builder: A rich UI to design complex drag and drop structures and creates text queries on
- Report Builder: Creates multi-section reports based on the queries designed in Query Builder.
- Dashboard Builder: A widget based data visualization tool to build a customized dashboard layout of user’s choice.
A message broker service was introduced to transfer the data persisted in MongoDB to MS SQL Server for
Result: The application helped improve the user experience for their end clients and improved operational efficiency for Digital Fleet as a more scalable platform.