Developed, tracked, and trended key metrics for an in-vehicle IOT device
Company Information
A telecom client sought to unlock the value of data generated by an in-vehicle IoT device but faced challenges in processing raw data into actionable insights. ProCogia was engaged to create a sophisticated solution that would not only process and analyze the data but also present it through a dynamic, metric-rich dashboard. This initiative aimed to empower Product Managers with the ability to monitor performance, identify trends, and make informed decisions based on near-live data.
The Challenge
The client’s primary challenges included handling large volumes of raw IoT device data, filling historical data gaps indicative of systematic data capturing failures, and developing an efficient, automated process for data ingestion and metric aggregation. Additionally, the client required an interactive dashboard that could visualize these metrics in a user-friendly manner, enabling easy data exploration and analysis.
Procogia’s Approach
After discussing the challenge with the key-stakeholders, we decided to adopt a Continuous Integration Continuous Delivery approach for building out a final metric-rich dashboard. We used a tech stack of Databricks and Apache Spark to process the raw data and transform it into aggregated tables which were connected to Power BI – the client’s dashboarding platform of choice.
We initially undertook quality control checks on the data and identified major historical gaps which are typically indicative of systematic failures in the data capturing systems. We worked closely with the client’s Data Engineering team, helping them understand and identify which data needed to be backfilled & educating them on best practice including tools & a new approach to monitor their data volumes going forward.
We Educated the Product Managers through exploratory data analysis showing them the art of the possible. We identified the most useful & Insightful metrics for them to consume in their dashboard and got agreement on how they wanted these specific metrics presented.
We then built out automated cloud-based software to efficiently ingest their large volumes of their data and output aggregated metrics. These metrics were presented in the custom dashboard which was designed with regular input from the client.
The Results
ProCogia sourced, cleansed ingested and analyzed the previously unusable IOT device data
We visualized the data through a bespoke Dashboard which presented a set of tailormade metrics for their product
Product Managers could carry out their own investigations through an interactive dashboard with near-live data
System monitoring tools implemented to track the volume of data saved and alert the client of anomalous volumes of data
Services Used
Data Consultancy
We provide data consultancy to organizations to optimize your investment in people, processes, and technology. This is typically through data strategy engagements, roadmaps, transformations, and independent technology advice.
BI & Analytics
We transform complex and high-volume data into BI reports using dashboards and visualizations, allowing you to make smarter decisions.
Conclusion
Through the deployment of a dynamic data processing and visualization solution, ProCogia significantly empowered the telecom client to leverage in-vehicle IoT device data effectively. The custom dashboard and automated data processing tools not only facilitated insightful metric tracking and trending but also equipped Product Managers with the resources to drive product strategy and enhancements. This case study underscores ProCogia’s capability to transform complex data challenges into actionable insights, fostering innovation and strategic growth in the fast-evolving telecom industry.
Explore more stories
Dig deeper into data development by browsing our blogs…
Implemented Bookmarking Apps
A leading investment consulting firm faced challenges in managing and sharing complex data analyses through their internal tools developed with Shiny. As the firm sought
Optimizing and Scaling RESTful API for an Investment Consulting Firm
Optimizing and Scaling RESTful API for an Investment Consulting Firm Company Information A prominent investment consulting firm sought to elevate the performance and maintainability
Low-code solutions using Azure & Snowflake
ProCogia implemented low-code solutions using Azure Data Factory and Snowflake for the Performance Data Science team of a Leading Sports Organization
Get in Touch
Let us leverage your data so that you can make smarter decisions. Talk to our team of data experts today or fill in this form and we’ll be in touch.
