Practice Time of day distribution for signups

Time of day distribution for signups

Difficulty 🌶 🌶 🌶 🌶

About the exercise

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

💾  About the dataset

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

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

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