OpenSkillIndex← back to search
claude-codeproductivity

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

install
source · Clone the upstream repo
git clone https://github.com/majiayu000/claude-skill-registry
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/majiayu000/claude-skill-registry "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/data/analytics-design" ~/.claude/skills/majiayu000-claude-skill-registry-analytics-design-b40d64 && rm -rf "$T"
manifest: skills/data/analytics-design/SKILL.md
tags
#data-visualization#looker-studio#sql#dashboarding#analytics#reporting
source content

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