ChatGPT Prompt for HR Data Analysis
HR data analysis has become a strategic lever for companies looking to optimize their human capital management. Turnover, absenteeism, performance, engagement, compensation: the data is there, but its exploitation remains often underutilized due to lack of accessible tools. ChatGPT changes the game by allowing HR professionals to query, summarize, and interpret their data without advanced technical skills. Whether you are an HR director, payroll manager, talent manager, or consultant, a well-crafted prompt enables you to obtain in seconds analyses that would take hours on Excel. The challenge is not simply to produce numbers, but to transform raw data into actionable insights: identifying factors of voluntary turnover, detecting pay gaps, anticipating recruitment needs, or measuring the impact of a training policy. In this guide, you will find a main prompt optimized for HR data analysis with ChatGPT, as well as variants adapted to your expertise level. Each prompt is designed to produce structured results that can be immediately used in your reports and presentations to management.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
You are a senior HR analyst specialized in people analytics. I will provide you with HR data (headcount, turnover, absenteeism, compensation, performance evaluations, seniority, etc.). Your goal is to produce a comprehensive and actionable analysis.
Here is the data:
[PASTE YOUR DATA HERE — table, CSV, or text description]
Analyze this data following this structure:
- Overview: Summarize key metrics (total headcount, breakdown by department/gender/seniority, average salaries).
- Identified Trends: Spot significant changes, anomalies, and correlations (e.g., link between seniority and turnover, gender pay gaps).
- Alerts: Flag concerning indicators that require immediate action (high turnover rate in a department, rising absenteeism, etc.).
- Benchmarks: Compare indicators to industry averages where relevant.
- Recommendations: Propose 3 to 5 concrete, prioritized actions, with expected impact and implementation timeline.
- Suggested Visualizations: Recommend the most relevant charts to present these results to management.
Adopt a professional yet accessible tone. Use percentages and precise figures. If data is missing for deeper analysis, state it explicitly.
Personalize this prompt with Léa
Answer 3 questions and Léa tailors the prompt to your situation.
Why this prompt works
This prompt is effective because it assigns a precise expert role (senior HR analyst), which guides the model toward a rigorous analytical register. The six-section structure imposes a comprehensive response framework that avoids superficial analyses. Finally, the instruction to flag missing data ensures the reliability of conclusions by preventing risky extrapolations.
Use Cases
Variants
Expected Output
You will obtain a structured HR report including a numerical summary of your key indicators, identification of trends and anomalies, prioritized alerts, and operational recommendations. The format is directly usable for a management committee or monthly reporting, with suggestions for visualizations adapted to your audience.
Frequently Asked Questions
What HR data can I provide to ChatGPT to get a good analysis?
You can provide any type of anonymized HR data: headcount tables, turnover and absenteeism rates, salary grids, annual review results, training data, tenure by department, and employee engagement survey results. The ideal format is a CSV table or a copy-paste from Excel. The more structured and complete your data is, the more relevant the analysis will be. It's imperative you anonymize personal data before sharing it (remove names, employee IDs, and any identifying information).
Can ChatGPT replace an HRIS or people analytics software?
No, ChatGPT is not a replacement for an HRIS or a dedicated tool like Workday, SAP SuccessFactors, or PowerBI. However, it excels as a complement for quickly exploring data, formulating hypotheses, preparing presentations, or getting an initial diagnosis. Its main advantage is accessibility: you don't need any technical skills to get a structured analysis. For recurring analyses on large volumes, a specialized tool remains essential.
How can I ensure the confidentiality of HR data shared with ChatGPT?
Confidentiality is critical. Always anonymize your data before submitting it: replace names with generic identifiers, remove exact dates of birth, addresses, and any information that could identify an employee. Preferably use aggregated data (averages per department, overall rates) rather than individual data. If your company has a ChatGPT Enterprise or Team subscription, your data is not used for model training. In all cases, consult your DPO before sharing sensitive data.
Learn more
Check the full skill on Prompt Guide to master this technique from A to Z.
View on Prompt Guide📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Similar Prompts
Implement a workforce planning approach
Structure a complete workforce planning approach with job mapping, gap analysis, action plans, and social dialogue.
Structure a complete 360-degree feedback
Generate a 360-degree feedback questionnaire adapted to the position and employee level, with structured closed and open questions.
Claude Prompt for Writing a Cover Letter
Writing a compelling cover letter is a delicate exercise that requires finding the right balance between professionalism, authenticity, and relevance. Claude excels at this task thanks to its ability to adapt tone, structure arguments, and personalize each application based on the target position and company. Unlike a generic copy-pasted template, a well-constructed prompt allows Claude to produce a tailored letter that highlights your specific skills, establishes a clear connection between your background and job requirements, and demonstrates your understanding of the company. AI does not replace your unique background, but it helps you express it with clarity and impact. Whether you are a recent graduate, career changer, or experienced executive, Claude can adapt its writing to your experience level and industry. The result: a structured, impactful, and authentic letter that captures recruiters' attention from the first lines and sets you apart from the hundreds of applications received for each offer.
Set SMART objectives for your team
Guide SMART objective setting in teams with participative process, strategic cascading, tracking, and gap management.