SALES
—Selected scopeA 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.
PROFIT
—Sales less recorded costsPROFIT MARGIN
—Total profit ÷ total salesORDER LINES
—Transaction rows, not unique ordersLoading the selected scope.
REGIONAL PERFORMANCE
How do regional margins compare?
Profit divided by sales within each region. Selected filters apply.
PRODUCT DIAGNOSTIC
Where is profit under pressure?
The six lowest-profit subcategories in the selected scope.
THE EVIDENCE
Compare the regions
| Region | Sales | Profit | Margin | Order 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.