Pivot table analysis
Perform an in-depth analysis of an Excel pivot table to extract trends and actionable insights.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
Je dispose d'un tableau croisé dynamique Excel avec les dimensions suivantes : [DIMENSIONS] (ex : région, produit, période) et les métriques : [METRIQUES] (ex : chiffre d'affaires, quantité, marge). Le tableau couvre la période [PERIODE] et les données proviennent de [SOURCE_DONNEES].
Analyse ce tableau croisé en :
- Identifiant les 3 principales tendances ou anomalies visibles
- Comparant les performances par [DIMENSION_PRINCIPALE] et expliquant les écarts significatifs
- Proposant 3 insights actionnables basés sur ces données
- Suggérant des dimensions ou métriques supplémentaires à ajouter pour approfondir l'analyse
- Recommandant une visualisation adaptée pour présenter ces résultats à [AUDIENCE] (ex : direction, équipe commerciale)
Structure ta réponse avec des titres clairs et termine par un résumé exécutif de 3 lignes maximum.
Personalize this prompt with Léa
Léa rewrites this prompt for your job and your exact goal — 3 quick questions.
Why this prompt works
<p>The prompt works well because it structures the analysis in distinct steps (trends, comparisons, insights, recommendations), which forces a complete and organized response. The variables allow it to be adapted to any business context.</p>
Use Cases
Expected Output
A structured analysis with identified trends, quantified comparisons, actionable insights, and visualization recommendations.
Improve this prompt
Run this prompt through the Optimizer to strengthen its context, constraints and expected format.
Improve this prompt with the OptimizerComments
- LéaAI
Pour renforcer l'analyse, ajoutez une demande de détection d'outliers via un seuil (ex. écart-type >2) et exigez une comparaison avec la période précédente pour ne pas confondre effet saisonnier et anomalie.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Advanced Excel formulas for data analysis
Provides advanced Excel formulas tailored to specific analysis problems with explanations and variants.
Jobs-to-be-Done analysis
Understanding the real job of the user
Evaluate a regression model
Evaluate regression model performance
Prompt Claude to Analyze User Feedback
Analyzing user feedback is a strategic lever for any company looking to improve its products and services. However, manually processing hundreds or even thousands of customer reviews is time-consuming and prone to interpretation bias. Claude excels at this task thanks to its ability to understand natural language nuances, detect implicit sentiments, and automatically categorize feedback along relevant axes. Whether it's product reviews, support tickets, NPS survey responses, or social media comments, Claude can extract actionable insights in seconds. By properly structuring your prompt, you get a systematic analysis that identifies recurring trends, prioritizes problems by impact, and provides concrete recommendations. This approach transforms raw qualitative data into a clear decision-making dashboard, allowing product, support, and marketing teams to act quickly on friction points identified by your users.