OfficeUpdated 2026-10-24
Data Analysis Prompt
Start from a business question and get a framework, metrics and validation steps.
#数据分析#指标#业务#可视化DeepSeekKimiMicrosoft 365 Copilot
Prompt
Help analyze this business question.
Question: {{question}}
Available data: {{fields}}
Context: {{context}}
Output:
1. Break it into three testable sub-questions.
2. Metrics and definitions needed for each.
3. Suggested methods: comparison, funnel, cohort or regression.
4. Confounders to rule out.
5. What the conclusion might look like, stated as a hypothesis.
6. Suggested visualizations.
Do not invent data; list missing fields explicitly.Variables to replace
{{问题}}{{数据字段}}{{背景}}
Example output
Hypothesis: the repeat-rate drop comes from new-customer churn in the first 30 days, not from lower frequency among existing customers.
How to use it
Ask for a framework before calculations; it prevents wrong period-over-period comparisons.
Recommended tools
Related prompts
Office
Meeting Summary Prompt
Turn a transcript into decisions, action items and risks, not a transcript dump.
通义听悟Notion AIMicrosoft 365 Copilot
Office
Excel Formula Prompt
Describe the need in plain language and get an explainable, testable Excel formula.
DeepSeekKimiMicrosoft 365 Copilot
Office
PPT Outline Prompt
Turn a topic into a narrative PPT outline instead of a pile of facts.
DeepSeekKimiSlidesAI