An End-to-End HR Analytics Project
DataCraft is a structured data analytics project that takes you through the journey of mastering essential data skills, culminating in the creation of an interactive HR Analytics Dashboard. The project is broken down into four learning and implementation phases designed to simulate real-world data workflows and project management.
-
Gained understanding of data-driven decision-making frameworks.
-
Learned and applied:
- RICE Scoring (Reach, Impact, Confidence, Effort)
- North Star Metric framework
-
Designed a roadmap to build an analytics product from scratch.
-
Learned how to write complex SQL queries.
-
Focus areas:
- Data extraction
- Aggregation and filtering
- Joins and subqueries
-
Simulated HR database interactions.
-
Used Excel for:
- Cleaning and preprocessing HR datasets
- Performing descriptive analytics
-
Used Tableau for:
- Interactive dashboard creation
- Visualization of HR metrics, attrition patterns, and demographics
-
Overall Stats: Employee count, Attrition count, Active employees, Attrition rate
-
Visualizations:
- Department-wise and Gender-wise Attrition
- Attrition by Education Field
- Job Satisfaction Matrix by Role
- Age Distribution of Employees
- Attrition Rate across Age & Gender groups
-
Interactivity:
- Bin size control for age group histograms
- Filter by education level
-
Insights:
- Highest attrition in R&D department
- Research Scientists show highest dissatisfaction
- Life Sciences field has the highest attrition count
- Project Planning: Google Docs
- Data Extraction: SQL (MySQL)
- Data Analysis: Microsoft Excel
- Data Visualization: Tableau
To build a data-driven, interactive HR dashboard that can assist organizations in:
- Identifying key attrition trends
- Understanding employee satisfaction
- Driving retention-focused decisions