İçeriğe geç
TakoAPI
Becerilere dön

data-analyst

oyi77 tarafından

Data & Analytics
16.3kİndirme sayıları clawskills.sh tarafından bildirilir
51Yıldızlar
19Görüntülenmeler
0 beğeniBu beceriyi beğenmek için giriş yapın
—Henüz değerlendirilmedi
Puanınız

Özet

Data visualization, report generation, SQL queries, and spreadsheet.

Açıklama

Bu Beceri Ne Yapar

Enables SQL querying, spreadsheet processing, data visualization, and report generation against databases and files. Covers the full analysis workflow from raw data ingestion through cleaning, statistical analysis, and insight communication. Works with relational databases, data warehouses, CSV/Excel files, and REST APIs.

Combines SQL patterns, pandas workflows, and charting guidance in one skill so analysis doesn't require switching between separate tools or documentation sources.

Ne Zaman Kullanılır

  • Running cohort retention queries against a production database
  • Cleaning a messy CSV export before sharing with stakeholders
  • Generating a weekly revenue report with month-over-month trends
  • Building a conversion funnel from product event tracking data
  • Auditing a dataset for nulls, duplicates, and formatting inconsistencies

Örnek İş Akışı

GİRİŞ

User asks: Show me monthly revenue trends and growth rates for the last 6 months

AJAN
  1. 1

    Query the transactions table using DATE_TRUNC monthly aggregation with LAG window function for prior-month comparison

  2. 2

    Validate results for nulls and zero-division edge cases

  3. 3

    Calculate month-over-month growth percentages

  4. 4

    Generate a line chart using matplotlib with date on x-axis and revenue on y-axis

  5. 5

    Format output into a structured report with an executive summary and key metrics table

ÇIKIŞ

A markdown report with a monthly revenue table showing absolute values and growth percentages, plus a saved trend chart image

Kurulum

clawhub install oyi77/data-analyst

CLI komutunu çalıştırın ya da istemi Claude Code, Cursor, Codex veya kullandığınız kodlama ajanına yapıştırın.

Bağlantılar