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 East Africa, the Horn of Africa region, and Southern Africa.
Given the client files had no standard format, we 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 Power BI tool, 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 included training the trainer sessions.