data-analysis

データ分析・可視化・レポート作成。pandas、SQL、BigQuery、スプレッドシート操作、統計分析、グラフ作成。「データ分析」「SQL」「BigQuery」「pandas」「集計」「可視化」「レポート」に関する質問で使用。

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

When & Why to Use This Skill

This Claude skill enables advanced AI-powered data analysis, visualization, and automated reporting. By leveraging pandas, SQL, and BigQuery, it transforms raw data and transcripts into actionable insights, including theme extraction, sentiment analysis, and statistical summaries. It is designed to streamline the workflow from database querying to the creation of comprehensive analytics dashboards and visual reports.

Use Cases

  • Automated Insights: Extracting recurring themes, key quotes, and summaries from large volumes of transcripts or documents using AI-driven analysis pipelines.
  • Database Querying & Integration: Executing complex SQL queries on BigQuery and other databases to aggregate data for business intelligence and reporting.
  • Visual Analytics: Creating data visualizations and dashboards to track trends, theme frequency, and connection strengths within specific datasets.
  • Content Recommendation: Implementing story suggestions and related content discovery by analyzing cultural tags and metadata patterns in a database.
namedata-analysis
descriptionAI-powered data analysis for Empathy Ledger - themes, quotes, story suggestions, transcript analysis.

Data Analysis

Patterns for AI-powered analysis: themes, quotes, summaries, and story suggestions.

When to Use

  • Adding quotes to story cards
  • Implementing story suggestions/related content
  • Building theme-based filtering or search
  • Creating analytics dashboards
  • Integrating AI analysis results

Quick Reference

Analysis Pipeline

Transcript → AI Analysis → themes[], key_quotes[], ai_summary
Story → Connections → Related Stories, Suggested Content

Key Tables

Table Analysis Fields
transcripts themes, key_quotes, ai_summary, ai_processing_status
stories themes, cultural_tags, featured_quote
storytellers expertise_themes, connection_strength

Theme Categories

  • cultural: identity, heritage, tradition, language, ceremony
  • family: kinship, elders, children, ancestors, community
  • land: country, connection, seasons, wildlife, sacred-sites
  • resilience: survival, adaptation, strength, healing, hope
  • knowledge: wisdom, teaching, learning, stories, dreams

Common Queries

-- Stories with matching theme
SELECT * FROM stories WHERE themes && ARRAY['identity', 'heritage'];

-- Theme frequency
SELECT unnest(themes) as theme, count(*) FROM stories GROUP BY theme ORDER BY count DESC;

API Endpoints

Endpoint Purpose
POST /api/transcripts/{id}/analyze Trigger AI analysis
GET /api/stories/{id}/suggestions Get related stories
GET /api/themes List themes with counts

Reference Files

Topic File
Code patterns refs/analysis-patterns.md
SQL queries refs/supabase-queries.md
Theme hierarchy refs/theme-taxonomy.md
Sync status refs/sync-status.md
  • database-navigator - Database exploration
  • supabase-connection - Database clients
  • design-component - UI patterns for analysis display