
๐ Dashboard Ideas
Sales Performance Overview
Total Sales, Total Profit, Total Quantity (cards or KPI tiles)
Profit by Product Category/Sub-Category (bar/column chart)
Customer Segmentation
Sales by Segment (Consumer, Corporate, Home Office)
Profitability by Segment (stacked bar or pie chart)
Geographic Analysis
Map visual: Sales by City or Country using lat and lon
Tooltip: Show top product or total profit per location
Shipping Insights
Average Shipping Time = DATEDIFF(Order Date, Ship Date, DAY)
Sales by Ship Mode (bar chart)
Time Series
Sales Trend Over Time (Order Date on x-axis, Sales on y-axis)
Dataset Link : https://www.kaggle.com/datasets/mdshamsirshad/power-bi-customer-service-analysis?select=Dataset-DV.xlsx
