East African Retail Sales Analysis

About the Analysis: Messy transaction data from three markets, cleaned and modelled into one dashboard that answers four questions: where revenue comes from, which products earn it, when it peaks and which stores carry it.

What the Data showed: Three of 13 stores brought in about 40% of revenue, and beverages sold in high volume but earned the least. July peaked at 1.7 times the weakest month with no clear cause. Each becomes a decision: review the weakest stores, reprice, bundle or drop low earners, investigate July, and fix data capture at source. Explore the dashboard and report for the detail.

ToolsPower BI, Power Query, DAX, GitHub
Portfolio project built on synthetic data. No real people or organisations are represented.

Explore the work