Reporting modernization with Amazon QuickSight
A global automotive supplier
A global automotive supplier came to Wavicle to modernize their reporting platform to improve operational efficiency and customer experience.
BI Reporting & Visualizations
Business Intelligence & Insights
Reporting Modernization
Amazon QuickSight
Amazon S3
Apache Airflow
Apache Hudi

Reporting modernization

Global Automotive Supplier Modernizes Reporting for IoT Insights

A global automotive supplier recognized the critical need to enhance customer experience and operational efficiency within its micromobility business unit. This initiative called for an innovative reporting approach capable of handling extensive data from diverse sources, including IoT battery data and customer experience metrics from mobile applications. 


With challenges with disparate data sources and a need for actionable insights, they partnered with Wavicle’s data, analytics, and visualization experts to modernize their reporting infrastructure using Amazon QuickSight. This empowered decision-makers to identify trends, track performance, and make data-driven decisions to enhance the overall performance of their battery supply.


Outdated reporting and obsolete dashboards 

In a strategic move to expand its operations into the micromobility market, this global automotive supplier established a partnership with a leading company based in Asia to provide batteries for their network of charging stations. This collaboration was a significant step forward for the supplier, marking its entry into the rapidly growing electric mobility sector.  


However, the expansion also brought the challenge of managing and using large amounts of data from IoT sensors tracking battery performance and mobile apps capturing customer experience data. Combining data from both charging stations and bikes made data management even more complex.  


The company’s existing Metabase reporting platform couldn’t handle the high volume of incoming data, and they struggled with data modeling and scalability. Their outdated dashboards couldn’t generate the reports needed to assess battery quality and make smart decisions to improve customer experience and overall business performance. 


To tackle these obstacles and harness their data effectively, the automotive supplier turned to Wavicle’s data and analytics experts. To start the IoT analytics project, they sought to implement Amazon QuickSight and build out a set of 15 customized, user-friendly dashboards that offer insights into battery health, battery and charging station utilization, and energy consumption.  


With this visibility, the automotive supplier would be able to make smarter decisions about battery maintenance, asset utilization, and energy consumption. Enabling this type of proactive battery maintenance and replacement was intended to decrease potential battery problems for customers and improve their overall experiences.


Modernizing analytics infrastructure  

Wavicle’s consultants collaborated closely with the automotive supplier’s business teams to identify their reporting challenges and understand their data landscape thoroughly. 


After gathering a full picture of their business requirements, Wavicle implemented a new reporting platform to enhance data visualization and reporting capabilities. A new data reporting architecture was meticulously designed, and initial dashboards focused on providing insights into cost management, strategic maintenance, operational efficiency, and user experience. 


Wavicle’s data engineers integrated IoT and mobile application data using leading technologies like Amazon S3 for scalable data storage, Apache Hudi for dynamic data processing, PySpark for building robust data pipelines, and AWS EMR with Apache Airflow for streamlined orchestration. The data was then organized into multiple layers – raw, processed, and analytics-ready data – ensuring its readiness for consumption by Amazon QuickSight dashboards.  


This scalable, flexible, and efficient solution facilitated effective management of diverse data sources and delivered timely analytics to drive informed decision-making. The modernized reporting system provided detailed dashboards displaying crucial KPIs, empowering teams to improve both operations and outcomes.


Clear reports and interactive dashboards improve operations  

Wavicle’s team designed dashboards that demonstrate in-depth data analytics and the value of clear reporting for improving user experience and battery maintenance. These dashboards empower the company to identify trends and potential issues early to make proactive maintenance decisions and raise the quality of battery health in their micromobility fleet. 


The implementation of a new reporting system using Amazon QuickSight facilitated rapid visibility into critical metrics such as battery health, battery and charging station utilization, and energy consumption. The revamped dashboard platform, comprising 15 tailored and intuitive dashboards, provided a comprehensive view of KPIs and facilitated data-driven decision-making.  


This enhanced visibility empowered the operations team to develop actionable plans that drive continuous improvement and surpass their operational objectives. With more detailed reports that offer greater accuracy, the automative supplier will be better able to gain actionable insights from their rapidly expanding IoT and mobile application data.