Skip to main content
data intermediate

Create Comprehensive Trend Analysis Report

Generate professional trend analysis reports with data insights, visualizations, and actionable recommendations using this AI prompt template.

Works with: chatgptclaudegemini

Prompt Template

Create a comprehensive trend analysis report for [DATASET_TYPE] covering the [TIME_PERIOD]. Structure the report with the following sections: **Executive Summary**: Provide a 2-3 paragraph overview of the key findings and most significant trends identified. **Methodology**: Explain the data sources, analysis methods, and any limitations or assumptions made during the analysis. **Key Trends Identified**: Present 3-5 major trends with supporting data points. For each trend: - Describe the trend clearly - Provide quantitative evidence (percentages, growth rates, etc.) - Explain the underlying factors driving this trend - Assess the strength and reliability of the trend **Data Visualizations**: Suggest 3-4 appropriate chart types (line graphs, bar charts, heat maps, etc.) that would best illustrate the trends, including what data should be displayed and why each visualization type was chosen. **Comparative Analysis**: Compare current trends with historical data or industry benchmarks where relevant. Highlight any significant deviations or patterns. **Impact Assessment**: Analyze the potential business, market, or operational implications of these trends. Categorize impacts as short-term (0-6 months), medium-term (6-18 months), and long-term (18+ months). **Recommendations**: Provide 4-6 actionable recommendations based on the trend analysis, prioritized by potential impact and feasibility. **Risk Factors**: Identify potential risks or challenges that could affect the continuation of identified trends. **Conclusion**: Summarize the report with key takeaways and next steps for monitoring these trends. Format the report professionally with clear headings, bullet points where appropriate, and specific data references throughout.

Variables to Customize

[DATASET_TYPE]

The type of data being analyzed

Example: e-commerce sales data

[TIME_PERIOD]

The timeframe for the analysis

Example: Q1 2023 to Q4 2023

Example Output

# E-commerce Sales Trend Analysis Report: Q1-Q4 2023 ## Executive Summary Analysis of e-commerce sales data from Q1-Q4 2023 reveals significant shifts in consumer behavior and market dynamics. Mobile commerce emerged as the dominant channel, accounting for 67% of total sales by Q4, representing a 23% increase from Q1. Seasonal patterns showed earlier peak shopping periods and extended holiday sales windows, while customer acquisition costs decreased by 15% year-over-year. ## Key Trends Identified **1. Mobile Commerce Acceleration** - Mobile sales grew from 54% to 67% of total revenue, driven by improved mobile checkout experiences and social commerce integration. **2. Subscription Model Adoption** - Recurring revenue streams increased 34%, with average customer lifetime value improving by 28%. **3. Sustainability-Focused Purchasing** - Products with eco-friendly certifications saw 41% higher conversion rates. ## Recommendations 1. **Prioritize mobile optimization** - Invest in mobile-first design and one-click purchasing capabilities 2. **Expand subscription offerings** - Develop subscription models for top-performing product categories 3. **Enhance sustainability messaging** - Prominently feature environmental benefits in product descriptions 4. **Optimize inventory for extended seasons** - Adjust procurement cycles to match evolving seasonal patterns ## Risk Factors Economic uncertainty may impact discretionary spending, and increasing competition in mobile commerce could pressure margins.

Pro Tips for Best Results

  • Include specific metrics and percentages to make your analysis more credible and actionable
  • Use clear section headers and bullet points to make the report easily scannable for executives
  • Always provide context by comparing trends to previous periods or industry benchmarks
  • Focus on actionable insights rather than just describing what happened in the data
  • Include confidence levels or data quality notes to help readers understand the reliability of trends

Tags

Want 500+ Expert Prompts?

Get the Premium Prompt Pack — organized, tested, and ready to use.

Get it for $29

Related Prompts You Might Like