A store made $2.3M in revenue and was still losing money. Here’s where it was going wrong.
I built a Sales & Profit Analysis dashboard covering 4 years of data
And the numbers told a story revenue alone would never show.
The findings:
📍Furniture had $740K in sales but only $20K in profit
📍Tables and Bookcases had negative margins which means selling more meant losing more
📍The South region was bleeding compared to every other region
📍Technology was quietly carrying the entire business
The fix wasn’t complicated once the data was clear:
✅Reduce Furniture discounts and renegotiate supplier costs
✅Invest more in Technology since it’s already winning
✅Study the West region and replicate it in the South
That’s what a good dashboard does.
Not just show numbers
It shows you exactly where to act.
This dashboard was built with Power BI.
The hardest part was knowing which questions to ask before touching the tool.
What’s one business decision in your industry that data could make obvious but most people still make on gut feeling?