A compilation of case study solutions with practical and complex SQL queries for data manipulation, analysis, and reporting covering the following domains of analytics: Health, marketing, people, finance, fast moving consumer goods, and digital marketing. This demonstrates my proficiency in writing SQL queries, solving problems, and obtaining key metrics in every challenge. Created by Data with Danny (Source: #8WeekSQLChallenge)
For starters: Read here on why SQL is an essential skill for all data-related roles such as data engineers and data analysts.
Skills: Data Preparation, Data Cleaning, Data Management, Data Analysis and Reporting
Tools: SQLite, Jupyter Notebook
Projects:
- Week 1: Danny's Diner - (Questions)
- Week 2: Pizza Runner - (Questions)
- Week 3: Foodie-Fi - (Questions)
- Week 4: Data Bank - (Questions)
- Week 5: Data Mart - (Questions)
- Week 6: CliqueBait (Posting soon)
- Week 7: Balanced Tree (Posting soon)
- Week 8: Fresh Segments (Posting soon)
Feel free to click the links above and explore the outputs, queries, and insights from each case study! :)
- Data cleaning & transformation
- Aggregations
- Joins
- Common Table Expressions (CTEs)
- Variables
- Window functions
- PARTITION BY, ORDER BY
- Ranking (ROW_NUMBER, DENSE_RANK)
- Analytics (LEAD, LAG)
- Ranges of calculations (ROWS BETWEEN)
- CASE WHEN statements
- Subqueries
- UNION, INTERSECT, EXCEPT
- DATETIME functions (DATE_PART, DATE_TRUNC)
- Data type conversion
- TEXT functions, text and string manipulation
Note: Weeks 1-3 solutions are done using SQLite, while weeks 4-8 solutions are done using PostgreSQL.
Last updated July 18, 2024