Gemini Prompt for Data Analysis

Data analysis has become a fundamental pillar of decision-making in all business sectors. Whether you are a data analyst, project manager, entrepreneur, or researcher, the ability to extract relevant insights from raw datasets represents a major competitive advantage. Google Gemini, with its advanced contextual understanding and ability to process large volumes of structured and unstructured information, positions itself as a particularly powerful analytical assistant. By formulating precise and structured prompts, you can ask Gemini to identify trends, detect anomalies, calculate key metrics, segment your data, and produce actionable summaries. The challenge is no longer simply access to data, but knowing how to ask the right questions to extract value from it. This guide offers an optimized prompt to transform Gemini into a true analytical partner, capable of supporting you from initial exploration to formulating strategic recommendations based on data.

The prompt

Gemini

You are a senior data analyst with 15 years of experience in statistical analysis and business intelligence. I will provide you with a dataset [DESCRIBE FORMAT: CSV, table, etc.] concerning [TOPIC/DOMAIN].

Here is the data:
[PASTE DATA HERE]

Perform a complete analysis following this methodology:

Overview: Describe the structure of the dataset (number of rows, columns, types of variables, missing values).
Descriptive Statistics: Calculate key indicators (mean, median, standard deviation, min/max) for each relevant numerical variable.
Trends and Patterns: Identify main trends, possible seasonalities, and notable correlations between variables.
Anomalies and Outliers: Report any aberrant values or inconsistencies in the data with a possible explanation.
Segmentation: Propose a relevant segmentation of the data according to the most discriminating criteria.
Actionable Insights: Formulate 5 concrete and prioritized recommendations based on your analysis.

Present your results in a structured format with summary tables when relevant. Use clear and accessible language, explaining each conclusion by the data that supports it.

Personalize this prompt with Léa

Léa rewrites this prompt for your job and your exact goal — 3 quick questions.

Why it works

This prompt is effective because it assigns a precise expert role to Gemini, which activates a rigorous analytical response register. The six-step methodology guides the model through a structured analysis process that replicates the approach of a real data analyst, thus avoiding superficial responses. By explicitly asking for actionable recommendations supported by data, the model is forced to produce high-value insights rather than simple statistical descriptions.

Expected result

You will obtain a complete and structured analysis report including a dataset summary, descriptive statistics in table form, identification of major trends and anomalies, as well as a relevant segmentation. The report will conclude with five concrete and prioritized recommendations, each justified by factual elements from the analyzed data.

Variants by level

FAQ

How much data can I provide to Gemini for analysis?

Gemini can handle substantial volumes of textual data thanks to its large context window, especially with Gemini 1.5 Pro which accepts up to 1 million tokens. In practice, you can paste several thousand lines of data directly into the prompt. For very large datasets, it is recommended to provide a representative sample or a statistical summary, then ask Gemini to formulate the Python or SQL code needed to process the entire dataset on your infrastructure.

Can Gemini create charts and visualizations from my data?

Gemini does not directly generate interactive charts, but it can produce precise textual descriptions of recommended visualizations and, more importantly, generate complete code (Python with Matplotlib, Seaborn, or Plotly, or JavaScript with D3.js) to create these charts. You can ask it to produce visualization code adapted to your data, which you will then execute in your environment. Gemini excels particularly at recommending the most relevant type of chart based on the nature of your data and the insight you want to highlight.

How can I ensure the reliability of analyses produced by Gemini?

To maximize reliability, adopt three good practices. First, provide precise business context: the more Gemini understands the domain and objectives, the more relevant its analyses will be. Second, systematically ask Gemini to explain its methodology and limitations, allowing you to verify the coherence of the reasoning. Third, use Gemini as a tool for exploration and hypothesis formulation, then validate critical results with dedicated statistical tools (Python, R, Excel) before making strategic decisions. Gemini is an excellent analytical co-pilot, but human validation remains essential for high-stakes decisions.

How to use this prompt

Copy the prompt with the button above.
Paste it into ChatGPT, Claude or your favorite AI assistant.
Replace the bracketed variables with your details, then refine the result.

About Prompt Guide

Prompt Guide is a free library of 4800+ ready-to-use prompts for ChatGPT, Claude and other AIs, with guides to learn prompting and tools to build and optimize your own prompts.

Prompt library Learn prompting Prompt builder Prompt optimizer

Already have a prompt?

Paste it into the Optimizer, AI improves it in 5 seconds: role, context, format. Free, no signup.

Open the Optimizer

More prompts to explore

Gemini Prompt for Extracting Data Insights

Extracting insights from raw data is one of the major challenges facing analysts, data scientists, and decision-makers. Gemini, thanks to its

Gemini Prompt for Summarizing a Document

Summarizing a long document is one of the tasks where Gemini excels thanks to its massive context window that can handle up to 1 million tokens. Whether you have...

Gemini Prompt for Writing a Blog Post

Gemini, Google's artificial intelligence model, excels at writing long, structured content thanks to its ability to handle extended contexts and produce fluent text in French. To write an effective blog post, it's not enough to just say "write me an article": a well-constructed prompt must specify the topic, tone, expected structure, target audience, and editorial intent. By providing these elements to Gemini, you get a usable first draft that follows SEO best practices, captures attention from the introduction, and guides the reader to the conclusion. This guide offers one main optimized prompt and three variants tailored to your level of expertise, transforming Gemini into a real writing assistant. Whether you're a beginner blogger looking to publish regularly or an experienced content creator aiming for top rankings, these prompts will save you considerable time while maintaining a high level of quality.

Gemini Prompt for Writing a Business Proposal

Writing a compelling business proposal is a strategic exercise that requires combining a strong argument, clear structure, and personalization.

Gemini Prompt for Writing a Contract

Contract writing requires legal precision, editorial clarity, and adaptation to the specific context of each agreement. Gemini, thanks to

Gemini Prompt for Writing a Job Posting

Writing an effective job posting is a strategic exercise that goes far beyond a simple list of required skills. A well-constructed ad attracts the right profiles, reflects company culture, and stands out in a saturated recruitment market.

Go further

How to prompt Gemini

The complete guide: techniques, examples and best practices.

Free prompt library

4800+ prompts sorted by category, one-click copy.

Get new prompts every week

Join our newsletter.