skills.rest
DoggyHU
DoggyHUCOMMUNITY
Explore all skills by this author →
GitHub

data-analyst

Execute SQL queries, analyze spreadsheets, and generate data reports.

Updated Aug 23, 2026
Search Tags:#data visualization#report generation#data analysis#sql#spreadsheet
One-click install
npx skills add https://github.com/DoggyHU/pipipax_claw_backup --skill data-analyst-doggyhu
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-analyst
Source: https://github.com/DoggyHU/pipipax_claw_backup/tree/main/skills/data-analyst
Command: npx skills add https://github.com/DoggyHU/pipipax_claw_backup --skill data-analyst-doggyhu

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, numpy, matplotlib, sqlalchemy, pandas_gbq, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill solves the problem of manual data analysis, providing a comprehensive solution for querying databases, analyzing spreadsheets, visualizing data, and generating insights from raw data.

Core Features & Use Cases

  • Database Querying: Execute SQL queries against databases.
  • Spreadsheet Analysis: Process data from CSV, Excel, and Google Sheets.
  • Data Visualization: Create various charts and graphs.
  • Report Generation: Generate automated reports with insights.
  • Data Cleaning: Handle missing data, outliers, and inconsistent formats.
  • Statistical Analysis: Perform descriptive and inferential statistics.
  • Use Case: Use this Skill to analyze sales data, identify trends, and generate a report with actionable insights.

Quick Start

To start analyzing data, run the command: ./scripts/data-init.sh

Frequently Asked Questions about data-analyst

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

FAQPage Schema
How do I generate automated reports and data visualizations from raw spreadsheets?▼

You can generate automated reports and data visualizations from raw spreadsheets by executing Python scripts that utilize pandas, numpy, and matplotlib. This process handles spreadsheet analysis, creates charts, and produces actionable insights for data-driven decision-making.

Can I run SQL queries against databases and process the results for statistical analysis?▼

Yes, you can run SQL queries against databases using sqlalchemy and pandas_gbq dependencies. The queried data can then be processed for statistical analysis, handling descriptive and inferential statistics to identify trends and generate insights.

Do I need Python to analyze CSV and Excel files and clean inconsistent data formats?▼

Yes, you need Python to analyze CSV and Excel files and clean inconsistent data formats. The Skill requires Python for executing analysis scripts and utilizes libraries like pandas and numpy to handle missing data, outliers, and format inconsistencies.

What's the best way to start analyzing sales data and identifying trends?▼

The best way to start analyzing sales data and identifying trends is by running the initialization command `./scripts/data-init.sh`. This sets up the environment to process spreadsheets, perform statistical analysis, and generate automated reports with actionable insights.

Does data visualization with matplotlib support Google Sheets for report generation?▼

Yes, data visualization with matplotlib supports Google Sheets for report generation. The Skill processes data from Google Sheets, manipulates the spreadsheets using pandas, and creates various charts and graphs to generate automated reports.

Related Skills

Explore More Data & Analytics Skills→
rodrigoBermejorodrigoBermejo

Data Processing - pandas, numpy, Data Analysis

Automate data processing and analysis in Python with pandas and numpy.

Community
Intermediate
CellCogCellCog
6

data-cog

Analyze messy datasets to produce insights, charts, and data-driven reports.

Official
Advanced
zangxin75zangxin75

data-analyst

Analyze data with Python Pandas and SQL to generate reports and visualizations.

Community
Intermediate
logeshv586-codelogeshv586-code

xlsx

Analyze spreadsheet data and create charts with openpyxl, pandas, and matplotlib.

Community
Advanced