SSUPERSTOREPROFITABILITY EXPLORER
View analysis ↗

A BUSINESS ANALYTICS CASE STUDY

Find where margin
leaves the business.

Explore the regional and product mix behind $2.30M in sales.
Every view responds to your selected scope.

Loading verified data…

SALES

—Selected scope

PROFIT

—Sales less recorded costs

PROFIT MARGIN

—Total profit ÷ total sales

ORDER LINES

—Transaction rows, not unique orders
ANALYST NOTE

Loading the selected scope.

REGIONAL PERFORMANCE

How do regional margins compare?

Margin %

Profit divided by sales within each region. Selected filters apply.

PRODUCT DIAGNOSTIC

Where is profit under pressure?

Profit $

The six lowest-profit subcategories in the selected scope.

THE EVIDENCE

Compare the regions

RegionSalesProfitMarginOrder lines
Metric definitions & interpretation

Profit margin is calculated from aggregate profit and sales, never by averaging row-level percentages. Order lines are distinct transaction rows. The source contains 9,994 lines and 5,009 unique orders; unique orders are not summed across product groups.

Observed margin differences motivate investigation of product mix, pricing and discounting. They do not establish causal effects or the profit uplift of a proposed intervention. Dispatch time and delivery time are different metrics; this profitability view does not infer delivery performance.

The original coursework was a group project. The repository credits the team and documents the revised, executable analysis. This interactive companion was prepared with AI assistance. Data source: the CSV committed in the linked repository.