Product Analytics. Part 2 Product Analytics. Part 2 recap

195. Product Analytics. Part 2 recap

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...

“well worth the money”
Sign up and check out 36 free lessons and exercises.

Anatoli Makarevich, author of SQL Habit 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. 🚀

“well worth the money”

Fluent in SQL in a month

Master Data Analysis with SQL with real life examples from Product Management, Marketing, Finance and more.
-- Type your query here, for example this one -- lists all records from users table: SELECT * FROM users
LIMIT 500
Loading chart... ⏳
Previous lesson: Using helper table for date ranges
Next lesson: Intro to AB-testing