Sales Overview Dashboard - Power BI
Sales Overview Dashboard - Power BI
Embedded Files
The Sales Overview Dashboard project involves using Power BI to create an interactive tool for visualizing key sales metrics and performance. It will provide insights into total sales, revenue trends, and product performance, helping users make data-driven decisions. The dashboard aims to improve business intelligence and support strategic decision-making.
The Sales Overview Dashboard project involves using Power BI to create an interactive tool for visualizing key sales metrics and performance. It will provide insights into total sales, revenue trends, and product performance, helping users make data-driven decisions. The dashboard aims to improve business intelligence and support strategic decision-making.
Key Summary
Key Summary
Sales for last 3 months :
Sales for last 3 months :
Monthly Sales Performance:
December: Rp. 807,642,304 (+3.8% from November)
November: Rp. 777,896,048 (+40.1% from October)
October: Rp. 554,822,931
December Sales Breakdown:
Sales Channels:
Offline Store: 55.60% (Rp. 449,018,116)
Online Store: 44.40% (Rp. 358,624,188)
Customer Demographics:
Male Customers: 50.83% (Rp. 410,533,917)
Female Customers: 49.17% (Rp. 397,108,387)
Sales by City:
Depok: Rp. 324,518,751 (40.2% of total sales)
Tangerang: Rp. 163,507,022 (20.2% of total sales)
Bogor: Rp. 161,678,671 (20.0% of total sales)
Jakarta: Rp. 157,937,860 (19.6% of total sales)
Key Insights:
Key Insights:
Consistent Growth: Sales have shown an upward trend, with a significant increase in November and steady growth in December.
Balanced Channel Contribution: Offline sales slightly outpace online sales, indicating potential for growth in digital channels.
Equal Gender Distribution: Male and female customers contribute almost equally, offering opportunities to target both demographics effectively.
City Performance: Depok leads sales contributions, while Tangerang, Bogor, and Jakarta follow closely with relatively even distribution.
Recommendations:
Recommendations:
Enhance Online Presence: With 44.40% of sales coming from online channels, invest in digital marketing, promotions, and user experience to capture more market share online.
Focus on High-Performing Cities: Strengthen marketing efforts in Depok while exploring untapped potential in Tangerang, Bogor, and Jakarta.
Leverage Customer Segmentation: Develop targeted campaigns for both male and female customers to capitalize on the balanced contribution and drive loyalty.
Seasonal Promotions: Continue leveraging growth momentum through tailored holiday or end-of-season campaigns to sustain sales increases in coming months.
Offline Optimization: Maintain a strong offline presence while enhancing store experience to retain customers and drive repeat purchases.
This strategy ensures sustainable growth while capitalizing on current strengths and addressing key opportunities.
Page updated
Google Sites
Report abuse