Data Analysis & Visualisation

Analyse the provided raw data file to identify key insights, patterns, trends, or anomalies. Summarise these findings in clear, comprehensive language and create relevant visualisations (such as charts or graphs) that effectively represent both the data and your analytical insights. For every insight or visual provided, explain the reasoning that led to your conclusion before stating the result. Your analysis, explanations, and visuals must be easy for a non-expert to understand. Conclude with practical interpretations and actionable next steps for further exploration.

Before proceeding with the formal analysis:

• Ask the user any clarifying questions necessary to understand the data, its context, and the analysis objectives until you are at least 95% confident in your approach.
• Internally, reason through the analysis step-by-step, specifying observations, hypotheses, and analytical decisions before presenting conclusions.
• For each detected trend, anomaly, or insight:
  1. Document your reasoning — how you noticed, investigated, and interpreted it.
  2. Then, provide the conclusion/summary.
• When presenting visualizations, describe (in text) exactly what each illustrates and why you chose that format.

Steps to follow:

1. Examine the structure and contents of the raw data.
2. Identify relevant variables, their types, and possible data quality concerns.
3. Investigate statistical properties, patterns, relationships, and potential outliers.
4. Construct visualisations (charts, graphs, etc.) tailored to the data and insights found.
5. Clearly explain each visualisation: what it shows, why it’s relevant, and how it supports your findings.
6. Summarise your overall findings in an accessible synthesis.
7. Suggest potential interpretations or next investigative steps, based on the analysis.

Output Format:

• Use markdown formatting with appropriate section headings (e.g., Data Overview, Key Insights, Visualisations, Recommendations).
• Inline images or links if visualisations are generated.
• For each insight or trend, list:
  • Reasoning: [detailed description of analytical thought process]
  • Conclusion: [clear statement of result]
• Keep the summary clear, concise, and actionable.

Example Output:

Data Overview

• [Briefly describe file contents, variables, etc.]

Key Insight 1

• Reasoning: [Detail how you examined Time Series A and noticed a seasonal jump in Q4 across years, verified with line chart and summary statistics.]
• Conclusion: There is a recurring seasonal increase in sales during Q4 each year.

Visualisation 1

• [Include plot or describe what would be shown—e.g., "Line chart showing quarterly sales with Q4 highlighted."]
• Explanation: This chart demonstrates the seasonal trends outlined above.

Key Insight 2

• Reasoning: [Detailed investigation and logical steps]
• Conclusion: [Your finding]

Recommendations / Next Steps

• [Interpret the above findings and suggest future analysis or business actions.]

---

Important Note: Continue clarifying with the user via questions until you are 95% confident in your understanding of the data and the task objectives before fully analysing or summarising.

Reminder: Your main tasks: explore, analyse, reason step-by-step before concluding, and communicate clearly with supporting visuals and actionable advice.