Business intelligence case study · 2019–2020

Superstore Sales Intelligence

Explore sales, profit, orders, product performance and geographic results. Every selection updates the full view from aggregated order data.

Sales—USD, sum of line sales

Profit—USD, sum of line profit

Profit margin—Profit / sales

Order lines—Transaction line count

Units sold—Sum of quantity

Monthly sales

Sales by category

Profit by region

Customer segment share

Subcategory sales vs. profit margin

Sales intensity by region and month

Subcategory performance

Subcategory	Sales	Profit	Margin

Returns data quality: the workbook’s Returns sheet contains 296 distinct order IDs, but none match the 2019–2020 Orders sheet. Return rate is intentionally excluded until matching records are supplied.

Source: uploaded “Superstore Dataset.xlsx”, Orders and Returns sheets. All amounts are represented as USD for this Superstore sample; no exchange conversion is applied. Filtered metrics use order lines in the selected slice, and distinct orders may appear in multiple categories.