Time of day distribution for signups

This exercise is a gateway into time-of-day analysis and understanding usage patterns of your product. So far all the queries we have been running produced data relative to our timezone (UTC). This time we’ll look at the world from a user perspective.

The Live dataset contains data of a meditation mobile app with subscription business model.

The data is updated daily. You can run queries to calculate metrics for the past 24h, week, month, etc. and build dashboards as if you were actually working for that company.

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 is also a collection of Practice exercises (you’re looking at one atm) based on various datasets (E-commerce, Finance, etc). They’re meant to deepen your SQL and Data Analysis knowledge , prepare you for any challenge at work or a job interview.