KO
|
EN
gitlite โ search
Search
#javascript
#python
#hacktoberfest
#react
#ai
#typescript
#llm
#go
#golang
#android
#machine-learning
#rust
#deep-learning
#linux
people-data-analysis
โ 19
Open GitHub โ
๐ฅ Employee analysis #DWD
Download README (.md)
Explore Similar Repositories
GS.Adventure
:
Port of the classic "Adventure" console game for the Apple IIgs computer
UnityAI
:
AI in Unity.
jy_master_thesis
:
Master Thesis (2021, KAIST): The development of the scale-aware monocular depth estimation aided monocular visual SLAM system for real-time robot navigation
SYNLA-Plus
:
Successor to the original Synthetic Line Art (SYNLA) Dataset.
pcrgvg_flutter
:
appไธป่ฆ้ๅฏนๅ ฌไธป่ฟ็ปๅ ฌไผๆไฝไธ,็ฒไธ่ชๅถ,่ตๆบไธบcygamesๆๅฑ
// repository documentation
Was this content helpful?
โ 0
(0 ratings)
Select Rating:
โ
โ
โ
โ
โ
Submit Feedback
Recent Feedback
×
Download README
Do you want to download the
README.md
file for
people-data-analysis
?
Download (.md)
  [](https://github.com/ndleah) [](https://github.com/ndleah?tab=repositories) # People Data Analytics <img src="/IMG/3aQl.gif" align="right" width="120" /> <p align="center"> <img src="https://forthebadge.com/images/badges/built-with-love.svg"> <img src="https://forthebadge.com/images/badges/check-it-out.svg"> </p> > This case study is contained within the [Serious SQL](https://www.datawithdanny.com) by [Danny Ma](https://www.linkedin.com/in/datawithdanny/). # ๐ Table of contents <!--ts--> * ๐ ๏ธ [Requirements](#๏ธ-requirements) * ๐ [Data Overview](#-data-overview) * ๐ [Solution](#-solutions) * ๐งโโ๏ธ [Result](#๏ธ-result) <!--te--> <br /> # ๐ ๏ธ Requirements **HR Analytica** team requires 2 separate analytical views to be created using a single SQL script for two separate data assets that can be used for reporting purposes. A current snapshot of the information is required to power **HR Analytica**โs People Analytics dashboard and Employee Deep Dive shown above. The following data requirements is as follows: ### **1. Dashboard Data Components** <details> <summary> Click to view </summary> ๐ **Company Level Insights** * Total number of employees * Average company tenure in years * Gender ratios * Average payrise percentage and amount ๐ **Department Level Insights** * Number of employees in each department * Current department manager tenure in years * Gender ratios * Average payrise percentage and amount **Title Level Insights** * Number of employees with each title * Minimum, average, standard deviation of salaries * Average total company tenure * Gender ratios * Average payrise percentage and amount A historic data asset is also required by **HR Analytica** so their People Analytics team can perform deep dives into a specific employeeโs history. This analysis is used for decision making when it comes to pay rises and promotions. </details> ### **2. Deep Dive Data Components** <details> <summary> Click to view </summary> ๐ **Individual Employee Deep Dive** * See all the various employment history ordered by effective date including salary, department, manager and title changes * Calculate previous historic payrise percentages and value changes * Calculate the previous position and department history in months with start and end dates * Compare an employeeโs current salary, total company tenure, department, position and gender to the average benchmarks for their current position </details> # ๐ Data Overview [](https://github.com/ndleah/HR-Analytics-Using-SQL/tree/main/1_Data_Exploration) # ๐ Solutions [](https://github.com/ndleah/HR-Analytics-Using-SQL/tree/main/2_Problem_Solving) # ๐งโโ๏ธ Result ## Final Output Hooray! Finally, this is what out final input looks like: ### โ **People Analytics Dashboard** <p align="center"> <img src="https://github.com/ndleah/HR-Analytics-Using-SQL/blob/main/IMG/Current_Snapshot_Reporting.png" width=50% height=50%> <p align="center"> Source: Serious SQL </p> ### โ **Employee Deep Dive** <p align="center"> <img src="https://github.com/ndleah/HR-Analytics-Using-SQL/blob/main/IMG/Historic_Employee.png" width=50% height=50%> <p align="center"> Source: Serious SQL </p> # โจ Contribution Contributions, issues, and feature requests are welcome! To contribute to Patronify, see the GitHub documentation on **[creating a pull request](https://help.github.com/en/github/collaborating-with-issues-and-pull-requests/creating-a-pull-request)**. # ๐ Support Give a โญ๏ธ if you like this project! ___________________________________ <p>© 2021 Leah Nguyen</p>
