people-data-analysis

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #ai #typescript #llm #go #golang #android #machine-learning #rust #deep-learning #linux

people-data-analysis

(★ 19)

👥 Employee analysis #DWD

people-data-analysis Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

![Star Badge](https://img.shields.io/static/v1?label=%F0%9F%8C%9F&message=If%20Useful&style=style=flat&color=BC4E99)
![Open Source Love](https://badges.frapsoft.com/os/v1/open-source.svg?v=103)
[![View My Profile](https://img.shields.io/badge/View-My_Profile-green?logo=GitHub)](https://github.com/ndleah)
[![View Repositories](https://img.shields.io/badge/View-My_Repositories-blue?logo=GitHub)](https://github.com/ndleah?tab=repositories)

# People Data Analytics <img src="/IMG/3aQl.gif" align="right" width="120" />

> 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

 * 🛠️ [Requirements](#️-requirements)
 * 📂 [Data Overview](#-data-overview)
 * 🚀 [Solution](#-solutions)
 * 🧙‍♂️ [Result](#️-result)

# 🛠️ 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

[![View Data Exploration Folder](https://img.shields.io/badge/View-Data_Exploration_Folder-A80101?style=for-the-badge&logo=GITHUB)](https://github.com/ndleah/HR-Analytics-Using-SQL/tree/main/1_Data_Exploration)

# 🚀 Solutions

[![View Data Join Folder](https://img.shields.io/badge/View-Problem_Solving_Folder-A80101?style=for-the-badge&logo=GITHUB)](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**

Source: Serious SQL

### ✅ **Employee Deep Dive**

Source: Serious SQL

# ✨ 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!
___________________________________

people-data-analysis

people-data-analysis Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

people-data-analysis

people-data-analysis Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README