HR Attrition & Workforce Dashboard (Excel + Power Query)
Built an HR attrition and workforce dashboard by cleaning, transforming, and structuring a raw dataset for analytic use. Used Excel with Power Query to standardize fields and prepare data for KPI computation and visualization. Translated cleaned data into executive-ready outputs to support workforce insights and attrition monitoring. • Performed data cleaning and formatting with Power Query • Created PivotTables and PivotCharts to derive attrition breakdowns • Designed KPI cards (headcount, attrition count/rate, tenure, age, income) • Prepared data transformations aligned to dashboard decision needs