🪴This project is based on sample data of a popular music streaming platfrom, Spotify.
🪴The data table records two events - app install and app purchase
- Q1: Find total active users each day
- Q2: Find total active users each week
- Q3: Date-wise total number of users who made purchase same day they installed the app
- Q4. Percentage of paid users in India, USA and all other countries as others
- Q5: Among all users who installed the app on a given day, how many made a purchase on the next day? Give day-wise count