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
The project was completed in 2 months
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