Table of Contents

tl;dr

The solution for:

• Task 1 - here | https://github.com/shubhM13/monzo_account_analytics/blob/main/dbt_models/models/mart/mt_rolling_7day_active_users.sql
• Task 2 - here | https://github.com/shubhM13/monzo_account_analytics/blob/main/dbt_models/models/mart/dim_account.sql
• DBT Github - https://github.com/shubhM13/monzo_account_analytics
• Colab Notebooks Github - https://github.com/shubhM13/monzo_account_analytics/tree/main/colab_notebooks
• Weekly Cohort Retention Analytics - https://colab.research.google.com/drive/1m5082ef3xuOyh8z10P6mb2lbiK6RjjuV?usp=sharing
• Monthly Cohort Retention Analytics - https://colab.research.google.com/drive/1qgxJlEUPRwT8UTez0v23ZG1C2ZhLiPFQ?usp=sharing
• 7d_rolling_active_users Analytics - https://colab.research.google.com/drive/1fEZkPt_DtNM0S5Nqh6HZ_yLTrTrdXVta?usp=sharing
• Basic Account Analysis - https://colab.research.google.com/drive/1TGvvpbdfDVFCHEcuzSa8VXJbmiJSh5wh?usp=sharing

Tasks

Provided Data

Big-query Project: analytics-take-home-test

Dataset: monzo_datawarehouse

Provided with accounts and transactions data from a Banking SaaS application having 4 tables:

1. account_created
2. account_closed
3. account_reopened
4. account_transactions

Task 1: Account Modelling