Smamele/hr-analytics-dashboard-powerbi-sql

HR Analytics Dashboard project built using Power BI and SQL. Analyses employee attrition, workforce demographics, salary trends, promotions, training, and job satisfaction across a South African telecommunications company. # HR Analytics Dashboard (Power BI + SQL) ## Project Overview This project analyzes employee attrition, workforce demographics, salary trends, promotions, training hours, and job satisfaction within a South African telecommunications company. ## Tools Used * Power BI * SQL * Excel ## Dashboard Pages ### Executive Overview * Total Employees * Attrition Rate * Average Salary * Average Years at Company * Attrition by Department * Attrition by Province * Attrition by Gender * Job Satisfaction Distribution ### Workforce Insight * Employees Left * Average Training Hours * Average Sick Leave Days * Promotion Rate * Employees by Department * Average Salary by Job Role * Promotion Analysis * Top Highest Paid Employees ## Key Insights * Marketing department shows the highest attrition. * Overtime employees have higher turnover rates. * Technology and Sales departments employ the largest workforce. * Promotion opportunities can improve employee retention. ## Files Included * Power BI Dashboard (.pbix) * SQL Analysis Queries (.sql) * Dataset (.xlsx) * Dashboard Screenshots ## Author Smamele Ngubane