Scaling Interactive and Insightful Dashboards with Data Studio and BigQuery
summary
Shows how BigQuery + Data Studio serve terabytes of public and private data while avoiding runaway query costs: methods include a soon-to-ship Materialize button to persist query results, App Script to schedule queries and write CSVs to GCS, Cloud SQL or Firestore as indexed caches, and a community connector that layers per-user auth and multi-level caching. Demonstrations include 31 billion-row Wikipedia hourly pageviews, per-URL Chrome UX metrics for 5 million sites, and a published dashboard workflow that reduces 350 TB of potential query cost down into the free tier.
AI-written summary · about
chapters (8)
- 0:00Intro
- 1:30Combining Data Studio and BigQuery
- 13:20Making it fast
- 16:01Scheduling
- 20:51Private Data
- 23:25Analyst Dashboard
- 25:33Community Connector
- 31:01Permissions
related talks
22mBuilding Interactive Grafana Dashboards for Business Intelligence
16mMeasure and debug performance with Google Analytics 4 and BigQuery
41mAnalyzing Terabytes of Data with Google BigQuery
35mPowering Interactive Data Analysis with Google BigQuery
45mBuilding a Data Warehouse
41mUsing Google Data (now Looker) Studio for Dashboard Analytics Reporting
22mUsing BigQuery as a data warehouse in B2B startup
46mSimple and Cheap Business Analytics with Google BigQuery