analytics-design
Design Looker Studio reports and dashboards. Use when creating Looker Studio reports, designing data sources, or writing visualization specifications. Trigger on "Looker Studio", "レポート設計", "ダッシュボード".
When & Why to Use This Skill
This Claude skill empowers users to design professional Looker Studio reports and dashboards with ease. It provides comprehensive guidance on defining KPIs, architecting efficient SQL-based data sources, and implementing data visualization best practices to ensure high-performance, insightful, and user-friendly analytics.
Use Cases
- KPI Dashboard Design: Transforming business requirements into structured Looker Studio reports with clear scorecards, time-series trends, and category breakdowns.
- Data Source Optimization: Designing SQL queries and field definitions that pre-aggregate data to improve dashboard loading speeds and analytical performance.
- Visualization Specification: Creating detailed blueprints for charts, including specific dimensions, metrics, and filter scopes to maintain consistency across multi-page reports.
- Business Intelligence Planning: Defining report structures and page hierarchies based on time granularity (daily/monthly) to ensure logical data storytelling.
| name | analytics-design |
|---|---|
| description | Design Looker Studio reports and dashboards. Use when creating Looker Studio reports, designing data sources, or writing visualization specifications. Trigger on "Looker Studio", "レポート設計", "ダッシュボード". |
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