Looker Studio Report Design

Workflow

Use templates/looker-studio-template.md to document the report design.

1. Define Purpose (Section 1): What needs to be monitored? What decisions will users make based on this report?

2. Discover Data (Section 2): Explore available datasets and understand schema.

   • Ask user for project/dataset context and business background
   • Use /bq-studio skill for BigQuery schema exploration
   • If prior analysis exists, reference it and skip detailed exploration

3. Define Metrics (Section 3): Define key metrics and dimensions to monitor.

   • Identify what needs to be measured
   • Define calculation methods and data sources