This project focuses on employee workforce analysis using Microsoft Excel. The objective was to transform raw employee data into meaningful business insights through data cleaning, calculated fields, pivot table analysis, and reporting.
The project analyzes employee demographics, department performance, salary distribution, bonuses, experience levels, and workforce structure.
- Microsoft Excel
- Pivot Tables
- Data Cleaning
- Text Functions
- Lookup Functions
- IF Functions
- Date Functions
- Dashboard Reporting
Several calculated columns were created to enhance analysis:
- Total Income Calculation
- Annual Salary Calculation
- Employee Experience Calculation
- Full Profile Generation
- First Name Extraction
- Last Name Extraction
Data was cleaned and structured for reporting and analysis.
- Department-wise employee distribution
- City-wise employee distribution
- Gender analysis
- Salary analysis
- Bonus analysis
- Total income analysis
- Annual salary calculations
- Employee rating evaluation
- Performance categorization
- Experience-based insights
- Department-wise salary comparison
- Workforce distribution by department
- Department performance observations
- IT department recorded the highest average salary.
- Sales department had the highest employee count.
- Employee compensation varied significantly across departments.
- Performance ratings helped identify top-performing employees.
- Experience and income analysis provided workforce insights.
- Department-level analysis supported resource planning and decision-making.
- Data Cleaning
- Data Transformation
- Excel Reporting
- Pivot Table Analysis
- Business Analytics
- Workforce Analytics
- Data Visualization
Successfully transformed raw employee data into structured analytical reports that provide actionable workforce and compensation insights for management decision-making.
Balram Kumar
Data Analyst | Excel | SQL | Power BI | Python