Skip to main content
USE CASE

Automated dashboard for product availability

CASE STUDY

An international beverage manufacturer supplies various products to a national supermarket chain.

The challenge

  • Goal: Analysis of product availability in each supermarket region through automated data transformation
  • Time-consuming, manual creation of monthly reports
  • Creation of individual dashboards for each region
  • High susceptibility to errors due to manual processes

Solution

  • Creation of data links to various Excel files using Excel Power Query
  • Automatic data update
  • Combination of individual dashboards for each region into a single dashboard by integrating a region filter

Result

  • ONE automated dashboard with data on the availability of relevant products
  • Monthly, automatic updating of the data
  • Error-free process due to elimination of manual work