HR Analytics Dashboard
HR Analytics Dashboard
Embedded Files
Overview
Overview
Extracted and structured synthetic HR data with key workforce attributes for analysis
Transformed and validated datasets in Snowflake SQL to ensure analytical consistency
Loaded curated data into Looker Studio to build interactive workforce dashboards
Performed exploratory data analysis (EDA) to uncover patterns in hiring, turnover, tenure, and employee sentiment
Business Context
Workforce Overview
- Snapshot of employee distribution across the U.S. with interactive city and year filters for targeted drill-down analysis
- Active headcount vs. recent hires to quickly evaluate workforce growth and staffing balance
- Tenure insights for active and terminated employees to understand retention patterns and workforce lifecycle health
Turnover Analysis
- Highlights the top 5 employee exit reasons to identify key drivers of attrition and guide targeted retention strategies
- Compares voluntary vs. involuntary turnover to reveal potential gaps in training, performance alignment, or workforce fit
- Tracks monthly termination counts and turnover rates to uncover seasonal or recurring attrition patterns
- Provides branch-level detail to pinpoint locations with elevated turnover and support focused HR intervention
Exit Survey Analysis
- Analyzes exit feedback to uncover why employees leave, helping leadership strengthen retention strategies and employee experience
- Identifies roles with the highest exits to highlight workforce pressure points
- Groups departure reasons to reveal common attrition themes
- Applies Snowflake Cortex sentiment scoring (-1 = negative, +1 = positive) to quantify employee emotions at departure
- Visualizes recurring keywords through a word cloud to surface improvement opportunities
Architecture
Architecture
Pipeline Flow
- Extract: Generate and structure synthetic HR data with workforce attributes (demographics, hiring, tenure, exit feedback)
- Transform: Clean, standardize, and model data in Snowflake using SQL and CTEs for analytical consistency
- Load: Store curated datasets in Snowflake tables for reporting and analysis
- Validate: Perform data quality checks to ensure completeness and accuracy
- EDA: Conduct exploratory data analysis to identify patterns in hiring, turnover, tenure, and sentiment
- Visualize: Connect Snowflake to Looker Studio to build an interactive HR dashboard
- Snowflake account with SQL access
- Google / Looker Studio account
- SQL knowledge for data modeling
Page updated
Google Sites
Report abuse