✅ Sales Dashboard Analysis Project
🎯 Project Goal
The goal of this project is to analyze sales data and create an interactive dashboard that helps businesses understand:
• Which products sell the most
• Which regions generate the highest revenue
• Monthly sales trends
• Profit performance
• Customer purchasing behavior
This project is one of the most common real-world Data Analyst projects used in portfolios and interviews.
🛠 STEP 1: Choose a Dataset
Recommended Datasets
You can use any of these datasets:
1. Superstore Dataset
Best for beginners.
Contains:
• Orders
• Customers
• Products
• Sales
• Profit
• Region
• Category
2. Amazon Sales Dataset
Good for e-commerce analytics.
3. Kaggle Sales Datasets
Search:
• “Superstore Sales Dataset”
• “E-commerce Sales Data”
• “Retail Sales Dataset”
📂 STEP 2: Understand the Dataset
Before building dashboards, understand every column.
Example Columns
Order ID
• Meaning: Unique order number
Order Date
• Meaning: Date of purchase
Customer Name
• Meaning: Customer details
Region
• Meaning: Sales region
Category
• Meaning: Product category
Product Name
• Meaning: Product sold
Sales
• Meaning: Revenue generated
Profit
• Meaning: Profit earned
Quantity
• Meaning: Number of products sold
🧹 STEP 3: Data Cleaning
Data cleaning is one of the MOST important steps in Data Analytics.
Clean the Data Using:
• Excel
• Power Query
• Python Pandas
• SQL
Tasks to Perform
✔ Remove Duplicate Rows
Duplicates create incorrect insights.
Example:
Same order repeated multiple times.
✔ Handle Missing Values
Check:
• Blank sales
• Missing customer names
• Empty regions
Methods:
• Remove rows
• Replace missing values
• Use averages/default values
✔ Correct Data Types
Examples:
• Sales → Decimal/Number
• Order Date → Date format
• Quantity → Integer
✔ Standardize Text Values
Example:
• “West”
• “west”
• “WEST”
All should become:
• “West”
📊 STEP 4: Create KPIs (Key Performance Indicators)
KPIs are the most important metrics for businesses.
Essential KPIs
1. Total Sales
Formula:
SUM(Sales)
Purpose:
Shows total revenue generated.
2. Total Profit
SUM(Profit)
Purpose:
Shows business profitability.
3. Total Orders
COUNT(Order_ID)
4. Average Order Value
SUM(Sales) / COUNT(Order_ID)
5. Profit Margin
(Profit / Sales) * 100
Purpose:
Shows business efficiency.
🗄 STEP 5: Analyze Data Using SQL
Now start analyzing the data.
📌 SQL Query Examples
1. Total Sales by Region
SELECT Region,
SUM(Sales) AS Total_Sales
FROM Orders
GROUP BY Region
ORDER BY Total_Sales DESC;
2. Top Selling Products
SELECT Product_Name,
SUM(Sales) AS Total_Sales
FROM Orders
GROUP BY Product_Name
ORDER BY Total_Sales DESC
LIMIT 10;
3. Monthly Sales Trend
SELECT MONTH(Order_Date) AS Month,
SUM(Sales) AS Total_Sales
FROM Orders
GROUP BY MONTH(Order_Date)
ORDER BY Month;
4. Most Profitable Category
SELECT Category,
SUM(Profit) AS Total_Profit
FROM Orders
GROUP BY Category
ORDER BY Total_Profit DESC;
📈 STEP 6: Build Dashboard in Power BI or Tableau
Now convert insights into visual dashboards.
🎨 Dashboard Layout
Section 1: KPI Cards
Add:
• Total Sales
• Total Profit
• Total Orders
• Profit Margin
These should appear at the TOP.
Section 2: Charts
✔ Line Chart
Use for:
• Monthly Sales Trend
X-axis:
• Month
Y-axis:
• Sales
✔ Bar Chart
Use for:
• Top Products
✔ Pie Chart
Use for:
• Sales by Category
✔ Map Visualization
Use for:
• Region-wise Sales
✔ Table Visualization
Show:
• Product
• Sales
• Profit
• Quantity