Best Gemini prompts for Human Resources Specialists

Analyze the open-ended responses from our latest employee engagement survey, which was completed by 500 employees, and identify the most common themes and sentiment patterns. Use natural language processing to categorize the responses into positive, negative, and neutral sentiments, and provide a breakdown of the top 5 themes by department. Assume the survey data is stored in a Google Sheets document with the following columns: Employee ID, Department, Response. Output the results in a Google Data Studio dashboard, including a sentiment analysis chart, a theme frequency chart, and a departmental breakdown table. Also, provide a list of recommended follow-up questions to ask in the next survey to drill deeper into the identified themes.

Using our company's hiring data from the past 2 years, which includes job posting dates, interview dates, and start dates, analyze the time-to-hire metrics for each department and identify the bottlenecks in the hiring process. Calculate the average time-to-hire for each department and compare it to the industry benchmark. Provide a detailed report outlining the recommended process improvements to reduce time-to-hire, including suggestions for streamlining the interview process, improving candidate communication, and enhancing the overall candidate experience. Assume the hiring data is stored in a Google BigQuery dataset with the following tables: job_postings, interviews, and new_hires. Output the results in a Google Slides presentation, including a time-to-hire histogram, a bottleneck analysis chart, and a list of recommended process improvements.

Develop a comprehensive diversity and inclusion dashboard using our company's demographic data, which includes employee demographics, hiring metrics, and promotion rates. Calculate the diversity metrics for each department, including gender, ethnicity, and age diversity, and compare them to the industry benchmarks. Provide a detailed analysis of the trends and patterns in the data, including insights into areas where the company is excelling and areas where improvement is needed. Assume the demographic data is stored in a Google Cloud Storage bucket with the following files: employee_demographics.csv, hiring_metrics.csv, and promotion_rates.csv. Output the results in a Google Data Studio dashboard, including a diversity metrics chart, a trend analysis chart, and a list of recommended diversity and inclusion initiatives.

Using our company's HR data from the past 5 years, which includes employee demographics, job history, and performance metrics, develop a predictive model to identify employees who are at high risk of turnover. Analyze the historical data to identify the most significant predictors of turnover, including factors such as job satisfaction, employee engagement, and career development opportunities. Train a machine learning model to predict the likelihood of turnover for each employee and provide a list of recommended retention strategies for the high-risk employees. Assume the HR data is stored in a Google Cloud SQL database with the following tables: employee_demographics, job_history, and performance_metrics. Output the results in a Google Sheets document, including a predicted turnover risk score for each employee, a list of recommended retention strategies, and a detailed analysis of the model's performance metrics.