Data transformation and visualisation of networked household appliances

Processing of data from networked household appliances and calculation of important KPIs and visualisation in dashboards.
/
Build and go live with a robust Big Data pipeline with more than 10 TB of processed data.
Visualisation of usage data in dashboards
+
Over 50 users use the provided front-ends for analysis purposes

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?