Agent skill

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

Stars 163
Forks 31

Install this agent skill to your Project

npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/data/analytics-design

SKILL.md

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

Expand your agent's capabilities with these related and highly-rated skills.

Didn't find tool you were looking for?

Be as detailed as possible for better results