diegosouzapw Analytics Design
Workflow
- Purpose: Define what to visualize (link to design doc with KPIs)
- Data Sources: Design SQL queries and field definitions
- Report Structure: Define pages and their purposes
- 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