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 Defining a Positioning

Defining a clear positioning is the cornerstone of any effective marketing strategy. Without solid positioning, your messages get lost in the noise and your brand becomes interchangeable with the competition.

Gemini Prompt for Evaluating Skills

Skills assessment is a fundamental process in recruitment, professional training, and talent management. Traditionally time-consuming and prone to bias, this approach can be significantly optimized thanks to artificial intelligence. Gemini, Google's AI model, stands out for its ability to analyze complex profiles, structure evaluation grids, and produce personalized recommendations. Whether you are an HR manager, team lead, trainer, or consultant, using Gemini to evaluate skills allows you to gain objectivity and precision. The model excels at creating customized competency frameworks for each profession, designing realistic scenarios, and comparative profile analysis. It can also identify skills gaps within a team and propose targeted development plans. By combining Gemini's analytical power with your professional expertise, you obtain more rigorous, documented, and actionable evaluations. This prompt has been designed to make the most of Gemini's reasoning capabilities in the specific context of professional evaluation.

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 Generating Exercises

Gemini, Google's artificial intelligence model, excels at creating structured educational content adapted to different learning levels.

Gemini Prompt for Generating Python Code

Gemini, the artificial intelligence model developed by Google, is a powerful tool for generating Python code. Thanks to its deep understanding of programming languages and best practices, Gemini can produce functional, documented, and optimized code in seconds. Whether you are a beginner developer looking to learn Python basics or a professional wanting to speed up your workflow, a well-structured prompt makes all the difference between a rough result and production-ready code. The main challenge lies in the precision of your request: the more you specify the context, technical constraints, expected code style, and edge cases to handle, the more Gemini will be able to generate relevant and robust code. In this guide, we offer optimized prompts that fully leverage Gemini's capabilities for Python code generation, covering different complexity levels and common use cases. You will learn how to formulate your requests to get clean, tested, and PEP 8-compliant code.

Gemini Prompt for Generating SQL Queries

Gemini, Google's artificial intelligence model, excels at generating SQL queries thanks to its deep understanding of data structures and database syntax.

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.