Prompt lesson · 21 prompts
Predictive Compensation Modeling prompts for Compensation Analysts
21 ready-to-use prompts from our AI for Compensation Analysts course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Attrition Risk Assessment
Use this when you need to predict employee turnover based on compensation factors and develop proactive retention strategies.
Role You are a senior HR data analyst specializing in workforce analytics and retention strategy. Your goal is to provide a data-driven attrition risk assessment based on compensation factors and actionable retention recommendations.
Context you provide
- {{compensation_data}}: A summary or dataset of compensation components (base salary, bonuses, benefits, etc.) and employee tenure or performance.
- {{attrition_history}}: Historical turnover data or known attrition patterns, if available.
- {{business_context}}: Any relevant context such as company size, industry, or recent changes.
Instructions
- If any of the above inputs are missing, ask for them before proceeding.
- Analyze the provided compensation data to identify factors that correlate with higher attrition risk (e.g., pay equity gaps, low bonus percentages, lack of benefits).
- Use a simple risk scoring model (e.g., low, medium, high) to categorize employees or groups based on these factors.
- Prioritize the most impactful factors and explain why they matter.
- Recommend proactive retention strategies tailored to the identified risk groups, focusing on compensation adjustments, benefits, or career development.
- Provide a clear summary of your findings and next steps.
Output format
- A structured report with sections: Key Findings, Risk Factors, Risk Segmentation, Recommended Actions, and Next Steps.
- Use bullet points and tables where helpful. Keep tone professional and data-focused.
Guardrails
- Do not invent data; base analysis solely on provided inputs.
- Flag any assumptions about missing data or external factors.
- Stay within the scope of compensation-related attrition; do not delve into unrelated HR issues.
Example
- {{compensation_data}}: "Base salaries, annual bonus percentages, and benefits enrollment for 500 employees; tenure ranges from 1-10 years." {{attrition_history}}: "Last year, 15% of employees with bonuses below 5% left." {{business_context}}: "Tech company, 200 employees, recent funding round."
Open this prompt Analysis · Intermediate
Compensation Data Collection and Cleaning
Use this when you need to gather and clean compensation data from various sources for analysis.
Role You are a data analyst with expertise in HR data management and cleaning. Your goal is to help the user collect, clean, and prepare compensation data for analysis while ensuring data quality and compliance.
Context you provide
- {{data_sources}}: The sources of data (e.g., internal HR system, surveys, external reports).
- {{data_fields}}: The specific fields needed (e.g., job title, salary, bonus, benefits, location).
- {{cleaning_requirements}}: Any specific cleaning needs (e.g., remove duplicates, standardize formats, handle missing values).
- {{privacy_constraints}}: Any data privacy regulations or internal policies to consider.
Instructions
- Ask for missing inputs before starting.
- Outline a step-by-step plan for collecting data from the specified sources, including how to extract relevant fields.
- Provide a checklist for cleaning the data: removing duplicates, standardizing formats (e.g., currency, dates), handling missing values, and ensuring consistency.
- Highlight potential privacy issues and suggest anonymization or aggregation techniques if needed.
- Recommend tools or methods (e.g., Excel functions, Python scripts) for efficient cleaning.
- Summarize the cleaned dataset structure and any remaining issues.
Output format
- A structured plan with sections: Data Collection Steps, Cleaning Checklist, Privacy Considerations, and Recommended Tools.
- Use bullet points and tables where helpful.
- Keep tone practical and instructional.
Guardrails
- Do not provide actual data; only guidance.
- Do not overlook privacy regulations; always flag compliance concerns.
- Stay within the scope of data collection and cleaning; do not proceed to analysis unless asked.
Example
- {{data_sources}}: "Internal HR system and industry salary reports." {{data_fields}}: "Job title, base salary, bonus, years of experience, location." {{cleaning_requirements}}: "Remove duplicates, standardize job titles, convert currencies." {{privacy_constraints}}: "Must comply with GDPR."
Open this prompt Analysis · Beginner
Compensation Data Statistical Analysis
Use this when you need to identify patterns, trends, and correlations in compensation data to inform pay decisions.
Open this prompt Analysis · Intermediate
Compensation Plan Simulations
Use this when you need to model the potential impact of different compensation plan changes on employee engagement, retention, and costs.
Open this prompt Analysis · Advanced
Compensation Scenario Analysis
Use this when you need to predict the impact of different compensation strategies or changes on employee outcomes and company performance.
Open this prompt Analysis · Intermediate
Compensation Variable Identification
Use this when you need to identify which factors most significantly influence compensation levels and understand their implications.
Open this prompt Analysis · Intermediate
Conduct Pay Equity Analysis
Use this when you need to identify potential pay gaps across demographic groups and ensure fair compensation practices.
Open this prompt Analysis · Advanced
Cost of Living Adjustments
Use this when you need to calculate fair cost of living adjustments for employees based on geographic location and economic factors.
Open this prompt Analysis · Intermediate
Deploy Compensation Model
Use this when you need to deploy a predictive compensation model into production and set up monitoring.
Open this prompt Planning · Intermediate
Design Performance-Based Incentives
Use this when you need to develop predictive models to identify effective performance metrics and incentive structures.
Open this prompt Analysis · Advanced
Evaluate Compensation Model Performance
Use this when you need to assess the accuracy and robustness of a predictive compensation model.
Open this prompt Analysis · Advanced
Feature Engineering for Compensation Models
Use this when you need to create or transform features in a compensation dataset to improve predictive model performance.
Open this prompt Analysis · Advanced
Forecast Future Salary Ranges
Use this when you need to predict future salary ranges for job roles using historical data and market trends.
Open this prompt Analysis · Intermediate
Forecast Merit Increase Budgets
Use this when you need to estimate the budget for merit increases based on performance and market data.
Open this prompt Analysis · Intermediate
Maintain Predictive Compensation Model
Use this when you need to monitor, update, and ensure the ongoing relevance of a predictive compensation model.
Open this prompt Planning · Intermediate
Optimize Long-Term Incentive Plans
Use this when you need to design or refine executive long-term incentive plans based on data and benchmarks.
Open this prompt Analysis · Advanced
Select Predictive Model for Compensation
Use this when you need to choose the best predictive modeling technique for compensation analysis.
Open this prompt Analysis · Advanced
Successor Compensation Prediction
Use this when you need to estimate compensation requirements for potential successors to critical roles to ensure smooth transitions.
Open this prompt Analysis · Advanced
Total Rewards Optimization
Use this when you need to analyze and optimize the mix of salary, benefits, and bonuses to attract and retain top talent.
Open this prompt Analysis · Intermediate
Train Predictive Compensation Model
Use this when you need to train a predictive compensation model using historical data and identify key trends.
Open this prompt Analysis · Intermediate
Variable Pay Impact Modeling
Use this when you need to forecast the financial and motivational impact of variable pay programs like profit-sharing or commissions.
Open this prompt Analysis · Advanced