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.
- 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.
- 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.
Leveraged Tableau for visualization and analysis, creating calculated fields for:
- Employees
- Sum of Terminated Employees
- Termination Rate
- Active Employees
- Training Cost
- MAX. Training Cost
- MIN. Training Cost
- Clone the repository to your local machine.
- Open the Excel file for a detailed breakdown of data cleaning and analysis steps.
- Explore the Tableau workbook for visualizations and calculated fields.
👥 Total Employees: 3000
🚷 Terminated Employees: 1467
🎯 Active Employees: 1533
💸 Training Cost: $1,675,886
💯 Termination Rate: 48.90 %
The project delivers comprehensive insights into workforce dynamics, performance metrics, and talent management. The combined use of Excel and Tableau ensures a thorough analysis of employee data, providing valuable information for strategic decision-making and organizational enhancement.
Feel free to contribute, provide feedback, or use the project as a reference for your own employee data analysis endeavors.
Happy Analyzing! 🚀