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.