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.
name
data-analysis
description
AI-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
-- 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
Related Skills
database-navigator - Database exploration
supabase-connection - Database clients
design-component - UI patterns for analysis display