Datasets Bindle dataset

Bindle dataset

This data warehouse belongs to a fictional startup named Bindle. Bindle is a web and mobile app for reading books, it has subscription business model. The SQL Habit Course is based on Bindle’s story.

Bindle’s data warehouse contains everything needed to run a modern Internet company – web and mobile analytics, marketing data, AB-test data, etc.

Practice exercises

1. Percentage of refunded purchases

Start
2. Distribution of countries by purchase rate

Start
3. Ultimate AB-test dashboard: cohort sizes

Start
4. Calculating purchase rate

Start
5. Number of days to make the first purchase with ranges

Start
6. Extracting dates out of text

Start
7. Purchase rate for different cohorts

Start
8. User base month-to-month growth

Start
9. Calculating CPS (Cost per Signup)

Start
10. Ultimate AB-test dashboard: purchase rate uplift

Start
11. Distribution of users email domains

Start
12. Demographics data report

Start
13. Revenue distribution by country

Start
14. ARPU per country

Start
15. Number of days to make the first purchase with percentage distribution

Start
16. Ultimate AB-test dashboard: activation rate

Start
17. Total revenue calculation

Start
18. Revenue by country

Start
19. Number of days to make the first purchase

Start
20. Cumulative total users per day

Start
21. Ultimate AB-test dashboard: purchase rate

Start
22. Design research: users who refunded

Start

Bindle dataset

Practice exercises

Fluent in SQL in a month