looker-studio-bigquery
Installation
Summary
Design and deploy analytics dashboards connecting BigQuery data to Looker Studio visualizations.
- Supports native BigQuery connector with custom SQL queries, scheduled queries for performance optimization, and multi-table joins for complex data transformations
- Includes F-pattern dashboard layout guidance with KPI tiles, trend charts, comparison visualizations, and interactive filters for user-driven exploration
- Provides performance optimization strategies using partition keys, data extraction to pre-computed tables, and caching to reduce query costs and loading time
- Covers IAM permission configuration, row-level security policies, and access control for secure multi-user dashboard sharing
SKILL.md
Looker Studio BigQuery Integration
When to use this skill
- Analytics dashboard creation: Visualizing BigQuery data to derive business insights
- Real-time reporting: Building auto-refreshing dashboards
- Performance optimization: Optimizing query costs and loading time for large datasets
- Data pipeline: Automating ETL processes with scheduled queries
- Team collaboration: Building shareable interactive dashboards
Instructions
Step 1: Prepare GCP BigQuery Environment
Project creation and activation
Create a new project in Google Cloud Console and enable the BigQuery API.