How to use BigQuery for Cohort Analysis | Detailed Case Study
By combining the power of BigQuery with the logic of Cohort Analysis, we can perform very deep behavioral analysis on a large scale data.
In this video we are sharing our knowledge from implementing this technique for an automotive client.
Chapters:
1. The basics of Cohort Analysis 00:57
2. Most popular use cases 02:48
3. How Big Query can add substantial value 09:35
4. The problem statement of our case study 12:00
5. Public Dataset of Chicago Taxi Trips 18:25
6. Big Query SQL Queries to transform Transactional Data into Cohort Dataset 20:40
7. Google Datastudio to generate Heatmap 33:40
8. Findings from Cohort Analysis 39:38
9. Business Interface 42:04
We are a team of data engineers working 24x7, with expertise into Cloud Data Migration and SQL Queries.
For any of your business needs, small/medium/large, please send an email to [email protected].
#BigQuery #DataAnalysis #GCP #CohortAnalysis