Wasn’t it fun? We just finished the chapter Product Analytics. Part 2!
I think it was a very intense chapter in terms of new learnings. We not only wrote queries with multiple window functions and learned new tricks but also leaned about activation and retention rates. All AARRR metrics are covered! Took us just 200 lessons!
All righty, before let’s recap what we’ve learned in this chapter to celebrate!
Calculating release dates from the activity stream
We started the chapter by learning a very useful technique – extracting starting dates...
Sign up and check out 36 free lessons and exercises.
About SQL Habit
Hi, it’s Anatoli, the author of SQL Habit.
SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst and solve real-life challenges from Business, Marketing, and Product Management.
SQL Habit course is made of bite-sized lessons (you’re looking at one atm) and exercises. They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work.