Analyst

What This Skill Does

The Analyst skill is a powerful framework for turning raw data into actionable intelligence. It provides the OpenClaw AI agent with a structured methodology for querying, validating, processing, and presenting data. By enforcing rigorous standards for data quality, SQL best practices, and effective visualization, this skill ensures that analysis remains focused on decision-making rather than mere report generation. The skill emphasizes hypothesis-driven analysis, cohort comparisons, and clear communication, helping users bridge the gap between complex datasets and executive-level insights.

Installation

To integrate the Analyst skill into your environment, use the following command: clawhub install openclaw/skills/skills/ivangdavila/analyst

Use Cases

• Strategic Decision Support: Clarify ambiguous business problems by framing questions, gathering relevant data, and testing hypotheses to guide leadership.
• Performance Monitoring: Automate the tracking of key performance indicators (KPIs) through reproducible SQL scripts and dashboards.
• Data Auditing: Rapidly validate data sources and check for inconsistencies, such as duplicate records or incorrect date ranges, before deeper investigation.
• Trend Analysis: Identify patterns in time-series data while controlling for seasonality, enabling accurate forecasting.
• Customer Segmentation: Use cohorts to understand user behavior over time, uncovering insights that aggregate metrics often hide.

Example Prompts

• "I need to understand why our retention dropped last month. Please perform a cohort analysis starting from user acquisition, identify potential correlations, and suggest three actionable improvements."
• "Run a SQL query to extract revenue data for Q3, but first, validate the row counts and check for null values. Create a summary visualization highlighting the trend compared to last year."
• "We have an executive meeting regarding marketing spend. Summarize the ROI findings, lead with the most impactful insight, and provide a clear recommendation on where to reallocate the budget."

Tips & Limitations

To maximize the value of this skill, prioritize scoping your analysis before querying; an infinite search for data leads to delays. Always document your assumptions, as the context is as valuable as the code itself. Remember that correlation does not imply causation, and be prepared to push back if the original request is misaligned with the actual business goal. Be wary of 'death by dashboard'—focus on metrics that truly drive decisions rather than creating overly complex visual displays that are never reviewed. Finally, ensure all SQL follows the CTE-first pattern for maximum maintainability.