Skip to content
No description, website, or topics provided.
TSQL R Other
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.Rproj.user
analysis
backup
data
hrsample_package_build
images
output
scripts
.Rhistory
.gitignore
00_run_all.R
01_functions.R
02_variables.R
03_positions_and_org.R
04_employee_info.R
05_initialize_employee_desk_history.R
06_grow_employee_desk_history.R
07_create_performance_reviews_salaries.R
08_employee_info_cleanup.R
09_recruiting.R
10_views.R
11_contact_info.R
12_education_skills.R
README.md
missingreviewstoss.csv
sample-hr-database.Rproj
todos.txt

README.md

sample-hr-database

FICTITIOUS Sample Human Resources database for a FICTITIOUS company. Names, locations, etc are contrived and determined randomly when possible.

The results of this work can be found in two sources:

This data is useable but anticipate changes over time. There are many issues that can be improved upon. For instance, employees cannot get rehired. There are an unusually high number of raises in 2018 due to a coding issue. I plan to fix these and others eventually.

Built using R and MySQL.

Exercises related to this data can be found at my blog: http://harry.ahlas.com

Images below, including an EER diagram, give you an idea of what is in the database.

EER diagram

Headcount information

Job information

Annual information about raises

Salary information

For questions/comments reach me at twitter https://twitter.com/harry_ahlas

You can’t perform that action at this time.