📊 Tools Used: Power BI, DAX, Power Query
📅 Project Date: June 2025
💼 Skills Demonstrated: Data Cleaning, KPI Design, Slicer Filters, Visual Storytelling
🔍 Project Overview
This Power BI project analyzes HR data to extract meaningful insights related to employee demographics, attrition trends, and department-wise performance.
The goal was to help a fictional HR team identify areas with high attrition and optimize workforce planning.
🧩 Key Features of the Dashboard
– Overall Attrition Rate, Gender Ratio, and Department Size
– Average Monthly Income per department
– Dynamic Filtering by Job Role, Gender, Education Field
– Trend Analysis over months/years
– Slicers to drill down by Department and Marital Status
🧩 Key Features of the Dashboard
🧠 Insights Discovered
– The highest attrition was found in the Sales Department
– Employees aged 26–35 were leaving the most
– Job Satisfaction scores were low among those who left
– R&D had the highest average income
🔧 Tools & Techniques Used
– Power Query for data transformation
– DAX to create KPIs like `Attrition %`, `Avg Salary`, etc.
– Card visuals, Bar Charts, Tree Maps
– Interactive Slicers and Filters
🔗 GitHub Link
🙋 About Me
I’m Satyendra Yadav — a Data Analyst and former math teacher with 2.3 years of experience. I’m passionate about transforming raw data into business insights using Power BI, SQL, and Excel.