Smart Data Analyst

What This Skill Does

The Smart Data Analyst is an advanced OpenClaw agent skill designed to transform raw datasets into actionable intelligence. It acts as an autonomous data scientist that ingests CSV, Excel, JSON, and SQL exports to perform multi-stage analysis. It automatically audits data quality, calculates statistical distributions, detects anomalies, and generates comprehensive, structured markdown reports. Whether you are identifying market trends, debugging data quality issues, or summarizing complex categorical datasets, this skill removes the friction of manual spreadsheet processing.

Installation

To integrate this skill into your OpenClaw environment, use the following command: clawhub install openclaw/skills/skills/a799549967-lang/smart-data-analyst

Use Cases

• Business Intelligence: Quickly analyze sales reports or marketing performance metrics without writing SQL or Python code.
• Quality Assurance: Use the automated anomaly detection to identify data entry errors, duplicate records, or missing values in large datasets.
• Academic Research: Perform statistical characterizations of survey results or experimental logs.
• Financial Analysis: Identify spending trends, outliers in budget logs, and period-over-period growth indicators.

Example Prompts

1. "Analyze this data and give me a summary of the top 5 contributors to our Q3 revenue based on this CSV."
2. "I've uploaded an Excel file containing our customer support tickets; please find the most common categories and any anomalies in response times."
3. "Look at this JSON export—what are the key findings, and are there any obvious data quality issues I should fix?"

Tips & Limitations

• Formatting: Ensure your data has a clear header row. If the file is extremely large (e.g., millions of rows), consider uploading a representative sample for faster results.
• Data Privacy: This skill processes data locally within the agent's context window. Avoid uploading sensitive PII (Personally Identifiable Information) if your environment security policies restrict it.
• Follow-up: Don't hesitate to ask for specific segmentations after the initial report is generated. You can ask, 'Can you pivot the results by region?' or 'Compare the growth rate for Segment A vs Segment B.'