Build your own PivotTables: Exploratory analysis and dashboard reporting on employee attrition data.

Using the skills you gained from this class, you will work with a fake dataset of employee data to determine whether an employee ended up leaving the company (found in the Attrition column). When analyzing the data, keep in mind that each row represents one employee’s data.

In the resources for this class you’ll find the Excel workbook for this project called “HR_Employee_Attrition.xlsx.” The Excel file has already been structured for you so that you can practice what you learned about PivotTables and dashboard creation. Below is an overview of the worksheets you’ll need to reference for your project:

Raw Attrition Data - The main dataset
PivotTables - Where you should set up your PivotTables
Dashboard - Where you should put your PivotCharts, Slicers, and key takeaways

Please include the following elements in your project:

Create a few PivotTables using different columns from the dataset (put these on the PivotTables worksheet)
Create a few PivotCharts that show different columns from the dataset and show how they relate to employee attrition (add to Dashboard worksheet)
Create 1-2 slicers that let management change the PivotCharts on the fly
Add a few key takeaways after you’ve analyze the data (add to Dashboard worksheet)
Take a screenshot of your dashboard page and upload this screenshot to the Project page for this class for others to see
Add some of your takeaways about employee attrition and include it with your screenshot on the Project page

Here are a few tips to keep in mind for your project:

Calculated field for attrition percentage Adding a calculated field to calculate attrition % will make it easier to explore trends. I added a “COUNT” and “Attrition Flag” columns in the raw dataset that you can use to calculate the attrition % via a calculated field.
Ask questions! As you are building out the PivotTables and dashboard, please ask questions in the class discussions page. I will be checking the discussions actively.
Learn more about the dataset This fake dataset was created by IBM and you can learn more about the dataset on Kaggle here.

Resources

Connect with me on LinkedIn and follow me on Instagram, TikTok, and Quora
Check out my other Skillshare classes
Access the Excel workbook for your project, here.

Noah Apale

2

127