Employee Data Analysis - Tableau

Project Overview:

The Employee Data Analysis project aims to leverage advanced data analytics techniques to extract valuable insights from an organization's workforce data. By systematically analyzing various aspects of employee information, this project strives to provide actionable insights for informed decision-making, talent management, and overall organizational optimization.

Tools Used ?

1. Excel

2.Tableau

Data Cleaning ?

Remove Duplicates: Eliminated duplicate values from the dataset.

Format Modification: Adjusted data formats for numbers and dates.

Concatenate Function: Combined first and last names using the "concatenate" function to create a new column named "Employees."

Fill Missing Data: Populated empty cells in the "ExitDate" column for active employees and filled missing data in the "TerminationDescription" column.

Data Analysis

Pivot Table: Utilized Pivot tables to count the total number of employees based on department type.

VLOOKUP Function: Employed the "VLOOKUP" function to retrieve employee ID and job function descriptions.