Data 035 · Final case study · Adventure Works, 2020 to 2022
Adventure Works sales and profit
Bikes bring in — of sales, led by
—
(—).
The sharpest monthly drop is —,
down — on the month before.
Sales, 2020 to 2022—Order quantity × product price
Profit, 2020 to 2022—Order quantity × (price − cost)
Profit margin—Profit ÷ sales
Bikes share of sales—Of all categories
Requirement quadrant
AudienceVP of Sales, VP of Marketing and VP of Product.
DataAdventure Works sales, products, customers and territories, up to 2022. Sales and profit are worked out per order line.
Goal 1Examine products and their sales and profit
- What are the sales and profits by category and subcategory?
- What are the top and bottom selling products?
- What are the sales and profit trends?
Goal 2Examine sales and customer demographics
- What are the sales by country?
- What are the sales by occupation?
- What are the sales by income range?
Goal 1: products, sales and profit
Sales and profit by category and subcategory
Box size shows sales. Hover a box for its profit. Colour shows category.
Top 10 product models by sales
Hover a bar for profit.
Bottom 10 product models by sales
Hover a bar for profit.
Sales and profit by month
The dashed line marks the largest month-on-month fall in sales.
Goal 2: sales and customer demographics
Sales by country
Hover a bar for profit.
Sales by income range
Annual household income of the buying customer. Hover a column for customer count.
Sales by occupation and category
Each bar splits an occupation's sales by product category.
Conclusion and key takeaways
Conclusion
The analysis shows clear differences between categories and product models. Some segments deliver strong profit and should stay the focus, while others are chances to improve. Concentrating on the top performers and optimizing the low performers supports steady profit growth across the portfolio.
Key takeaways
- Bikes dominate: — of sales, with — the largest subcategory.
- The — income range buys the most (— of sales). More income does not mean more purchases.
- — is the largest market, with — of sales.
- Sales drop sharply in —. The data does not say why, so confirm the export is complete for the later months before presenting this as a real decline.