data-analyst

Analyze raw data with SQL and Python to generate business insights.

1|Updated Apr 15, 2026
One-click install
npx skills add https://github.com/sandmark78/workspace --skill data-analyst-sandmark78
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-analyst
Source: https://github.com/sandmark78/workspace/tree/main/skills/data-analyst
Command: npx skills add https://github.com/sandmark78/workspace --skill data-analyst-sandmark78

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Data analysis and reporting are often slowed by manual data gathering, inconsistent workflows, and brittle spreadsheet processes. This skill automates SQL querying, spreadsheet analysis, data cleaning, visualization, and automated report generation to transform raw data into actionable insights.

Core Features & Use Cases

  • SQL Queries: write and run queries against databases to extract meaningful datasets.
  • Spreadsheet Analysis: process CSV/Excel/Sheets data and prepare clean inputs for dashboards.
  • Data Visualization: create charts, dashboards, and visuals to communicate findings.
  • Report Generation: produce structured reports with insights for stakeholders.
  • Data Cleaning & Quality: identify and fix missing values, outliers, and formatting inconsistencies.
  • Descriptive Statistics & Trends: compute summaries, correlations, and trend analyses.

Quick Start

Place data files into the data/ directory, configure data sources, and start running queries and analyses to generate outputs.

Frequently Asked Questions about data-analyst

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

FAQPage Schema
How do I automate SQL querying and data cleaning for business reporting?

You can automate SQL querying and data cleaning by running scripts that process raw datasets, extract meaningful data from databases, and fix formatting inconsistencies to generate structured business insights.

Can I run SQL queries against multiple database types like sqlite3, psql, and mysql?

Yes, SQL queries can be executed across sqlite3, psql, and mysql databases to extract meaningful datasets, supporting structured data extraction and reproducible analysis workflows for business intelligence.

What's the best way to generate automated reports and visualizations from raw spreadsheet data?

The best way to generate automated reports is by processing spreadsheet data through cleaning and descriptive statistics, then creating charts and structured reports to communicate actionable findings to stakeholders.

How do I clean CSV and Excel files to prepare clean inputs for dashboards?

To clean CSV and Excel files, identify and fix missing values, outliers, and formatting inconsistencies using Python scripts, transforming raw spreadsheet data into clean inputs ready for dashboard visualization.

Does this data analysis approach support reproducible workflows and descriptive statistics?

Yes, this data analysis approach supports reproducible workflows by applying SQL, Python, and common data tools to compute descriptive statistics, summaries, and trend analyses across databases and files.

What prerequisites or data sources do I need to start analyzing data and generating insights?

To start analyzing data, you need to place data files into the data directory and configure your data sources, enabling the scripts to run queries, process spreadsheets, and generate automated reports.