Sales Dashboard using Power BI





π Sales Dashboard using Power BI
π Dashboard Breakdown
Total Quantity Sold: 49K units
Top Customer Segments
- π₯ Gold: 17K
- π₯ Silver: 17K
- π₯ Bronze: 15K
Highest Selling Product Category: Electronics (34%)
Top Performing Subcategory: Headphones (24.16%)
Best Performing States: Armed Forces (various), Montana, Nevada, Wisconsin (8% each)
π Segment-Level Insights
π₯ Gold Customers
- Total Sales: 17K
- Monthly Trend: Highs in Jan (1.8K) and Jul (1.7K); dip in Jun (0.9K)
- Stability: Volatile with Nov recovery (1.5K)
π₯ Silver Customers
- Total Sales: 17K
- Monthly Trend: Steady growth, peak in Sep (2.1K)
- Stability: Consistent
π₯ Bronze Customers
- Total Sales: 15K
- Monthly Trend: Weak MarβMay; peaks in Jul (1.7K) and Sep (1.2K)
- Stability: Most volatile segment
ποΈ Product-Level Insights
π§ Subcategory Performance
- Headphones β 24.16%
- Academic β 14.4%
- Shirt β 11.4%
- Action Dolls β 8.9%
- Gardening β 8.4%
β
Recommendation: Focus marketing and inventory on Headphones, Academic materials, and Apparel.
π§© Product Categories
- Electronics: 17K units (34%)
- Books: 13K units (25.29%)
- Toys: 9K units (17.2%)
- Home & Garden: 7K units (13.52%)
- Clothing: 5K units (9.94%)
π¦ Inventory Planning: Prioritize Electronics and Books in procurement and promotion.
π Geographic Distribution
- Top Contributor: Armed Forces regions β 15%, 13%, 12%
- Other Strong States: Montana, Nevada, Wisconsin β 8% each
- Moderate States: Alaska, North Dakota, Washington β 7% each
π Insight: Contract-based demand likely in Armed Forces regions. Consider niche targeting and fulfillment strategies.
π Trends & Red Flags
π Underperformance Alert: Bronze segment is flat across months. Subcategories like Decor, Camera, and Furniture contribute less than 5%.
π Optimization Opportunities:
β’ Personalize promotions for Bronze customers
β’ Use geo-marketing to penetrate under-7% states
β’ Personalize promotions for Bronze customers
β’ Use geo-marketing to penetrate under-7% states
π‘ Strategic Recommendations
- Amplify High-Performers: Push electronics and headphones during peak months (Jan, Sept)
- Targeted Retention: Loyalty offers for Bronze customers
- Stock Reallocation: Reduce low-performing categories
- Forecasting: Prepare for future spikes based on past peaks




















