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