skills.rest
acefrost511
acefrost511COMMUNITY
Explore all skills by this author →
GitHub

data-analyst

Analyze SQL, spreadsheet, and warehouse data with cleaning and reporting workflows.

Updated Mar 4, 2026
Search Tags:#reporting#sql#visualization#spreadsheet#data-analysis#csv#data-cleaning
One-click install
npx skills add https://github.com/acefrost511/workmemory --skill data-analyst-acefrost511
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-analyst
Source: https://github.com/acefrost511/workmemory/tree/main/skills/data-analyst
Command: npx skills add https://github.com/acefrost511/workmemory --skill data-analyst-acefrost511

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires sqlite3, psql, mysql, and includes scripts (resource) components.

What problem does it solve?

Turn raw data into actionable insights by uniting SQL querying, spreadsheet analysis, data cleaning, and automated reporting into a cohesive analytics workflow.

Core Features & Use Cases

  • SQL Queries — Write and execute queries against databases
  • Spreadsheet Analysis — Process CSV, Excel, Google Sheets data
  • Data Visualization — Create charts, graphs, and dashboards
  • Report Generation — Automated reports with insights
  • Data Cleaning — Handle missing data, outliers, formatting
  • Statistical Analysis — Descriptive stats, trends, correlations

Use Case: Produce weekly dashboards for business stakeholders showing key metrics and trends from multiple data sources.

Quick Start

Configure your data sources in TOOLS.md, set up your workspace, and start analyzing data.

Frequently Asked Questions about data-analyst

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

FAQPage Schema
How do I automate report generation from SQL databases and spreadsheets?▼

Automate report generation by executing SQL queries and processing CSV or Excel spreadsheet data to create visual charts and stakeholder dashboards. This workflow unifies data cleaning and reporting into reproducible scripts for actionable insights.

What is the best way to clean spreadsheet data for statistical analysis?▼

Clean spreadsheet data for statistical analysis by handling missing values, formatting inconsistencies, and outliers within a structured workflow. This process ensures your CSV and Excel data is prepared for accurate descriptive stats and trend correlations.

Can I use this data analysis workflow with sqlite3, psql, and mysql databases?▼

Yes, you can use this data analysis workflow with sqlite3, psql, and mysql databases to query data warehouses. It writes and executes SQL queries against these sources to extract metrics for visualization and reporting.

How do I create visual dashboards from multiple data sources?▼

Create visual dashboards from multiple data sources by querying SQL databases and processing spreadsheets to generate charts and graphs. This workflow consolidates disparate inputs into automated reports showing key metrics and trends.

Does data cleaning happen before or after SQL queries in the analysis workflow?▼

Data cleaning happens after extracting raw data via SQL queries and spreadsheet imports, handling missing data and outliers before analysis. This enforces a repeatable workflow ensuring clean inputs for statistical analysis and visualization.

Related Skills

Explore More Data & Analytics Skills→
besoeasybesoeasy
128

database-query-and-export

Query SQLite, PostgreSQL, and MySQL databases and export results to CSV or JSON.

Community
Intermediate
bingran-youbingran-you
3

data-report

Convert Xiaohongshu performance data into structured stakeholder reports.

Community
Advanced
kk580kkkk580kk
1

Excel Analysis

Analyze Excel spreadsheet data with pivot tables and charts.

Community
Intermediate
Avi977Avi977

xlsx

Automate spreadsheet processing and data cleaning across Excel and CSV files.

Community
Intermediate