Period-over-Period

Week-over-week growth is a three-line query once you see the join

Week-over-week growth is a three-line query once you see the join

Category

SQL

Difficulty

advanced

Duration

25 minutes

Challenges

0 hands-on challenges

Topics covered: The Growth Rate Question in Disguise, Self-Join on Truncated Dates, LAG as the Cleaner Alternative, Missing Periods and NULL Growth Rates, Multi-Dimension Comparisons

Lesson Sections

1. The Growth Rate Question in Disguise

   Content coming soon.

2. Self-Join on Truncated Dates

   Content coming soon.

3. LAG as the Cleaner Alternative

   Content coming soon.

4. Missing Periods and NULL Growth Rates

   Content coming soon.

5. Multi-Dimension Comparisons

   Content coming soon.