Project overview
Analysed a four-year sales dataset with MySQL to answer 14 business questions. The work covered revenue and profit trends, channel and regional performance, discount comparisons, product rankings, quarterly patterns, stock availability and profit margins.
Business questions explored
- Top 10 products by revenue in each zone
- Highest-revenue sales channel in each state
- Sales by year
- Profit by year
- Profit margin by year
- Top-selling products by zone and year
- Sales with discounts versus no discounts
- Profit with discounts versus no discounts
- Revenue by product category
- Order quantity by product category and zone
- Top product category by quarter and year
- Products never out of stock
- Products sometimes out of stock
- Profit margins by category
Selected findings from the analysis
- 2012 had the highest sales in the dataset, at $18,368,505.24.
- 2011 had the highest profit margin at 52.9%, although the data for that year starts in Q4.
- Computers generated the most revenue, at $16,409,174.98, but had the lowest category profit margin at 48.17%.
- Music, movies and audiobooks had the highest profit margin.
- Products associated with discounts sold 52% more than products without discounts in this dataset. Further analysis would be needed to establish the full effect of discounts.