Super Store Sales Analysis

Challenge

Across four years of orders, which segments, categories, and states actually carry profit — and is the trend improving or just noisier?

Approach

A single-page executive sales dashboard over a star-schema model with customer, product, geography, date, and ship-mode dimensions, filterable by year, region, and shipping method.

Outcome

1. 2.90M in sales produced 360.13K in profit, with quarterly profit growing from 4K to a 62K peak in Q3 2019.
2. The Consumer segment drives 53% of sales (1.55M), while Home Office contributes only 17% — a clear targeting signal.
3. Technology leads category sales, with Office Supplies close behind on volume but thinner returns.
4. Sales concentrate heavily in California and New York, exposing a geographic dependency worth diversifying.