This MySQL project analyses Northwind's sales operations across five tables orders, order details, products, categories, employees, and customers to evaluate revenue performance, product trends, and customer behaviour. Using a structured set of eight analytical queries, the analysis surfaces key business metrics including quarterly revenue breakdowns, category-level year-on-year growth, and employee sales rankings. Advanced SQL techniques such as CTEs, window functions, and RFM modelling were applied to segment customers into strategic groups identifying Champions, Loyal Customers, and At Risk accounts. Ultimately, these data-driven insights serve to help management understand revenue drivers, prioritise high-value customers, and support strategic decision-making across sales and operations.
The primary objectives of the project are:
Analyse Northwind's sales operations across revenue, product performance, customer behaviour, and employee contributions.
Focus on key business metrics including quarterly revenue trends, category-level growth, and month-over-month fluctuations.
Identify top-performing products and categories while surfacing underperforming areas for strategic attention.
Segment customers using RFM modelling to support targeted retention and engagement strategies.
Rank employees by revenue contribution to inform performance management and incentive planning.
Provide data-driven insights that support management in improving sales strategy and operational decision-making.
Business Questions Answered
1. What is the total revenue generated each year, and how does it break down by quarter?
The Result :
2. Which are the top 10 best-selling products by revenue?
The Result:
3. What is the total revenue contribution by product category?
The Result :
4.Which products are performing above the average revenue per product?
The Result :
5. Which product categories have seen a decline in revenue compared to the previous year?
The Result:
6. Customer Segmentation using RFM analysis?
The Result:
7. Who are the top performing employees by revenue, and what is their rank?
The Results:
8. What is the month-over-month revenue growth rate across the entire business?
The Result:
This analysis of Northwind's sales operations highlights a business with strong product demand but meaningful variation across categories, customers, and employee performance. By leveraging MySQL to evaluate transactional data spanning three years, the project successfully identified critical business patterns — from seasonal revenue fluctuations and declining product categories, to high-value customer segments requiring targeted retention efforts.
These insights provide a data-driven roadmap for management to optimise revenue through focused customer engagement strategies, reward top-performing employees whose contributions disproportionately drive sales, and address underperforming product lines before they erode overall profitability. Ultimately, the transition from raw transactional data to actionable business intelligence ensures that future commercial decisions are grounded in evidence rather than assumption.