20 of the best prompts for market data analysis, step by step across 4 stages. Works with ChatGPT, Claude, and Gemini.

20 of the best prompts for market data analysis, step by step across 4 stages. Works with ChatGPT, Claude, and Gemini.
Published June 27, 2026
Getting Market Data Analysis right takes more than a single prompt. This 4-stage guide covers Collect and Organize Market Data, Analyze Trends and Patterns, Generate Actionable Insights, and more, breaking the whole process into focused steps where each prompt builds on the last. Analysts, investors, and business strategists often struggle with the overwhelming volume of market data and trends, which can lead to missed opportunities or poor decision-making. The four stages in this guide cover how to collect and organize data, analyze trends and patterns, generate actionable insights, and present findings effectively. Users will produce structured analyses and reports that inform strategic decisions. Every prompt is optimized and runs in ChatGPT, Claude, and Gemini.
This stage focuses on gathering relevant market data from various sources and structuring it for analysis. Proper organization ensures that the data is accessible and ready for deeper insights.
Identify key data sources for analysis
Create a detailed report on key data sources for analyzing [INDUSTRY OR MARKET SEGMENT]. Structure the report with sections for each source, including a description of the type of data provided, the frequency of updates, access requirements, and potential limitations. Additionally, provide recommendations on how to effectively integrate these sources into a comprehensive data collection strategy, ensuring that the approach aligns with best practices in market data analysis.
Create a data collection plan
Draft a comprehensive data collection plan for analyzing [SPECIFIC MARKET TREND]. Include the objectives of the data collection, specific metrics to track, a detailed timeline for data collection, and the tools or platforms that will be utilized. Ensure that this plan provides clear guidance for your data gathering efforts and outlines how each element contributes to the overall analysis.
Organize data into a structured format
Create a data organization plan for the collected market data on [SPECIFIC TOPIC]. Structure the plan to include sections for data categories for segmentation, recommended file formats (e.g., CSV, Excel), and suggested software tools for data management (e.g., Tableau, Google Sheets). For each section, explain how it contributes to making the data accessible for analysis and provide a brief rationale for each choice made to ensure clarity and effectiveness in data handling.
Develop a data inventory checklist
Create a comprehensive data inventory checklist for [COMPANY OR PROJECT] in a table format. The checklist must include the following columns: Data Type, Source, Last Updated Date, Responsible Team Member, and Notes. Each row should represent a different data entry, ensuring that all relevant market data is accounted for. Additionally, write a brief introduction that explains the importance of maintaining an up-to-date data inventory for effective market analysis, highlighting how it can improve decision-making and strategy formulation.
Assess data quality and reliability
Assess the quality and reliability of data from [SOURCE OR DATABASE] by producing a detailed report. Structure the report into sections that include an overview of data accuracy, completeness, consistency, and timeliness. In each section, provide specific examples to support your evaluation, and include a subsection for documenting any potential biases or limitations that could affect your analysis. Conclude with actionable recommendations for addressing identified issues to enhance data quality.
In this stage, users will analyze the organized data to identify significant trends and patterns. This analysis is crucial for making informed business decisions.
Identify key trends in market data
Analyze the collected market data on [SPECIFIC MARKET OR INDUSTRY] and produce a detailed report identifying three key trends. For each trend, provide a summary of the observed changes, analyze potential causes, and discuss the implications for the business. Structure the report with clear headings for each trend, and conclude with strategic recommendations based on your findings.
Perform a SWOT analysis on market data
Conduct a detailed SWOT analysis report based on the trends identified in [SPECIFIC MARKET] for the period of [TIME FRAME]. Structure the report into four sections: strengths that highlight competitive advantages, weaknesses that outline potential challenges, opportunities for growth or innovation, and threats that may impact market stability. For each section, provide specific examples and relevant data points to support your analysis, ensuring that the insights are actionable for strategic decision-making.
Use statistical methods to analyze data
Analyze the data on [SPECIFIC TOPIC] using statistical methods to identify key trends and patterns. In your report, include an overview of the statistical techniques applied, such as regression analysis and correlation, along with a summary of the findings. Discuss how these insights can guide strategic decisions and ensure the report is clear and concise, incorporating visual aids like charts or graphs to illustrate important points effectively.
Visualize data trends with graphs
Create a detailed report visualizing data trends related to [SPECIFIC MARKET TREND] using various types of graphs. Start with an introduction that summarizes the trend, followed by a series of graphs such as line charts and bar graphs that illustrate key data points. Conclude with insights derived from the visuals, ensuring each graph is clearly labeled and includes a brief analysis explaining its significance in the context of the market trend.
Benchmark against industry standards
Conduct a comparative analysis report of [YOUR COMPANY OR PROJECT] against industry benchmarks in [SPECIFIC INDUSTRY OR SECTOR]. Structure the report into three sections: first, provide an overview of the key performance indicators (KPIs); second, perform a detailed analysis highlighting areas of strength and weakness; and third, offer actionable recommendations for improvement. Include relevant data visualizations to support your findings, and conclude with a summary of insights that can guide strategic decision-making.
This stage focuses on translating the analyzed data into actionable insights that can guide business strategies. Clear insights are essential for effective decision-making.
Summarize key insights from data analysis
Generate a detailed report summarizing the key insights from the analysis of [SPECIFIC DATA SET]. Include an executive summary, a section on the most significant findings and their implications for [SPECIFIC BUSINESS CONTEXT], and a set of recommended actions based on these insights. Ensure that each section is clearly labeled and provides concise, actionable information to guide decision-making.
Develop strategic recommendations
Create a strategic recommendations report based on insights from [SPECIFIC MARKET TREND] for [COMPANY NAME]. The report should include an executive summary, three detailed recommendations with clear implementation steps, expected outcomes for each strategy, and an analysis of potential risks. Additionally, conclude with a section that highlights the overall impact of these recommendations on the company's growth and market positioning, ensuring that each recommendation is actionable and relevant to current market conditions.
Create an insights report for stakeholders
Draft a comprehensive insights report for stakeholders based on the analysis of [DATA SET]. The report should include an executive summary that highlights the main findings, a detailed analysis of key insights, actionable recommendations tailored to [SPECIFIC BUSINESS CONTEXT], and clearly defined next steps for implementation. Ensure the language is clear and concise, making it easy for decision-makers to understand and act upon the information presented.
Identify potential market opportunities
Generate a detailed report identifying three potential market opportunities based on the trends observed in [SPECIFIC MARKET]. For each opportunity, include clearly labeled sections that outline the target audience, potential challenges, and recommended strategies for market entry. Ensure that the insights provided are actionable and can guide business decisions. Finally, conclude the report with a summary of the overall market potential and implications for future strategies.
Assess risks associated with insights
Evaluate the risks associated with the insights gained from the analysis of [DATA SET]. Present your findings in a structured report that includes sections for identified risks, potential pitfalls, and suggested mitigation strategies. For each risk, explain its impact on decision-making and outline actionable steps to address these risks in future strategies. Ensure the report is clear and concise, and conclude with a summary of key insights.
In this final stage, users will focus on presenting their findings in a way that is clear and impactful. Effective communication is key to ensuring that insights lead to action.
Create a presentation for stakeholders
Create a PowerPoint presentation for stakeholders that summarizes the findings from the market analysis of [SPECIFIC TOPIC]. Structure the presentation with the following sections: an introduction to the data sources, a detailed overview of key trends, actionable insights, and strategic recommendations. Include visuals such as charts and graphs to enhance engagement and support your points. Conclude with a compelling call to action that encourages stakeholders to implement the insights. Ensure the design is visually appealing, maintains a professional tone throughout, and is suitable for a business audience.
Draft an executive summary of findings
Draft an executive summary report based on the findings from the analysis of [DATA SET]. Include an introduction outlining the purpose of the analysis, a summary of key insights derived from the data, strategic recommendations for action, and proposed next steps. Ensure the summary is concise, informative, and tailored for busy executives, aiming for clarity and impact in communication while keeping it under 500 words.
Prepare a Q&A session for stakeholders
Create a Q&A session script for stakeholders based on the findings from [SPECIFIC ANALYSIS]. Structure the script into three sections: an introduction summarizing key insights, a list of anticipated questions with clear and concise responses, and a conclusion that reinforces the importance of the findings. Ensure the responses address potential concerns, emphasize actionable steps, and include a brief note on how each response aligns with the overall objectives of the analysis.
Develop an infographic to illustrate insights
Create a detailed infographic that visually represents the key insights from the analysis of [DATA SET] and [TARGET AUDIENCE]. Structure the infographic with an engaging title, a summary of findings, relevant charts and graphs, and concise bullet points that highlight the most critical insights. Ensure the design is clear and visually appealing to facilitate understanding of complex information, making it actionable for the audience.
Compile a follow-up action plan
Compile a detailed follow-up action plan based on the insights presented to stakeholders regarding [SPECIFIC TOPIC]. Structure the plan into the following sections: an executive summary, specific actions to be taken, responsible parties, timelines for each action, and metrics for measuring success. Ensure that each section is clearly labeled and includes sufficient detail to facilitate accountability and progress tracking.
Common tools include Excel for data manipulation, Tableau for visualization, and Python or R for statistical analysis. Each tool has its strengths depending on the complexity of the data and the analysis required.
To ensure data reliability, source information from reputable databases, cross-verify with multiple sources, and regularly update your data inventory. Implementing a data quality assessment process can also help.
Common pitfalls include data overload, misinterpreting correlations as causation, and failing to consider external factors. It's important to maintain a clear focus on objectives and validate findings against industry benchmarks.
Use clear visuals, avoid jargon, and focus on key insights and actionable recommendations. Tailoring your presentation to the audience's knowledge level can enhance understanding and engagement.
Focus on metrics that align with your business goals, such as market share, customer growth rate, and sales trends. These metrics provide a clear picture of performance and market dynamics.
AI Prompts for DeepSeek for Data Analysis
Data analysts often struggle with efficiently extracting insights from large datasets.
See promptsAI Prompts for Data Analysis
Data analysts often face challenges in extracting insights from complex datasets, leading to time-consuming processes and potential errors.
See promptsAI Prompts for Python Scripts
Data analysts and scientists often spend excessive time writing and debugging Python scripts for data analysis, which can hinder productivity.
See prompts