The goal of this project is to analyze global sales performance, profitability, and pipeline trends using the Sample Sales Dataset from Kaggle. The dashboard provides insights that support business decision-making in areas like customer management, product strategy, and sales pipeline performance.
- Source: Kaggle – Sample Sales Data
- Records: 2,823 sales transactions
- Key Columns:
- Customer, Country, Product Line, Deal Size
- Order Date, Sales, Quantity Ordered
- Status (Shipped, On Hold, Resolved, Cancelled, etc.)
- Power BI → Dashboard development & DAX calculations
- Excel / Google Sheets → Validation & quick calculations
- DAX → Created calculated columns for COGS, Profit, Profit Margin, Pipeline Stage
- Total Sales: $10.03M
- Total COGS: $7.02M
- Total Profit: $3.01M
- Profit Margin: 30%
- Sales & Profit by Product Line
- Sales & Profit by Country
- Sales & Profit by Deal Size
- Top 10 Customers (by Sales & Profit)
- Pipeline Funnel → Proposal → Qualified → Won → Lost
- Pipeline Trend by Month (with Year slicer)
- Order Status Analysis (Shipped, Cancelled, Disputed, Resolved, On Hold, etc.)
- Sales ↔ Profit toggle buttons across all charts
- Slicer for Order Year (applied only to Pipeline Trend)
- Small deal sizes generate higher profit margins compared to medium/large deals.
- Top 10 customers are responsible for a major portion of revenue and profitability.
- Year-end spike in Won deals indicates seasonal sales push.
- Certain product lines drive revenue but at thin margins – need margin improvement strategy.
- Order status analysis shows majority as Shipped, but attention needed on Cancelled & Disputed cases.
