The Coca-Cola Company is the world’s largest beverage group. Our solution covered the Coca‑Cola Southern and East Africa Business Unit (SEABU) headquartered in Johannesburg, South Africa. Coca‑Cola SEABU covers 18 countries in Sub-Saharan Africa.

Solution

Sunesis sought to develop an ETL package that was able to extract data from different files and sources and loaded into a staging repository. The data was then transformed and transferred to the central repository ready for reporting.

With the use of Power BI, we developed dynamic Power BI dashboards and reports with different access levels. The ETL Package was set to auto run at specific time intervals as well as the Power BI Dashboards refresh process.

Finally, the adoption of the solution deployment includes knowledge transfer.

Technologies Used

1.Azure SQL Database
2.MS Excel
3.Power BI Desktop
4.Power BI Service
5.Power BI Gateway
6.SSRS Report