Customers and Products Analysis Using SQL
- Guided Project
- 0.6 hours
- Intermediate
- SQL
Practice SQL skills like joins, subqueries, and CTEs to analyze sales data and inform business decisions on products and customers.
Overview
In this project, you'll take on the role of a data analyst at a scale model car company looking to make data-driven decisions. You'll use SQL to analyze a sales database and answer key questions to guide business strategy.
You'll apply SQL skills like joins, subqueries, and CTEs to explore product, order, and customer data. Your analysis will inform recommendations on which products to prioritize in inventory, how to segment customers for targeted marketing, and how much to spend acquiring new customers. Through hands-on practice with a real database, you'll showcase your ability to use SQL to solve actual business problems.
Objective: Analyze sales data using SQL to provide recommendations on inventory, customer segmentation, and customer acquisition to drive business growth.
What You'll Learn
- ✓ Expand your portfolio using real-world data
Before You Start
- ✓ Nesting queries to extract data meeting specific criteria
- ✓ Employing different types of subqueries in SQL statements
- ✓ Using common table expressions (CTEs) to simplify complex queries
- ✓ Writing SQL queries to scale data analysis projects
Project Steps
9 steps
- 1 Explore SQL Browser for SQLite
- 2 Introduction to our Project
- 3 Scale Model Cars Database
- 4 Question 1: Which Products Should We Order More of or Less of?
- 5 Question 2: How Should We Match Marketing and Communication Strategies to Customer Behavior?
- 6 Finding the VIP and Less Engaged Customers
- 7 Question 3: How Much Can We Spend on Acquiring New Customers?
- 8 Conclusion
- 9 Next steps
Join 1M+ data learners on Dataquest.
- 1
Create a free account
- 2
Choose a learning path
- 3
Complete exercises and projects
- 4
Advance your career