Project overview

This project involved developing dashboards both in Excel and MS Power BI for monitoring the client’s sales, budgets and stocks across multiple sales outlets spread in over 10 countries in Africa. The client needed an automated data cleaning and consolidation process, as well as dashboards with advanced filters and reporting capabilities.

Technology stack used:
– MS Power BI
– MS Power Query
– MS Power Pivot

Completion:
The project was completed in 2 months

View report

Benefits:

  • 75% time savings on shaping of data and analysis.
    The client now just pastes incremental data and press ‘Refresh’ and dashboards both in Excel and Power BI are ready.

  • More time exploring the insights and ways to improve business. Coming up with a PowerPoint presentation has become a bliss

  • PowerPoint presentation has become a bliss