📊 Excited to share my latest Data Analysis project: IBM Workforce Analytics & Employee Retention Dashboard!

As a Freelance Data Analyst, I wanted to dive deep into human resource data to uncover the real drivers behind employee attrition and corporate turnover.

🔹 Technical Workflow:

Data Cleaning & Preparation: Leveraged advanced Excel to handle missing values, validate data types, and ensure data integrity.

Exploratory Data Analysis (EDA): Built complex Pivot Tables to cross-reference multiple variables (Department, Job Role, Overtime, and Satisfaction Levels).

Interactive Dashboard Design: Designed a dynamic executive dashboard with integrated Slicers (Gender, Overtime, Marital Status) for seamless, interactive filtering.

📉 Key Insights & Takeaways: • Executive Metrics: Analyzed a workforce of 1,470 employees (Average Salary: $6,502.93) with an overall Attrition Rate of 16.12%. • Departmental Impact: The Research & Development department holds the largest workforce but experiences the highest absolute turnover with 133 departures. • The Overtime Risk: Employees working Overtime represent a critical risk factor, directly accounting for 23% of total attrition. • Satisfaction Correlation: Departures are heavily concentrated among employees reporting low job satisfaction (Level 1 & Level 2).

🛠️ Tools Used: Microsoft Excel (Power Query, Pivot Tables, Advanced Charts, Slicers).

🔗 Check out the detailed repository and code on my GitHub: [https://github.com/AbdelhaqTheAnalyst/IBM-HR-Analytics-Dashboard ]

hashtag#DataAnalysis hashtag#DataAnalytics hashtag#ExcelDashboard hashtag#HRAnalytics hashtag#FreelanceDataAnalyst hashtag#DataDriven