New Interactive HR Attrition Dashboard using Excel Data Analytics Tutorial Part 2 model, analyze

Part 2 of the HR #attrition #data #analytics #dashboard #tutorial for #beginners using #Excel.
/
In this second part you will learn how to use Excel to model, analyze and visualize a dataset.
Part 1: Extract, Transform, Load data (ETL): https://www.youtube.com/watch?v=1X3zVDE4fiM
Part 2. Model, Analyze, Visualize: https://www.youtube.com/watch?v=HpxlrnIIsr4
Part 3. Create the Dashboard, Report and Recommendation.
Also, this is the intermediate class. In the advanced class, you will use SQL and Python.
/
CONTENTS
00:00 Introduction
00:10 How to insert a pivot table
00:20 Pivot table fields explained
00:43 Count number of employees
01:15 Calculate attrition rate
02:33 How to create a doughnut chart
03:02 Number of employees by age range
04:06 How to create a column chart
05:07 Calculate average age range
05:51 Attrition by department
06:12 How to add a filter
07:15 How to create a bar chart
08:08 Attrition by gender
08:44 How to create a pie chart
09:20 Attrition by work location
10:25 Attrition by race
11:26 Attrition by state
11:52 How to create a map chart
/
Make sure to subscribe to my YouTube channel to be among the 1st persons to get updates of my upcoming tutorial: https://www.youtube.com/@learnwithetuk
/
Use the link below to download the dataset used in this tutorial:
https://docs.google.com/spreadsheets/d/14kGuvQzFtcMXqeJFsyTcta207SZ3VOpV/edit?usp=sharing&ouid=108749097505890338359&rtpof=true&sd=true