Analytics Design

Workflow

1. Purpose: Define what to visualize (link to design doc with KPIs)
2. Data Sources: Design SQL queries and field definitions
3. Report Structure: Define pages and their purposes
4. Visualization: Specify charts with dimensions, metrics, filters

Templates

See references/looker-studio-template.md for report design template.

Looker Studio Best Practices

Data Source Design

• One data source per analytical purpose
• Pre-aggregate in SQL for performance
• Include bucket fields for distribution analysis
• Include sort-order fields for proper chart ordering
• Descriptive data source names

Report Structure

• Separate pages by time granularity (daily/monthly)
• Group related metrics per page
• Consistent filter scopes within pages

Visualization

• Scorecards for KPI current values
• Time series for trends
• Stacked area/bar for category breakdown over time
• Tables for detailed data
• Add comparison periods where relevant