Disclaimer – The datasets are generated through random logic in VBA. These are not real human resource data and should not be used for any other purpose other than testing.
Other data sets – Sales Credit Card Bank Transactions HR Analytics
Note – I have been approached for the permission to use data set by individuals / organizations. I just want to clarify one thing. Anything published on this is completely copyright free. You can use anything from this site without any obligation. You can even call the content from this site as your own. Hope, it clarifies. There is absolutely no need to ask for permission for use.
You can download sample csv files ranging from 100 records to 5000000 records. These csv files contain data in various formats like Text, Numbers, Date, Time, Percentages which should satisfy your need for testing.
This data set can be categorized under "Human Resources" category.
Below are the fields which appear as part of these csv files as first line.
The macro which is used to generator can be downloaded from Random HR Data Generator. The result data will be populated in Raw Data tab.
All files are provided in zip format to reduce the size of csv file. Larges ones are also provided in 7z format apart from zip format to gain further reduction in size.
| 100 Records | 1000 Records | 5000 Records | 10000 Records |
| zip, 13 KB | zip, 118 KB | zip, 589 KB | zip, 1.18 MB |
| 50000 Records | 100000 Records | 500000 Records | 1m Records |
| zip, 5.91 MB | zip, 11.82 MB | zip, 59.04 MB | zip, 123 MB |
| 2m Records |
2m Records | 5m Records | 5m Records |
| zip, 246 MB | 7z, 155 MB | zip, 614 MB | 7z, 387 MB |
thank you !
Thanks a lot ..
Thanks for Helping me with this.
Thanks a lot for ready made data.
hi
Thank you so much, you are awesome
Fantastic thanks! Would be great if this could include "Department"?
Good input. Will work this out during weekends.
what is the schema of the above datasets?
Thank you very much for sharing the datasets. I am currently putting together a Microsoft Excel course and plan on using this dummy data. I can see you mentioned in the above comments that there are no conditions attached so I really appreciate that. I will however, make sure I reference where the Dummy Data came from as that is the least I can do 🙂
Thanks again!
Thanks a lot, please tag the same in youtube or any other to this website, really helpful
Thank You so much 🙂
Thank you so much and i am also looking for similar kind of data along with date of leaving row as well .
Please do let me know if you have any.
Thank you so much for prompt response
Thank you so much for prompt response
anyone has a ready project for this dataset ?
Thanks a lot these data are really good
I am using sales records from this site and seeing date column data is in two formats (MM/DD/YYYY) and (MM-DD-YYYY)?
not sure how to fix it in larger files.
could you please help me in generating date column with same format for all the rows?
Nice, valuable offering!
Here's what I'm using as the schema:
create table core_rec (
emp_id int,
name_prefix varchar( 5 ),
first_name varchar( 11 ),
middle_initial varchar( 1 ),
last_name varchar( 13 ),
gender varchar( 1 ),
email varchar( 50 ),
father_name varchar( 35 ),
mother_name varchar( 35 ),
mother_maiden_name varchar( 35 ),
birth_date date,
birth_time time,
age_in_yrs numeric(5,2),
weight_in_kg smallint,
join_date date,
join_quarter varchar( 2 ),
join_half varchar( 2 ),
join_year smallint,
join_month_no smallint,
join_month_name varchar( 9 ),
join_month_short varchar( 3 ),
join_day smallint,
join_dow_name varchar( 9 ),
join_dow_short varchar( 3 ),
age_in_company numeric(5,2),
salary numeric(8),
last_percent_hike smallint, — percent
ssn char(11),
phone varchar(20),
place_name varchar( 35 ),
county varchar( 22 ),
city varchar( 35 ),
state varchar( 2 ),
zip varchar(12),
region varchar( 9 ),
username varchar( 15 ),
password varchar( 15 )
)
very much appreciated, thankyou so much.