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", "レポート設計", "ダッシュボード".

⭐5stars🔀1forks📁View on GitHub🕐Updated Jan 11, 2026

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.
nameanalytics-design
descriptionDesign 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

  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