Geopositional Analysis of Vehicle and Ride Data
A proof of concept for a vehicle telematics company: EMBIQ turned raw data from monitored vehicles into a web dashboard with dynamic indicators and a map view, ready for demonstrations to the client's stakeholders.
Technologies used
Python, Plotly, Dash
Tools
Data integration with the client's database, data cleaning and normalisation, interactive dashboard prototyping
2
Project members
3 months
Project length
PoC/Demo
Category
Transportation
Branch
The challenge
The client collects large volumes of raw data from devices installed in monitored vehicles, but had no user-friendly way to present it. The goal of the proof of concept was a web dashboard that, straight after opening, shows a set of indicators and charts describing the current state of the monitored vehicles, refreshed from the client's database, together with a map showing where the vehicles are. Before building anything custom, the team compared ready-made visualisation tools against the expected look and refresh behaviour and agreed the approach with the client. Success was defined simply: the dashboard had to show meaningful data immediately after start-up and update its indicators dynamically as new records arrived. Most of the work sat in the data rather than in the charts. Raw records had to be loaded, cleaned, normalised and checked for plausibility before they could feed an indicator: some values arrived in units or scales that did not match what an indicator needed, some fields were missing or incomplete, and reference ranges for vehicle signals such as battery voltage or engine temperature had to be agreed with the client's experts. The list of indicators was adjusted along the way to what the available data could support reliably.
Working on this project was both exciting and exceptionally demanding. We had to not only understand the complexity of the data but also find a way to interpret and present it accurately. The integration of AI modeling with geospatial tools was a key success factor.
Key Features
- Loading, cleaning and normalisation of raw vehicle data from the client's database
- Plausibility checks and agreed value ranges for key vehicle signals
- Dashboard screen with dynamic indicators and charts for the monitored vehicles
- Map view showing vehicle positions
- Web-based demonstrator hosted and monitored by EMBIQ during the review period
- Comparison of off-the-shelf visualisation tools before choosing the approach
- Iterative releases reviewed with the client's team
The result
EMBIQ delivered a working web dashboard in iterations: the indicator screen was released first, followed by the map view, and each release was reviewed with the client's team. Those reviews proved valuable in their own right, because the dashboard made anomalies and inconsistencies in the source data visible that had been hard to spot in raw records, and they could be discussed and resolved with the client's experts. The data loading and pre-processing logic built for the proof of concept was agreed as the foundation for later, more advanced analytics, so that further stages would not have to start from scratch. After the demonstrations, the client asked EMBIQ to scope and estimate the next phase, covering deeper analytics built on the same data foundation.
- Raw vehicle data presented as clear, visual indicators
- Data quality issues surfaced and resolved together with the client's experts
- Reusable foundation for data loading and pre-processing
- Working demonstrator available for internal presentations
Integrating with various source data was a pivotal element of this project. Leveraging our skills and experience, we created a solution that met the client's expectations. The real-time processing and normalization of data were critical in achieving the desired outcomes.
What kind of competencies are you looking for?
Contact me to discuss your requirements and build your dedicated IT team together with us.
Agnes
business development specialist
Get a quote or advice
Let’s investigate your project concept and its current status together.
Expect an initial project scope proposal, time and cost estimation from us.
The consultancy will be protected by the NDA.