Data Analyst

Overview

The Data Analyst skill empowers AI Agents with professional data analysis capabilities, encompassing SQL query writing and execution, data visualization chart generation, spreadsheet processing, and automated report generation. Whether you're a data analyst or a product manager needing data to support decisions, this skill significantly enhances your data work efficiency.

Core Features

SQL Queries and Database Interaction

By describing your data needs in natural language, the Agent automatically generates corresponding SQL query statements, connects to the target database to execute queries, and organizes results into easily understood formats. Supports mainstream databases including MySQL, PostgreSQL, and SQLite. You don't need to master SQL syntax—just describe what data you want to query.

Data Visualization

The Agent automatically selects the most suitable chart type based on data characteristics—bar charts, line charts, pie charts, scatter plots, heat maps, etc.—and generates high-quality visualization charts. You can also specify chart types and style preferences, and the Agent will adjust output accordingly.

Spreadsheet Processing

Support reading and processing spreadsheet files in CSV and Excel formats. The Agent can complete data cleaning, format conversion, formula calculation, pivot table generation, and other operations, automating tedious spreadsheet processing work.

Automated Report Generation

Automatically consolidate data analysis results into structured report documents. Reports include key metric summaries, trend analysis, data charts, and improvement suggestions. Support periodic automatic generation, suitable for weekly reports, monthly reports, and similar scenarios.

Typical Use Cases

• Product Data Analysis: Quickly query user behavior data and generate visualization reports for core metrics like retention rate, conversion rate, and activity level to support product iteration decisions.
• Business Metrics Monitoring: Set monitoring rules for key business metrics. When data shows abnormal fluctuations, automatically generate alert reports and notify relevant personnel.
• Ad-hoc Data Queries: During business meetings when data is suddenly needed to support discussions, directly describe requirements in natural language and the Agent will query and present results in real-time.
• Multi-source Data Integration: Extract data from multiple databases or files, conduct correlation analysis and cross-comparison to discover insights that single data sources cannot reveal.
• Data Quality Checks: Automatically scan datasets for missing values, anomalies, and duplicate records, generating data quality reports with cleaning suggestions.

Usage Instructions

1. Integrate the Data Analyst skill into your Agent project.
2. Configure database connection information or specify data file paths.
3. Describe your analysis needs in natural language to the Agent.
4. The Agent will execute queries, process data, and return analysis results with visualization charts.

Suitable Users

This skill is particularly suitable for positions that lack deep technical backgrounds but frequently use data, such as product managers, operations personnel, and business analysts. It lowers the technical barriers to data analysis, enabling more people to directly extract insights from data.