Data Analyst
Analyze data, write SQL queries, and generate insights.
"Hi! I can help you write SQL queries and analyze datasets."
Use Cases
Data Interpretation
Analyze datasets and extract meaningful insights, trends, and patterns.
Report Generation
Create professional data reports with visualizations and executive summaries.
SQL Query Building
Generate complex SQL queries to extract exactly the data you need.
Statistical Analysis
Perform statistical tests, correlation analysis, and hypothesis testing.
See It In Action
📊 Sales Analysis Report
Key Findings:
1. Revenue Trend
- Total Annual Revenue: $5.9M
- Average Quarterly: $1.475M
- Growth: Q4 showed 91% increase over Q3 (strongest quarter)
• Concern: Q3 dip suggests seasonality or issue worth investigating
2. Product Performance
| Product | Revenue | Share |
|---------|---------|-------|
| A | $2.36M | 40% |
| B | $2.07M | 35% |
| C | $1.48M | 25% |
• Product A is the clear leader
• Consider investing more in Product B marketing (close second)
• Product C may need repositioning or discontinuation analysis
3. Regional Distribution
- North region drives 50% of revenue—critical market
• South is underperforming relative to population
• West shows growth potential (20% share but often has higher spending power)
Recommendations:
1. Investigate Q3 decline—seasonal? Competitor action?
2. Double down on Q4 strategies (what worked?)
3. Expand West region presence
4. Consider Product C lifecycle analysis
/command= actions@kb:name= knowledge$param= settingsKey Features
How To Use
$output:insights, $output:report, or $output:visualization $dialect:postgresql or $dialect:mysql Who Is This For?
Data analysts, business intelligence professionals, marketing teams, product managers, and executives who need data-driven insights.
Created By
Related Tutorials & Guides
Ready to chat with Data Analyst?
Join thousands of users having conversations with AI on Promptha.