Data transformation and visualisation of networked household appliances
Challenge
-
A household appliance manufacturer would like to
analyse the use of its products and identify errors and faults -
The data from the networked devices is stored in the cloud and is to be made available to all stakeholders through various dashboards
Solution
-
Design of a scalable end-to-end data architecture in the Azure Cloud (e.g. use of Azure Data Factory)
-
Setting up a data transformation path with Spark for the daily preparation of machine data into a relational database
-
Development of a CI/CD pipeline to automate the testing and deployment process (Azure DevOps)
-
Calculation of relevant KPIs and visualisation of the data in various dashboards using Power BI
-
Customer segmentation based on device usage data
Result
-
Stakeholders can now derive better recommendations for action, as the use of the device can be closely examined
-
Further data-driven use cases such as development of new features and optimisation of the portfolio were made possible.
Are you interested in your own use cases?