Customer Purchasing Trends Analysis for Northwind Traders -- 2
Budget: $30 – $250 USD
Budget: $50
Time Estimate: 1-2 hours
Use SQL to perform a purchasing trends analysis for Northwind Traders, a company looking to understand its most valuable customers, popular products, and seasonal order patterns. This analysis will help Northwind's sales and marketing team develop targeted strategies for customer engagement and inventory planning.
Key Requirements:
1- Top Customers: Identify the top 5 customers by total order value. This will allow the sales team to recognize their highest-value customers for potential loyalty rewards.
- Include the customer’s name, total order value, and number of orders placed.
2- Popular Products: Find the top 5 products by total quantity sold. This will inform the inventory team about high-demand items that need consistent stock.
- Display the product name, total quantity sold, and total revenue from each product.
3- Order Trends by Month: Analyze monthly ordering patterns to identify peak sales periods.
- Provide a summary showing the number of orders placed each month in the last year, along with total monthly revenue.
4- Recent Customer Orders: List the most recent order from each customer, including the order date, customer name, and order value.
- This will help the sales team understand which customers may need follow-up engagement based on their recent activity.
Deliverables:
A document containing:
- The SQL queries written to answer each requirement.
- A brief explanation of each query’s purpose.
- A summary of key insights from the analysis, such as identifying high-value customers, popular products, and seasonal trends.
Dataset:
Use the Northwind database: https://github.com/jpwhite3/northwind-SQLite3
Time Estimate: 1-2 hours
Use SQL to perform a purchasing trends analysis for Northwind Traders, a company looking to understand its most valuable customers, popular products, and seasonal order patterns. This analysis will help Northwind's sales and marketing team develop targeted strategies for customer engagement and inventory planning.
Key Requirements:
1- Top Customers: Identify the top 5 customers by total order value. This will allow the sales team to recognize their highest-value customers for potential loyalty rewards.
- Include the customer’s name, total order value, and number of orders placed.
2- Popular Products: Find the top 5 products by total quantity sold. This will inform the inventory team about high-demand items that need consistent stock.
- Display the product name, total quantity sold, and total revenue from each product.
3- Order Trends by Month: Analyze monthly ordering patterns to identify peak sales periods.
- Provide a summary showing the number of orders placed each month in the last year, along with total monthly revenue.
4- Recent Customer Orders: List the most recent order from each customer, including the order date, customer name, and order value.
- This will help the sales team understand which customers may need follow-up engagement based on their recent activity.
Deliverables:
A document containing:
- The SQL queries written to answer each requirement.
- A brief explanation of each query’s purpose.
- A summary of key insights from the analysis, such as identifying high-value customers, popular products, and seasonal trends.
Dataset:
Use the Northwind database: https://github.com/jpwhite3/northwind-SQLite3