This Power BI dashboard provides a comprehensive overview of sales performance, breaking down key metrics by different dimensions like sub-category, payment mode, customer name, and month.
Dashboard_components:
Sales Dashboard Title: Clearly identifies the purpose of the dashboard.
Quarterly Performance: This section shows four cards representing each quarter. The cards display the sum of quantity, profit, and amount for each quarter.
Sum of Profit by Sub-Category: This chart displays the total profit generated by different sub-categories. Printers contribute the most, followed by Bookcases.
Sum of Quantity by Payment Mode: This pie chart illustrates the proportion of transactions made using different payment methods. The blue segment represents the largest proportion, likely indicating a dominant payment mode.
Sum of Profit by Sub-Category (Right): This bar chart provides a visual representation of the same data as the previous horizontal bar chart.
Sum of Quantity and Sum of Amount by Category: This doughnut chart showcases the proportion of quantity and amount for different product categories. This offers insight into which categories drive the most sales volume versus revenue.
Sum of Amount by Customer Name: This bar chart shows the total sales amount generated by different customers. Vrinda and Yogesh are the top-performing customers.
Sum of Profit by Month: This line chart depicts the trend of profit generated over a year. There is a seasonal pattern, with the highest profit in December and the lowest in July.
Key Insights:
Printers contribute significantly to the total profit.
Blue payment mode is the most popular method, potentially indicating an online payment option.
Vrinda and Yogesh are the top-performing customers.
Sales fluctuate throughout the year, with peak sales in December.
Possible Improvements:
More detailed sub-category analysis: Adding a drill-down feature to further explore performance within each sub-category.
Time frame flexibility: Allowing users to change the time frame for the monthly profit chart.
Customer segmentation: Adding a segment for high-value customers or customer lifetime value analysis.
Trend analysis: Adding trend lines to the monthly profit chart to visualize long-term sales patterns.
Overall, this dashboard provides a good starting point for sales performance analysis.