Finding Profit Drivers
Find which products actually drive your profit
Data Stories LabInteractive dashboardBicycle retail · profit model
Loading data…
-
Total revenue
All time sales
-
Total profit
Net earnings
-
Profit margin
Revenue to profit ratio
-
Total orders
Units sold
Year-to-date performance
Cumulative revenue and profit build through the year
Source: bicycle retail transaction data.
Revenue vs profit trend
Monthly revenue (left axis) against profit (right axis)
Source: bicycle retail transaction data.
Average order value over time
Revenue per unit sold, month by month
Source: bicycle retail transaction data.
Revenue mix by product category
Where the revenue comes from across categories
Source: bicycle retail transaction data.
Top profit contributors (by model)
The ten models that generate the most profit
Source: bicycle retail transaction data.
Sales vs profit reality (products)
High revenue does not always mean high profit
Source: bicycle retail transaction data.
Profit by subcategory
Profit ranked across product subcategories
Source: bicycle retail transaction data.
Product performance table
Revenue, profit, margin and orders for the top models
| Model | Category | Revenue | Profit | Margin % | Orders |
|---|
Source: bicycle retail transaction data.
Revenue by country
Total revenue across operating regions
Source: bicycle retail transaction data.
Profit by country
Total profit across operating regions
Source: bicycle retail transaction data.
Busy vs profitable locations
City revenue against city profit
Source: bicycle retail transaction data.
Top 10 cities by profit
The cities carrying the most profit
Source: bicycle retail transaction data.
Location performance table
Revenue, profit and margin for the top cities
| Country | State | City | Revenue | Profit | Margin % |
|---|
Source: bicycle retail transaction data.
-
Net profit
Bottom line
-
Avg profit per order
Per transaction
-
Low margin items
Need attention
-
High margin items
Strong performers
Profit sources by category
Which categories the profit really comes from
Source: bicycle retail transaction data.
Profit concentration (Pareto)
A few models account for most of the profit
Source: bicycle retail transaction data.
Underlying profit trend (monthly)
Monthly profit over the period
Source: bicycle retail transaction data.
Profit leaks, low margin products
Products below a 30% margin that need review
| Product | Category | Revenue | Profit | Margin % | Status |
|---|
Source: bicycle retail transaction data.