Analyze Insights
Quick Start
When analyzing an insight:
- Call
view_insight for saved insights, or use provided chart data directly
- Identify the chart type and what it measures
- Look for patterns (trends, seasonality, anomalies)
- Quantify observations with specific numbers
- Provide actionable interpretation
When to Use This Skill
- User asks "what does this insight show?"
- Analyzing visualization results
- Identifying trends or anomalies
- Explaining patterns in data
- Generating insights from visual data
Chart Types
| Type |
Best For |
Look For |
| Line |
Time series trends |
Direction, inflection points |
| Bar |
Category comparison |
Relative sizes, outliers |
| Area |
Volume over time |
Growth, composition |
| Pie |
Distribution |
Proportions, dominance |
| Table |
Detailed data |
Patterns, sorting |
| Metric |
Single values |
Change from baseline |
| BarList |
Ranked items |
Top performers, long tail |
Analysis Framework
1. Describe What You See
Start with objective observations:
- What is being measured?
- What is the time range?
- What are the key dimensions?
2. Identify Patterns
Look for:
- Trends: Upward, downward, flat
- Seasonality: Weekly, monthly, yearly cycles
- Anomalies: Spikes, drops, outliers
- Inflection points: Where direction changes
3. Quantify Observations
Always include numbers:
- Absolute values
- Percentage changes
- Comparisons to baselines
4. Provide Interpretation
Explain significance:
- Why might this be happening?
- What are the implications?
- What actions should be considered?
Pattern Recognition
Trend Patterns
Upward Trend
- Consistent growth over time
- Look for: slope, acceleration/deceleration
- Note: sustainability, growth rate
Downward Trend
- Consistent decline over time
- Look for: rate of decline, stabilization
- Note: severity, projected impact
Flat/Stable
- No significant change
- Look for: volatility within range
- Note: whether stability is expected
Seasonality Patterns
Weekly Cycles
- Weekday vs weekend differences
- Monday dips, Friday spikes
- Note: business day patterns
Monthly Cycles
- Beginning/end of month patterns
- Billing cycles, payroll effects
- Note: calendar effects
Yearly Cycles
- Holiday impacts
- Seasonal business patterns
- Note: YoY comparisons
Anomaly Patterns
Spikes
- Sudden increase
- Look for: magnitude, duration
- Consider: campaigns, events, bugs
Drops
- Sudden decrease
- Look for: recovery pattern
- Consider: outages, issues, seasonality
Outliers
- Values far from normal range
- Look for: explanation
- Consider: data quality, real events
Analysis by Chart Type
Line Charts
Focus on:
- Overall trend direction
- Volatility/smoothness
- Inflection points
- Comparisons between lines
Questions to answer:
- Is the metric growing or declining?
- Are there regular patterns?
- Where are the peaks and troughs?
Bar Charts
Focus on:
- Relative bar heights
- Ordering (if applicable)
- Gaps between categories
- Outlier categories
Questions to answer:
- Which category leads/lags?
- Is distribution expected?
- Are there surprising values?
Pie Charts
Focus on:
- Dominant segments
- Small segments
- Unexpected proportions
Questions to answer:
- Is any segment too dominant?
- Are proportions as expected?
- Has composition changed?
Tables
Focus on:
- Sorting patterns
- Extreme values
- Null/missing data
- Relationships between columns
Questions to answer:
- What patterns emerge?
- Are there data quality issues?
- What correlations exist?
Quantification Guidelines
Describing Changes
| Change |
Description |
| +/-5% |
Slight change |
| +/-10-20% |
Moderate change |
| +/-20-50% |
Significant change |
| +/-50%+ |
Dramatic change |
| 2x |
Doubled |
| 3x |
Tripled |
Time Comparisons
- WoW: Week-over-week
- MoM: Month-over-month
- QoQ: Quarter-over-quarter
- YoY: Year-over-year
Statistical Context
- Compare to historical average
- Note standard deviation if known
- Reference typical ranges
Communication Patterns
Good Insight Format
[What]: Revenue increased 23% this week
[Context]: From $45,000 to $55,350
[Comparison]: This is 15% above the 4-week average
[Interpretation]: Likely driven by the holiday promotion
[Recommendation]: Consider extending the campaign
Avoid Vague Statements
| Bad |
Good |
| "Revenue went up" |
"Revenue increased 23% to $55,350" |
| "There's a trend" |
"Daily active users grew 5% WoW for 6 consecutive weeks" |
| "Something changed" |
"Conversion dropped from 3.2% to 2.1% on March 15" |
Common Pitfalls
- Making claims without numbers
- Ignoring context (seasonality, events)
- Confusing correlation with causation
- Over-interpreting normal variance
- Missing obvious anomalies
- Not considering data quality issues
Reference Files
- Insight types detail
- Visualizations guide
- Anomaly patterns
1---2name: analyze-insights3description: Explains what an existing insight or chart shows. Use when asked what a visualization or graph means, or to read out its outliers. Does not run a query.4---56# Analyze Insights78## Quick Start910When analyzing an insight:111. Call `view_insight` for saved insights, or use provided chart data directly122. Identify the chart type and what it measures133. Look for patterns (trends, seasonality, anomalies)144. Quantify observations with specific numbers155. Provide actionable interpretation1617## When to Use This Skill1819- User asks "what does this insight show?"20- Analyzing visualization results21- Identifying trends or anomalies22- Explaining patterns in data23- Generating insights from visual data2425## Chart Types2627| Type | Best For | Look For |28|------|----------|----------|29| Line | Time series trends | Direction, inflection points |30| Bar | Category comparison | Relative sizes, outliers |31| Area | Volume over time | Growth, composition |32| Pie | Distribution | Proportions, dominance |33| Table | Detailed data | Patterns, sorting |34| Metric | Single values | Change from baseline |35| BarList | Ranked items | Top performers, long tail |3637## Analysis Framework3839### 1. Describe What You See4041Start with objective observations:42- What is being measured?43- What is the time range?44- What are the key dimensions?4546### 2. Identify Patterns4748Look for:49- **Trends**: Upward, downward, flat50- **Seasonality**: Weekly, monthly, yearly cycles51- **Anomalies**: Spikes, drops, outliers52- **Inflection points**: Where direction changes5354### 3. Quantify Observations5556Always include numbers:57- Absolute values58- Percentage changes59- Comparisons to baselines6061### 4. Provide Interpretation6263Explain significance:64- Why might this be happening?65- What are the implications?66- What actions should be considered?6768## Pattern Recognition6970### Trend Patterns7172#### Upward Trend73- Consistent growth over time74- Look for: slope, acceleration/deceleration75- Note: sustainability, growth rate7677#### Downward Trend78- Consistent decline over time79- Look for: rate of decline, stabilization80- Note: severity, projected impact8182#### Flat/Stable83- No significant change84- Look for: volatility within range85- Note: whether stability is expected8687### Seasonality Patterns8889#### Weekly Cycles90- Weekday vs weekend differences91- Monday dips, Friday spikes92- Note: business day patterns9394#### Monthly Cycles95- Beginning/end of month patterns96- Billing cycles, payroll effects97- Note: calendar effects9899#### Yearly Cycles100- Holiday impacts101- Seasonal business patterns102- Note: YoY comparisons103104### Anomaly Patterns105106#### Spikes107- Sudden increase108- Look for: magnitude, duration109- Consider: campaigns, events, bugs110111#### Drops112- Sudden decrease113- Look for: recovery pattern114- Consider: outages, issues, seasonality115116#### Outliers117- Values far from normal range118- Look for: explanation119- Consider: data quality, real events120121## Analysis by Chart Type122123### Line Charts124125Focus on:126- Overall trend direction127- Volatility/smoothness128- Inflection points129- Comparisons between lines130131Questions to answer:132- Is the metric growing or declining?133- Are there regular patterns?134- Where are the peaks and troughs?135136### Bar Charts137138Focus on:139- Relative bar heights140- Ordering (if applicable)141- Gaps between categories142- Outlier categories143144Questions to answer:145- Which category leads/lags?146- Is distribution expected?147- Are there surprising values?148149### Pie Charts150151Focus on:152- Dominant segments153- Small segments154- Unexpected proportions155156Questions to answer:157- Is any segment too dominant?158- Are proportions as expected?159- Has composition changed?160161### Tables162163Focus on:164- Sorting patterns165- Extreme values166- Null/missing data167- Relationships between columns168169Questions to answer:170- What patterns emerge?171- Are there data quality issues?172- What correlations exist?173174## Quantification Guidelines175176### Describing Changes177178| Change | Description |179|--------|-------------|180| +/-5% | Slight change |181| +/-10-20% | Moderate change |182| +/-20-50% | Significant change |183| +/-50%+ | Dramatic change |184| 2x | Doubled |185| 3x | Tripled |186187### Time Comparisons188189- **WoW**: Week-over-week190- **MoM**: Month-over-month191- **QoQ**: Quarter-over-quarter192- **YoY**: Year-over-year193194### Statistical Context195196- Compare to historical average197- Note standard deviation if known198- Reference typical ranges199200## Communication Patterns201202### Good Insight Format203204```205[What]: Revenue increased 23% this week206[Context]: From $45,000 to $55,350207[Comparison]: This is 15% above the 4-week average208[Interpretation]: Likely driven by the holiday promotion209[Recommendation]: Consider extending the campaign210```211212### Avoid Vague Statements213214| Bad | Good |215|-----|------|216| "Revenue went up" | "Revenue increased 23% to $55,350" |217| "There's a trend" | "Daily active users grew 5% WoW for 6 consecutive weeks" |218| "Something changed" | "Conversion dropped from 3.2% to 2.1% on March 15" |219220## Common Pitfalls221222- Making claims without numbers223- Ignoring context (seasonality, events)224- Confusing correlation with causation225- Over-interpreting normal variance226- Missing obvious anomalies227- Not considering data quality issues228229## Reference Files230231- [Insight types detail](references/insight-types.md)232- [Visualizations guide](references/visualizations.md)233- [Anomaly patterns](references/anomaly-patterns.md)