Data AnalystAI data analyst
Analyzes datasets, finds insights, and explains trends in plain English.
What This Skill Does
A data analyst that turns raw numbers into actionable insights. Paste data, describe a dataset, or ask questions about metrics — it performs analysis, identifies trends, spots anomalies, builds pivot tables, writes SQL queries, and explains everything in language anyone can understand. No statistics degree required. Ideal for founders, marketers, and operators who need to make data-driven decisions fast.
Who Should Use This
- Founders who need quick data insights
- Marketers analyzing campaign performance
- Operations teams tracking KPIs
- Anyone who works with spreadsheets
Common Use Cases
- Analyze datasets and find actionable insights
- Calculate SaaS metrics (MRR, churn, LTV, CAC)
- Write and optimize SQL queries
- Identify trends, anomalies, and patterns in data
- Build cohort and funnel analyses
- Explain complex data in plain English for stakeholders
How It Works on OpenClaw
- 1
Install the skill
Browse the marketplace, pick a skill, and add it to your assistant with one click.
- 2
Pick your channel
Connect through Telegram, Discord, or WhatsApp — whichever you already use.
- 3
Start messaging
Send a message and your assistant responds with the skill's expertise, 24/7.
Best Channels and Models
Best Channels
Best Models
Limitations
- Cannot connect to databases or analytics tools directly
- Cannot create visual charts — describes them for you to build
- Analysis quality depends on the data you provide
Not Suitable For
- Teams needing an AI connected to live databases for automated reporting
- Analysts requiring interactive data visualization and chart generation
- Organizations needing real-time dashboard monitoring with alerting
Example Interaction
You
Here's our monthly cohort data for the last 6 months. Tell me if we have a churn problem.
Data Analyst
You do — but it's nuanced. Month-1 retention is solid at 88%, but there's a steep drop at Month-3 (down to 61%). That suggests users find initial value but hit a wall around the 90-day mark. I'd investigate what happens at Month-3: is that when the free trial features expire? Are users hitting usage limits? The fix is likely an activation milestone between Month 1 and 3.
You
Write me a SQL query to find our top 10 customers by revenue in the last 90 days, broken down by plan type.
Data Analyst
Here's the query: SELECT c.name, c.plan_type, SUM(p.amount) as total_revenue FROM customers c JOIN payments p ON c.id = p.customer_id WHERE p.created_at >= NOW() - INTERVAL '90 days' GROUP BY c.name, c.plan_type ORDER BY total_revenue DESC LIMIT 10. If you also want to see their growth trend, I can add a month-over-month breakdown.
Setup Requirements
- OpenClaw account
- Telegram or Discord
- Your dataset, metrics, or SQL schema pasted into the conversation
Frequently Asked Questions
Can it connect to my database?
You paste data or describe your dataset, and it performs analysis. It can write SQL queries for you to run, but it doesn't connect to databases directly.
What metrics does it know?
SaaS (MRR, ARR, churn, NRR, LTV, CAC), e-commerce (AOV, conversion rate, ROAS), marketing (CTR, CPC, CPL), and operations (throughput, cycle time, SLA) metrics.
Can it create charts?
It describes the ideal visualization and explains what chart type to use. For actual chart rendering, use the output in your preferred tool.
Related Skills
Ready to try Data Analyst?
Install this skill and start using it on Telegram, Discord, or WhatsApp in under a minute.