The business problem
Revenue alone doesn’t tell a retailer where the money is really made. This dashboard pairs revenue with profit at every level — by stock category, by customer type, and by month — so the business can see which products and customers actually drive the bottom line.
What it covers
- Revenue, net profit, order count, and average profit per order as headline KPIs
- Revenue and profit broken down by stock category
- Customer-type profitability, from novelty shops to supermarkets to corporate buyers
- Profit performance tracked by year and by month
- Total revenue vs profit trend comparison
What the business gets
- A clear view of which categories and customer types are most profitable
- Month-by-month profit trends for planning and targets
- Revenue and profit side by side, instead of in separate reports
Technology
Power BI DAX Power Query
Start the conversation
Need reporting like this?
Tell us about your data and the decisions it should support.