The customer's need was to be able to consult, in an easy and intuitive way, the test data on engine emission. The tests are carried out directly in the production sites, present worldwide and have the aim of measuring various pollutants, such as: CO2, NOx, PM, NH3, CH4, CO under specific conditions of use.
The results of these tests, called COP - Coefficient Of Performance, are subsequently compared with two macro types of limits:
The challenge undertaken by Technology Reply, for the realization of this project, mainly concerned two key points:
Technology Reply took care of the technological implementation of the functional requirements on the QlikSense platform, of the definition and development of the entire data pipeline, from the ingestion phase to the visualization and analysis of the data.
Different ETL procedures and a Data Quality process have been realized on the backend side.
Thanks to that, heterogeneous data, coming from different data sources, have been integrated.
These data have been cleaned up, normalized, filtered and reorganized in order to make them homogeneous and as suitable as possible for subsequent business intelligence analysis.
On the frontend side, an interactive dashboard was implemented via the QlikSense platform to facilitate the reading of data and KPIs by end users.
The design of the frontend solution was shared with the end users through the creation of graphic mockups and step by step an intuitive layout was created, which would meet the user's request to facilitate its use and adoption by the department of Technical Certification.
The front end structure contains an overview page that allows users to view, immediately and with a macro detail, the total quantity of tests carried out. That tests are divided into:
From the overview section it is possible, through dedicated links, to land on three different detail pages with a table view that allows you to analyze:
A conventional formatting has been adopted on each section to allow the rapid identification of any alert conditions: