Simple and Cheap Business Analytics with Google BigQuery

on YouTube ↗46m

" summary

Shows how DocDoc built inexpensive, scalable analytics using Google BigQuery: compares storage options, explains why BigQuery was chosen, and how to organize data and collect clickstream events (instead of sampling in Google Analytics) to produce simple, fast analytical reports.

AI-written summary · about

" chapters (9)

1. 0:00Introduction
2. 5:00Standard analytics problems
3. 11:23Finding the right solution
4. 17:04Google BigQuery choice
5. 23:12Data prep for BigQuery
6. 27:29Analytics system architecture
7. 31:43Data visualization
8. 35:37Cost and efficiency
9. 39:14Q&A

" related talks

• 22mUsing BigQuery as a data warehouse in B2B startupDenys Tkalich · DevFest Ukraine 2018
• 34mGoogle BigQueryMichael Entin · Data By the Bay 2016
• 33mBigQuery DeepDive: dissecting Google's Data WarehouseClément Bosc · Sunny Tech 2022
• 41mAnalyzing Terabytes of Data with Google BigQueryChandramouli Mahadevan · The Fifth Elephant 2013
• 40mFinOps Examples using Google Cloud BigQuery by Aliz.aiZoltán Guth, Gergely Schmidt · Crunch Conference 2022
• 06mGoogle BigQuery for enterpriseChad W. Jennings · Strata + Hadoop World 2016 - New York, New York
• 33mAnalytics Data Driven TestingSlavik Pashanin · QA Fest 2018
• 35mScaling Interactive and Insightful Dashboards with Data Studio and BigQueryMinhaz Kazi, Felipe Hoffa · Google Cloud Next '18