The Ultimate HR & People Analytics Dataset Generator
Every HR analyst knows the challenge: analyzing workforce trends like employee turnover, compensation equity, or recruitment effectiveness requires a complex, multi-faceted dataset. Finding realistic, anonymized practice data that connects employee records, performance reviews, and payroll information is nearly impossible.
That’s why we built the PNRao HR & People Analytics Data Generator.
This powerful tool creates a complete, enterprise-grade HR dataset with a single click. Whether you’re an HR professional building a headcount dashboard, a student learning about workforce analytics, or a data analyst tasked with modeling employee attrition, this generator provides the data you need. Stop working with simple employee lists and start analyzing the entire employee lifecycle.
Why This Dataset is a Powerful Learning Tool
Learning people analytics with abstract numbers can be challenging. This generator provides a realistic context that makes complex concepts easier to grasp.
- Builds a Narrative: You can step into the role of a People Analytics Specialist for the PNRao Company. Your task could be to identify which departments have the highest turnover, analyze the correlation between performance ratings and salary, or track the effectiveness of your company’s training programs. This narrative-driven practice helps solidify your understanding.
- Makes Concepts Concrete: When you see a
Performance Reviews
table linked toEmployee Master
andCompensation History
, abstract concepts become tangible. This makes metrics like Employee Turnover Rate, Compensation Ratio, and Performance Distribution easier to understand because you can see how they are built from the ground up. - Encourages Realistic Analysis: The rich context inspires more creative and insightful analysis. You might build a dynamic diversity and inclusion dashboard in Power BI or create a report in Excel to forecast future headcount needs. This allows you to practice not just the technical skills, but also the art of data storytelling.
Designed for Real-World HR Analysis
This dataset isn’t just a random collection of tables. It has been carefully crafted to mirror the data structures you will find in actual Human Resource Information Systems (HRIS) like Workday or SAP SuccessFactors, making it the perfect tool to develop practical, job-ready skills.
- Reflects Core HR Operations: Every HR department deals with
employees
,recruitment
,performance
, andcompensation
. The tables in this generator represent the core of what you will encounter professionally. By understanding how these tables relate to each other, you are learning the fundamental blueprint of people data. - Focus on a High-Demand Skillset: People analytics is one of the fastest-growing fields in data analysis. The skills you build here—analyzing turnover rates, evaluating recruitment funnels, and assessing employee engagement—are directly transferable to the tasks and challenges you will face in a real HR or data analytics job.
- Covers a Wide Range of Concepts: The structure of this data is intentionally designed to be a comprehensive playground for learning. With this single resource, you can practice:
- Excel/Sheets Functions: Use VLOOKUP or XLOOKUP to connect employee IDs with manager names, SUMIFS and COUNTIFS to create summary reports, and PivotTables to analyze headcount by department.
- Statistical Analysis: Use the data to practice correlation analysis (e.g., performance rating vs. salary) or to build simple predictive models for employee attrition.
- Data Cleaning: Use the “messy data” option to practice cleaning and validating employee records and performance data.
- Advanced Analysis: The interconnected tables are perfect for practicing relationship-building in Power BI or writing SQL
JOIN
queries to combine data from multiple sources for a complete analysis.
In short, learning with this dataset ensures you are not just practicing abstract concepts, but preparing yourself with the practical knowledge and experience valued by employers.
Tables Overview
The generator produces a wide array of datasets across different HR functions. Each dataset has a unique structure, as detailed below.
Core Employee Data
Table Name | Description | Columns |
---|---|---|
Employee Master | The main list of all current and past employees. | EmployeeID, FullName, Department, JobTitle, Email, Gender, HireDate, TerminationDate, Salary, ManagerID, PerformanceRating, Status |
Compensation History | A log of all salary changes for employees. | ChangeID, EmployeeID, ChangeDate, OldSalary, NewSalary, Reason |
Job History | A record of promotions and role changes for each employee. | HistoryID, EmployeeID, StartDate, EndDate, JobTitle, Department |
Talent Acquisition
Table Name | Description | Columns |
---|---|---|
Recruitment Funnel | Tracks candidates through the hiring process. | CandidateID, PositionID, JobTitle, ApplicationDate, Source, Stage, DateatStage |
Open Positions | A list of all currently open job requisitions. | PositionID, JobTitle, Department, DateOpened, HiringManagerID, Status |
Performance & Development
Table Name | Description | Columns |
---|---|---|
Performance Reviews | Records of annual or quarterly performance reviews. | ReviewID, EmployeeID, ReviewDate, ReviewerID, OverallScore, Communication, Teamwork, ProblemSolving |
Training Records | A log of all training courses completed by employees. | TrainingID, EmployeeID, CourseName, CompletionDate, Status, Score |
Succession Planning | Identifies potential successors for key roles. | PlanID, PositionID, PrimaryCandidateID, SecondaryCandidateID, Readiness |
Engagement & Relations
Table Name | Description | Columns |
---|---|---|
Leave & Attendance | A log of all employee leave requests. | LeaveID, EmployeeID, LeaveType, StartDate, EndDate, Days |
Engagement Surveys | Results from employee engagement surveys. | SurveyResponseID, EmployeeID, SurveyDate, OverallSatisfaction, WorkLifeBalanceScore, ManagerFeedbackScore |
Workforce Planning
Table Name | Description | Columns |
---|---|---|
Headcount & Attrition | A monthly summary of headcount changes. | RecordID, MonthEnd, Department, Headcount, Hires, Terminations, AttritionRate |
Skills Inventory | A list of skills possessed by employees. | SkillID, EmployeeID, SkillName, ProficiencyLevel |
How to Use This App
- Select a Table to Preview: Use the “Select Table to Preview” dropdown menu to choose the type of data you want to inspect.
- Specify the Number of Employees: Enter the desired number of employees. This is the main driver; a higher number will generate more related records in all other tables.
- Configure Advanced Options (Optional): Click on Advanced Options to expand the menu.
- Date Range: Select a Start Date and End Date to constrain the generated data to a specific time period.
- Data Quality: Choose the quality of your dataset (Clean, Slightly Messy, or Very Messy).
- Generate the Data: Click the “Generate All Datasets” button. The application will process your request and display a preview of your selected table.
- Download Your Data:
- Preview: To quickly download just the data shown in the preview table, click “Download Preview (CSV)” or “Download Preview (Excel)”.
- All Related Tables: Click “Download All Tables (Excel)” to download a single Excel file with every table on a separate, clearly named sheet. This is the best option for relational analysis.
How to Use This Data
- For Data Analysts & BI Professionals:
- HR Dashboards: Use the
Employee Master
,Headcount
, andPerformance Reviews
tables to build an executive-level dashboard in Tableau or Power BI. - Turnover Analysis: Analyze the
Employee Master
table to calculate attrition rates by department, tenure, or performance rating. - Practice SQL: Load the tables into a database and practice writing complex
JOIN
queries to link employees to their managers, salaries, and performance scores.
- HR Dashboards: Use the
- For Students & Educators:
- Create realistic case studies for human resources management, business analytics, and organizational behavior courses.
- Use the data as a foundation for assignments on calculating key HR metrics like employee turnover, compensation ratios, and recruitment cycle time.
Feedback & Suggestions
This tool is built for you. If you have an idea for a new HR table or an improvement, please leave your feedback in the comments section below.
Leave A Comment