HR Analytics Case study
-
Datasets
-
Business Requirement (4:06)
-
Dataset walkthrough (3:41)
-
Data connection and cleaning (4:26)
-
1. # of Male and Female Staff (10:04)
-
2. % of Males and Females Staff (7:15)
-
3. Staff promoted in 2020 vs 2021 (2:38)
-
4. % of Staff promoted in 2020 vs 2021 (3:37)
-
5. % of Male and Female promoted in 2020 vs 2021 (11:37)
-
6. Staff promoted from Managers to Senior Manager in 2021 (3:58)
-
7. % of directors promoted in 2021 (4:53)
-
8. Directors who resigned in 2020 (4:10)
-
9. # of males and females who resigned in 2020 (2:52)
-
10. Turnover rate in 2020? (1:33)
-
11. Impact of new Salary Review (8:55)
-
12. Impact of new Salary Review (2:57)
Business Requirement 2
-
Business Requirement (1:54)
-
Dashboard Design strategy (4:58)
-
Case Study approach (3:22)
-
Dashboard Preview (1:23)
-
Average Salary Measure (1:37)
-
Customize Report theme (3:30)
-
Report Header (3:23)
-
Key performance Indicators (4:47)
-
Average Performance rating by Gender (7:41)
-
2020 Promotions by Gender (2:53)
-
Turonver rate by Gender (5:16)
-
Promotions in 2020 vs 2021 (4:59)
-
2021 Promotions by Gender (6:17)
-
Performance rating insights (2:36)
-
2020 Promotions insights (3:37)
-
Turnover by Gender insights (3:09)
-
2020 vs 2021 Promotions insights (3:53)
-
2021 Promotions insights (5:32)
-
Adding Icons to Dashboard (2:56)
Business requirement 3
Review and certification
