skills.rest
ilove323
ilove323COMMUNITY
Explore all skills by this author →
GitHub

analyze

Answer data questions using SQL, CSVs, or data warehouses.

1|Updated Mar 30, 2026
Search Tags:#metrics#reporting#sql#data-analysis#root-cause#data-visualization#data-validation
One-click install
npx skills add https://github.com/ilove323/comlan-skills --skill analyze-ilove323
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: analyze
Source: https://github.com/ilove323/comlan-skills/tree/main/data/skills/analyze
Command: npx skills add https://github.com/ilove323/comlan-skills --skill analyze-ilove323

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Help users answer data questions ranging from quick metric lookups to full analytical investigations and stakeholder-ready reports, reducing the manual work of schema discovery, SQL drafting, validation, and result interpretation.

Core Features & Use Cases

  • Rapid metric lookups: Retrieve single KPIs or filtered counts for quick questions like "how many new users last week".
  • Exploratory and root-cause analysis: Perform multi-dimensional trend analysis, anomaly detection, and segment comparisons to identify drivers of change.
  • Formal reporting and reproducibility: Draft queries, validate results, annotate methodology and limitations, and recommend visualizations for stakeholder delivery.

Quick Start

Ask a natural-language question such as "What caused the drop in conversion rate over the last three months, broken down by channel and device?"

Frequently Asked Questions about analyze

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I find the root cause of a metric change using SQL and uploaded CSVs?▼

Schema discovery automates the process of identifying available tables, columns, and relationships within your connected data warehouses or uploaded CSVs, enabling accurate SQL drafting without manual exploration.

How do I prepare a stakeholder-ready data report from a data warehouse?▼

You can prepare stakeholder-ready reports by drafting queries, executing them, running result validation checks, annotating methodology and limitations, and recommending data visualizations for clear delivery.

Can I perform data validation and anomaly detection on rapid metric lookups?▼

Yes, rapid single-metric lookups support result validation checks and anomaly detection to ensure data accuracy when retrieving filtered counts or quick KPIs from your connected sources.

What is the best way to analyze data if I cannot connect to a data warehouse?▼

When a data warehouse connection is unavailable, you can use uploaded CSVs for manual data uploads and receive fallback guidance to continue your exploratory data analysis and metric reporting.

Does data visualization guidance support multi-dimensional exploratory analysis?▼

Yes, data visualization guidance is provided for multi-dimensional exploratory analyses, helping you represent trends, root-cause investigations, and segment comparisons clearly for stakeholder delivery.

Related Skills

Explore More Data & Analytics Skills→
PostHogPostHog
75

querying-posthog-data

Query PostHog analytics data using HogQL and SQL foundations.

Official
Intermediate
xpert-aixpert-ai
8

build-report

Transform raw analytical evidence into structured HTML or MCP reports with embedded Seaborn charts.

Official
Advanced
evolution-foundationevolution-foundation
520

data-analyze

Retrieve workspace metrics from Stripe, Omie, Licensing, Evo CRM, and Linear.

Official
Intermediate
firetiger-ossfiretiger-oss
1

firetiger-investigate

Manage Firetiger investigations and query telemetry data via SQL.

Official
Intermediate