Global Superstore Analytics Dashboard
An interactive Tableau dashboard suite that transforms raw superstore sales data into actionable insights about profit, delays, discounts, and operational performance across markets, managers, and product categories.
Launch Live DashboardThis project delivers a complete business intelligence solution built on the Global Superstore dataset. It features 25+ worksheets, 11 dashboards, and numerous calculated fields that empower stakeholders to:
- Monitor KPIs (revenue, profit, quantity, delays)
- Analyze profit ratios & discount effectiveness
- Identify loss-making segments & delayed orders
- Drill down by region, manager, category, country
- Compare annual profit trends (2019–2022)
All dashboards are interactive — filters, highlight actions, and URL actions (e.g., Wikipedia lookup for countries) provide an intuitive exploration experience.
| Dashboard | Purpose |
|---|---|
| Home Page | Central navigation hub |
| Profit Analysis Dashboard | Profit ratio, profit status, and category breakdown |
| Sales Analysis Dashboard | Sales over time, by category, city, and state |
| Category Analysis | Sales and net sales per product category |
| KPI Analysis by Country / Sub‑category | Country‑level and sub‑category performance metrics |
| Monthly Loss Analysis by Market | Track loss counts and total quantity lost per market |
| Average Discount Analysis By Region | Discount distribution and its impact |
| Analysis By Manager Dashboard | Profit and discount performance per manager |
Profit Status
Labels each row as Profit, Loss, or No Loss No Profit.
Profit Ratio
SUM(Profit) / SUM(Revenue) — overall margin indicator.
Delay Days
DATEDIFF between expected & actual ship dates.
No. of Delayed Orders
Count of orders with Delay Days > 0.
Annual Profit (2019-2022)
Separate fields for year-over-year profit tracking.
Profit Ratio Category
Tier classification: C1 (≥0.25), C2, etc.
Interactive Actions
- Filters – Segment, Order Priority, Market, Region, Sub‑Category, Country, Manager
- Highlight Action – dynamic mark selection
- URL Action – opens Wikipedia page for selected country
Visual Identity
Custom color palette:
Name: Orders+ (Global Superstore) — Excel/CSV (standard Superstore dataset).
Key tables: Orders, Returns, People (managers), Shipping costs.
Preprocessing: No external ETL — all transformations (calculated fields, aliases, hierarchies) are embedded inside the .twb file.
- Filter Quantity By Segment & Order Priority – interactive segregation
- Filter losses by Market – isolate loss-making zones
- Filter KPIs By Sub-Category / Country – granular drill-downs
- Show Country Wikipedia Page – external URL action adds context
- Highlight 1 (generated) – dynamic highlighting across charts