Data & Analysis

Role: you are a top-level researcher.

Topic: [topic]

Task:
1. Find three sources whose viewpoints on this topic conflict with each other.
2. For each one, summarize its central evidence.
3. Point out where the three agree.
4. Highlight the main points on which they disagree.

Rules:
- Rank academic data or primary reports above news articles.
- Give a citation for every claim so its credibility can be checked.

Present the answer in sections: Source 1, Source 2, Source 3, Common ground, Key disagreements.

Dataset:
[paste data]

Task: analyze this dataset.

Output in three sections:
1. Summary of the key findings
2. Significant trends
3. Suitable visualization techniques to present the results

Decision I am evaluating: [specific decision]

Task:
1. Look for high-level expert opinions on this decision: what seasoned practitioners (PhDs, CEOs, Lead Engineers) say in forums, interviews and whitepapers.
2. Pull together their "unwritten rules" and the warnings you would not find with a basic search.
3. Turn these insights into a structured list of pros and cons.

Claim: [claim]

Task:
1. Look for the newest data, from the past six months, that can confirm or disprove this claim.
2. Bring out any nuance that most people are likely to overlook.
3. Link to official statistics or government reports.
4. If the data does not settle the question, explain why and recommend the metrics I should follow to find out what is true.

1. Phase 1 — Data reviewCopy

   Role: senior business analyst.
   
   Input: the spreadsheet I have attached to this conversation. If no file is attached, ask me to upload it before doing anything else.
   
   Task: study the spreadsheet and explain, with one heading per point:
   1. What the data represents
   2. The main trends
   3. Anomalies
   4. Missing values
   5. Errors that may be present
   6. High-level insights for the business

2. Phase 2 — Excel formulasCopy

   Input: the spreadsheet I have attached to this conversation. If no file is attached, ask me to upload it first.
   
   Task: write the precise Excel formulas this dataset needs so I can calculate:
   - growth rates
   - profit margins
   - forecasts
   - averages
   - lookups
   - conditional logic
   
   For every formula, walk me through how it works one step at a time.

3. Phase 3 — Data cleaningCopy

   Role: specialist in data cleaning.
   
   Input: the spreadsheet I have attached to this conversation. If no file is attached, ask me to upload it first.
   
   Task: find and list, in the data:
   - duplicate entries
   - formatting that is not consistent
   - missing values
   - formulas that are broken
   - outliers
   - any other problem with data quality
   
   After that, propose how to correct each issue you found.

4. Phase 4 — Business insightsCopy

   Role: senior strategy consultant reviewing the spreadsheet I have attached to this conversation. If no file is attached, ask me to upload it first.
   
   Task: identify
   - the strongest opportunities
   - the largest risks
   - trends that are not obvious at first glance
   - patterns in how customers behave
   - what drives revenue
   - recommendations to grow
   
   Base each recommendation on what you see in the data.

5. Phase 5 — Charts and dashboard ideasCopy

   Input: the spreadsheet I have attached to this conversation. If no file is attached, ask me to upload it first.
   
   Task: recommend the charts and dashboard layouts that suit this dataset best.
   
   For every recommendation, explain:
   - why it is important
   - which insight it reveals
   - the most suitable chart type
   - the key takeaway for an executive summary

6. Phase 6 — Automated reporting workflowCopy

   Input: the spreadsheet I have attached to this conversation. If no file is attached, ask me to upload it first.
   
   Task: design a reporting workflow, built on this spreadsheet, that runs automatically. Cover:
   - reports that repeat on a schedule
   - tracking of KPIs
   - alerts
   - summaries
   - how the dashboard is structured
   - recommendations on what to automate

7. Phase 7 — Executive summaryCopy

   Input: the spreadsheet I have attached to this conversation. If no file is attached, ask me to upload it first.
   
   Task: summarize the spreadsheet as if you were presenting it to a group of executives.
   
   Style: concise, strategic, grounded in the data and simple to follow.
   Focus: the decisions to take, the risks and the opportunities.

Role: you are a data analyst who explains results to non-technical colleagues.

Data:
[paste or describe your data]

Task:
1. Pull out the key insights and the trends that are not immediately visible.
2. Point out the patterns, anomalies and comparisons that stand out.
3. Summarize what you found in plain English.

Rules:
- simple explanations, no jargon
- back the points with relevant percentages or statistics
- close with actionable takeaways that help the reader make decisions
- if the data is incomplete or ambiguous, say what you assumed

Output sections: Key insights / Trends and patterns / Anomalies and comparisons / What to do next.

Topic: [topic]
Period: 2024-2025

Task: carry out a systematic review of this topic for this period, organized in four sections:
1. Where the industry stands today
2. Breakthroughs that are emerging
3. Serious failures or controversies
4. Market sentiment

Rules:
- Support every point with a URL that can be verified.
- No generic summaries: give priority to hard data.

Here is the data or information to analyze: [paste the data or describe it].

Work through it as follows:
1. Find the patterns, trends and anomalies, and pull out the key insights.
2. Summarize what you found in clear language.
3. Explain what the data really means for the decisions that need to be made.
4. Give recommendations I can act on, each grounded in the analysis.

Topic I am researching: [topic]
My goal: [goal]

Task: show me the "unknown unknowns", the things I have not yet thought to ask about.
- Look for recent anomalies, edge cases in niche areas and variables people overlook that could disrupt this field within the next twelve months.
- Link to the specific reports where each of these anomalies is discussed.