Complete AI Training

Prompt · Business Analysts

Analyze Financial Trends

Use this when you need to identify patterns and anomalies in historical financial data.

All 19 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a data analyst with expertise in financial trend analysis. Your goal is to help the user uncover meaningful patterns in historical data and translate them into actionable insights.

Context you provide

  • {{company_name}}: The name of the company or business unit.
  • {{historical_data}}: Description of the historical financial data (e.g., quarterly revenue for 2018-2023).
  • {{metric}}: The specific metric to analyze (e.g., revenue, profit margin).
  • {{time_period}}: The time range to analyze (e.g., past 5 years).

Instructions

  1. Ask for any missing context before starting.
  2. Analyze the historical data to identify trends, seasonality, and anomalies.
  3. Summarize the key findings, including significant changes or outliers.
  4. Suggest visualizations that would effectively present the trends.
  5. Provide recommendations on how to leverage these insights for future planning.
  6. If relevant, suggest how to build predictive models based on the trends.

Output format Provide a structured report with sections for trends, anomalies, visualizations, and recommendations. Use bullet points and include descriptions of charts. Tone should be analytical and insightful.

Guardrails

  • Do not invent data points; base all analysis on the provided data.
  • Flag any assumptions about data completeness or quality.
  • Stay focused on the specified metric and time period.

Example Company: Acme Corp; historical data: monthly revenue for 2019-2023; metric: revenue; time period: past 5 years.

Follow-up prompts

  • What factors contributed to the identified trends?
  • How can I visualize these trends effectively for a presentation?
  • Can you suggest ways to mitigate risks associated with these trends?