Superstore Sales Dashboard

An interactive view of sales, profit, and customer segments across U.S. regions from 2014–2017.

This project was developed in Tableau using the Superstore dataset to demonstrate interactive dashboard design and business insights. Users can interact with filters and charts to drill into specific customer groups, states, or product lines.

Explore this interactive dashboard here.

Dataset Overview

The Tableau Sample Superstore dataset contains 9,994 rows and 21 columns, each representing an individual order line. It includes variables such as sales amount, order date, shipment date, product details, and customer segments between January 2014 and December 2017.

📌Data Quality

✅ Duplicates: 0

✅ NaN Values: 0

✅ Missing Values: 0

✅ Wrong Data Types: 0

✅Inconsistent Dates (Ship < Order): 0

📌 Outlier Detection

🟨 Sales: 1,167

🟨 Profit: 1,881

🟨 Discount: 856

🟨 Quantity: 170

Note: Outliers are expected in retail transactions and were retained to reflect real business scenarios.

Key Findings

Sales vs Profit → Total sales reached $2.30M with $286K profit, showing profit margins are thin and fluctuate more than sales, signalling possible discounting or cost issues.

Customer Segmentation → Consumers dominate with 52% of orders, followed by Corporate (30%) and Home Office (18%), indicating a strong retail-driven business model.

Top Categories → Binders (5,974 units) and Paper (5,178 units) are the most ordered products, highlighting high-volume, low-margin categories.

Regional Distribution → States like California and New York contribute heavily to order volume, while central and southern states show weaker activity.

Shipment Performance → Average shipment days vary by state (≈2.9 to 5.7 days), suggesting room for logistics optimization in slower-shipping regions.

Recommendations

While sales continue to grow, profit margins remain thin due to reliance on low-margin products (e.g. Binders, Paper). This highlights the need for margin optimization through pricing adjustments, better discount management, and focus on higher-margin categories.

Page updated

Google Sites

Report abuse