Tool Used: Power Bi
Date: September 2025
Role: Dashboard Designer & Insight Analyst
📊 Business Context
Analyzed regional sales performance across FMCG categories to identify underperforming SKUs and optimize distribution strategy.
🔍 Key Insights
Brand Performance
- Brand1 leads with ₹6.2M revenue — strong market presence
- Brand6 underperforms — may need review or repositioning
Regional Trends
- Western region contributes the highest revenue (~₹6.5M) — strong geographic performance
- Eastern region shows similar brand power but lower sales (~₹4M) — may need targeted campaign
Channel Distribution
- Online channel drives 50% of total sales — digital strategy is key
- Retail and Wholesale channels underperform — potential for optimization
Sales Over Time
- Revenue peaks mid-year — suggests seasonal demand or campaign impact
- Brand3 shows consistent growth — potential for bundling or upselling