Best Gemini prompts for Compensation, Benefits, and Job Analysis Specialists

Using a dataset of 500 current employees, including variables such as job title, department, location, years of experience, and current salary, perform a multiple linear regression analysis to predict salary ranges for new hires in the marketing department, assuming a 10% increase in market rates over the next quarter; provide coefficients for each independent variable, an R-squared value, and a scatterplot with a regression line.

Design a Google Data Studio dashboard to track and analyze employee benefits enrollment, including metrics such as participation rates, plan selection, and demographic breakdowns; incorporate data from your HRIS system, including employee demographics, benefits elections, and enrollment status; create visualizations for each metric, including bar charts, pie charts, and scatterplots, and provide filters for location, department, and job function.

Create a points-based job evaluation system, including a set of compensable factors such as knowledge, skills, and responsibilities, and assign weights to each factor based on their relative importance to the organization; develop a scoring system, including a range of points for each factor, and apply the system to a set of 10 example jobs, including job descriptions, factor levels, and total point scores; provide a table summarizing the results, including job titles, point scores, and corresponding salary grades.

Conduct a market pricing analysis for executive compensation, including a review of proxy statements, executive compensation surveys, and online job postings; gather data on base salary, bonus, and long-term incentive compensation for a set of 20 comparable companies, including revenue, industry, and location; calculate the 25th, 50th, and 75th percentiles for each compensation element, and create a report summarizing the results, including recommendations for executive compensation adjustments; provide a table comparing your organization's current executive compensation levels to the market data, including percentages of difference from the market median.