In the world of retail, data-driven decisions are the difference between growth and stagnation. This project showcases a comprehensive Tableau dashboard that transforms raw sales data into clear, actionable insights.
The dashboard tells the story of a fictional Superstore, revealing:
- How sales and profit evolve over time
- Which regions and products drive growth
- What segments contribute most to business success
📌 Designed with interactivity, clarity, and real-world decision-making in mind, this dashboard empowers analysts, managers, and stakeholders to unlock the why behind the numbers.
- Source: Kaggle - Sales Forecasting Dataset
- Records: ~10,000 rows
- Key Columns:
Order ID
,Product Category
,Sub-Category
Sales
,Profit
,Discount
,Quantity
Order Date
,Ship Date
Segment
,Region
,State
,Customer ID
🧹 Data Cleaning and preprocessing were performed in Excel before visualization.
- Total Sales, Total Profit, Order Count
- Profit Margin calculated dynamically
- Yearly and monthly trend lines to detect seasonality and growth patterns
- By Product Category and Sub-Category
- Identify underperforming or high-potential items
- Map visuals show sales and profits across States and Regions
- Compare Consumer, Corporate, and Home Office segments
- Ranked by sales for quick strategic focus
- Slice data by Month Name and Customer Name
Tool | Purpose |
---|---|
Tableau | Visualization & Dashboard Building |
MS Excel | Data Cleaning & Structuring |
Kaggle | Source of Retail Dataset |
-
Download Dataset
→ Sales Forecasting Dataset on Kaggle -
Open Tableau Desktop or Tableau Public
-
Connect to the Excel File
Ensure correct sheet and data types -
Open the Dashboard File
If available (.twb
/.twbx
), simply double-click to explore -
Interact and Analyze
Use built-in filters to dive into specific customer names or months
Vedika Sankhe
🎓 Aspiring Data Analyst | 📊 Tableau & Power BI Enthusiast | 💡 Turning Numbers into Narratives
If you have ideas to improve this dashboard, feel free to open an issue or submit a pull request.
Collaboration is welcome!
This project is open-source and available under the MIT License.