analytics-design

Design Looker Studio reports and dashboards. Use when creating Looker Studio reports, designing data sources, or writing visualization specifications.

$ 安裝

git clone https://github.com/yusuke-suzuki/dotfiles /tmp/dotfiles && cp -r /tmp/dotfiles/.claude/skills/analytics-design ~/.claude/skills/dotfiles

// tip: Run this command in your terminal to install the skill

SKILL.md

View on GitHub →

name: analytics-design description: Design Looker Studio reports and dashboards. Use when creating Looker Studio reports, designing data sources, or writing visualization specifications.

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