This project focuses on analyzing data from the AdventureWorks database, which contains a wealth of information about a fictional bicycle manufacturing company. The database includes data on sales, production, purchasing, and customer information, making it an ideal dataset for various analytical tasks.
This project demonstrates the use of SQL for business intelligence and data-driven decision-making. By querying different tables in the AdventureWorks database, the insights derived can help in optimizing business processes, improving sales strategies, and better managing inventory and customer relationships.
-
📈 Sales Performance:
- Analyze sales trends by product subcategories, order quantities, and sales values over time.
- Identify year-over-year growth rates to find top-performing product categories and regions.
-
🔁 Customer Retention:
- Conduct cohort analysis to assess customer retention over time and understand factors affecting customer loyalty.
-
📦 Inventory Management:
- Track stock levels and analyze month-over-month changes for optimal inventory management.
- Study the ratio of stock to sales to measure inventory efficiency relative to demand.
-
💸 Discount Analysis:
- Evaluate the impact of seasonal discounts on sales and calculate the discount cost across different product subcategories.
-
📥 Order Management:
- Review the number and value of pending orders to identify potential bottlenecks in order fulfillment.