Mastering SQL | A Step-by-Step Guide to Preppin' Data 2023, Week 10

In this video, we'll tackle Preppin' Data 2023, Week 10.

These challenges contain help us solve common problems faced by data analysts: Whether you're a beginner or have some experience with SQL, this walkthrough will provide you with practical skills to solve similar problems in your own work.

Timestamps:
00:00 - Intro
00:29 - Adding Week 9's solution
01:05 - Aggregate the data
03:55 - Scaffold the data
05:48 - New rows have a null in the Transaction Value
10:24 - Create a parameter (variable)
11:16 - Filter to parameter (variable) date
12:20 - Tidy up and Outro

Key Concepts Covered:
1. Recursive Common Table Expressions
2. Data Scaffolding
3. Setting Variables

Resources and Links:
This challenge: preppindata.blogspot.com/2023/03/2023-week-10-what…
All challenges: preppindata.blogspot.com/p/the-challenge-index.htm…
My solution: github.com/wjsutton/preppin-data/blob/main/2023/SQ…

#DataAnalysis #SQL #DataAnalytics #DataScience #Tutorial