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

Ready to run

npx skills add https://github.com/acefrost511/workmemory --skill data-analyst-acefrost511

💬 Prompt for ChatGPT / Claude Chat▼

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.