
SUPERSTORE SALES DASHBOARD (TABLEAU CASE STUDY)
Project Goal:
Using the popular Superstore dataset from Kaggle, I built an interactive Tableau dashboard to analyze sales, profit, and customer trends. The goal was to demonstrate my ability to transform raw data into meaningful insights that help businesses optimize performance, identify key growth opportunities, and monitor KPIs in real time.
This project serves as a showcase of my data visualization, dashboard design, and analytical storytelling skills.
Tools Used:
-
Tableau
-
Excel
Solution:
-
Data Preparation:
-
Cleaned and organized the Superstore dataset in Tableau.
-
Defined relevant dimensions (e.g., region, category, segment) and measures (e.g., sales, profit, discount).
-
Created calculated fields for deeper insights, including profit ratio, YoY growth, and average order value.
-
-
Dashboard Design:
-
Built a multi-view interactive dashboard highlighting sales trends, category performance, and regional insights.
-
Applied filters for category, sub-category, and region to allow dynamic exploration by the end-user.
-
Designed KPI cards to track key metrics such as Total Sales, Profit, and Quantity Sold.
-
-
Visualizations:
-
Bar Chart: Category & sub-category performance comparison.
-
Line Chart: Sales and profit trend over time.
-
Map Visualization: Geographic sales distribution across states/regions.
-
Tree Map: Contribution of sub-categories to total revenue.
-
-
Interactivity:
-
Added hover tooltips for detailed drilldowns.
-
Implemented parameter controls and filters to help users analyze specific product lines, customer segments, or time periods.
-
Linked visualizations together for seamless navigation.
-
Results:
-
Identified top-performing product categories and underperforming ones that drive losses.
-
Highlighted regions contributing the most sales vs. those with low profitability.
-
Segments (Consumer, Corporate, Home Office) showed distinct buying patterns, supporting targeted marketing strategies.
-
Dashboard design can be applied to any retail dataset for monitoring sales KPIs and optimizing business decisions.