Real-Time Sales Dashboard for FMCG Distributor

Sales and stock figures for eight distribution centres were compiled by hand in Excel each week. By the time leadership saw them the numbers were already out of date, and different teams reported different totals for the same period.

Stockouts on fast moving lines were usually discovered only after customers complained.

• Agreed a single KPI framework with sales, finance and operations before building anything.
• Connected the SQL warehouse to a governed Power BI semantic model with row level security by region.
• Built an executive dashboard covering more than 200 SKUs, with drill down to centre and product level.
• Scheduled a daily refresh and configured alerts when stock cover for a line fell below its threshold.

Leadership now works from one set of numbers refreshed every day. Decisions on replenishment and promotions are made 40% faster, and earlier stockout warnings contribute to an estimated $180K saved each year.

The internal analyst team received training and documentation so they can extend the model themselves.