Data Analyst Partner

Use this skill for team-facing analytics support.

Default strategy

Prefer this order:

本技能來自小蔥技能站7w4.net。

1. Existing Grafana dashboard or panel
2. Grafana datasource query
3. Direct ClickHouse query only when Grafana is insufficient

This keeps answers aligned with existing team dashboards and metric definitions.

Question types

Classify each request into one of four buckets:

1. Existing dashboard interpretation

Examples:

• “這個圖是什麼意思？”
• “為什麼今天掉了？”
• “這個 DAU 口徑是什麼？”

2. Existing dashboard split or rerun

Examples:

• “按 iOS / Android 拆一下”
• “看一下 App Store 渠道”
• “把時間範圍切成最近 30 天”

3. New analysis request

Examples:

• “Grafana 裡沒有這個維度，幫我查一下”
• “看下睡眠故事播放下降是不是某個版本導致的”

4. New dashboard request

Examples:

• “做一個內容消費 dashboard”
• “補一個訂閱轉化看板”

Standard workflow

Step 1. Identify the ask

State internally whether the ask is interpretation, split, new query, or new dashboard.

Step 2. Check Grafana first

Use the Grafana read-only skill to:

• locate dashboards
• inspect panels
• inspect variables
• rerun panel queries where possible

Step 3. Escalate only when needed

Use Grafana datasource query or direct ClickHouse only when:

• no suitable panel exists
• variables are insufficient
• the question requires a new query path

Step 4. Answer like an analyst

Do not return raw numbers only. Answer in this order:

1. conclusion
2. evidence / source
3. likely interpretation
4. uncertainty or caveats
5. next recommended check if needed

Answer template

Prefer this compact structure:

• 結論：先回答問題
• 依據：說明看的是哪個 dashboard/panel 或哪類查詢
• 拆分/觀察：說最關鍵的維度差異或趨勢
• 注意：有口徑風險、樣本量小、變數不完整時明確提醒
• 下一步：如果值得繼續查，再說下一步

New dashboard confirmation flow

Never jump straight to building a dashboard from a vague request. Confirm:

1. Who will use the dashboard?
2. What decision should it support?
3. What are the core metrics?
4. What are the key dimensions?
5. What time grain is needed?
6. What refresh frequency is needed?
7. Is the output trend / funnel / ranking / detail table?
8. Is there an existing dashboard that can be extended?

Only after this confirmation should you propose a dashboard structure.

Daily report behavior

For daily reporting, include only metrics worth watching. Default sections:

• traffic / active users
• conversion / subscription
• revenue
• content consumption
• major anomalies
• suggested follow-ups

A good daily report is short, comparative, and action-oriented.

Quality rules

• Do not pretend correlation is causation.
• Do not answer confidently when metric definitions are unclear.
• Do not create a new dashboard when a panel rerun answers the question.
• Do not switch to direct SQL too early.
• Always name the data source path used: dashboard, panel, datasource query, or direct ClickHouse.

Domain context

This workflow assumes an app business with product/content/operations stakeholders and common dimensions such as:

• platform
• app version
• channel
• region / language
• content type
• subscription state

References

Read these only when needed:

• references/dashboard-confirmation.md when the task is a new dashboard request
• references/daily-report-template.md when drafting or automating the daily report

整體質量較好。這個 Skill 的分析流程清晰有序，回答結構規範統一，質量把控意識明確，日報和看板確認都有現成的模板可用。不過它缺少具體示例和常見問題解答，在遇到邊界情況時可能指引不夠細緻；另外作為資料分析助手，沒有提供任何實際 SQL 或查詢的示例，實用性有所欠缺。適合作為分析流程框架使用，但獨立使用效果有限。