A comprehensive business insights dashboard analyzing sales and profitability data for the Classics Models company, covering the period from January 2003 to May 2005.
- Time frame: Jan 2003 – May 2005
- Total Sales: $9,600,000
- Number of Unique Orders: 326
- Average Order Value: $29,460
| Product Line | Sales | Net Profit |
|---|---|---|
| Classic Cars | $3,900,000 | $1,530,000 |
| Vintage Cars | $1,800,000 | $740,000 |
| Motorcycles | $1,100,000 | $470,000 |
| Trucks & Buses | $1,000,000 | $400,000 |
| Planes | $1,000,000 | $370,000 |
| Ships | $700,000 | $260,000 |
| Trains | — | — |
Highlights:
- Classic Cars lead all segments in both revenue and net profit.
- Other product lines contribute less but still show positive margins.
| Office | Sales | Net Profit |
|---|---|---|
| USA | $3,480,000 | $1,390,000 |
| France | $3,080,000 | $1,240,000 |
| UK | $1,440,000 | $750,000 |
| Australia | $1,150,000 | $450,000 |
| Japan | $460,000 | $180,000 |
- The USA is the top customer country (net profit > $1,000,000)
- Other significant contributors: Spain, France, Australia, New Zealand, UK, Italy, Finland, Norway.
- Sales and Net Profit experienced fluctuations, with seasonal or promotional peaks.
- Average order value was consistently high (~$30,000).
- Higher cost of sales generally resulted in higher profits and sales, indicating effective pricing and margin management.
- Detailed analysis of each month and year, including month-over-month (%) changes.
- Periods of both rapid growth and temporary downturns observed.
- Dashboard supports drilldown by country, product line, and customer.
- New Zealand Example:
- Net Profit: $189,506.58
- Top Customer: Down Under Souvenirs ($32,834.18 in sales)
- Focus on the leading segment: Classic Cars
- Top markets: USA, France, UK
- High average order values support a premium product focus
- Growth opportunities in diversifying product and geographic segments
- Continue prioritizing Classic Cars, while fostering growth in Motorcycles and Vintage Cars
- Analyze peaks for replicable success factors
- Develop targeted strategies for underperforming regions
- Open the dashboard file in your analytics platform or BI tool
- Explore tabs/pages for sales, profits, geography, and product lines
- Use filters and drilldowns for detailed, interactive analysis
- Dashboard development platform (Power BI, Tableau, etc.)
- Data extracted from business sales systems (Jan 2003 – May 2005)
This project provides actionable insights for management, marketing, and operational teams to drive further growth and efficiency within the Classics Models business.