Phase 3 · SQL for Data Analysis
ProjectsSQL Case Study: E-commerce Sales Analysis
Part of the Data Analyst Roadmap.
Summary
A realistic mini-project — given orders, products and customers tables, answer a set of real business questions end-to-end and document your queries and findings.
How to Learn This
- 1Find or construct a small e-commerce dataset (orders, products, customers).
- 2Answer questions like 'top 10 products by revenue' and 'monthly repeat purchase rate'.
- 3Write a short summary of your findings, not just the raw query outputs.
Previous
Write 20 SQL Queries Against a Sample Database
Next
Descriptive Statistics (Mean, Median, Mode, Std Dev)
More projects in SQL for Data Analysis
Stuck on this topic? Ask an Insider
Get 1:1 guidance from people who've walked this exact path — free on the InsideEdge app.