HR Analytics Using Power BI For A Large Specialty Chemicals Company

Initial round of discussion with HRIS team helped identify the sources of data and the challenges team had with standardization. After detailed analysis of requirements, our team proposed a Power BI HR dashboard reporting solution which would give them most of the dashboards and reports created, after which it could be tweaked easily to each region’s or companies need, thus also eliminating rework or duplication. Reports were created persona based, to help explain why there is an increasing emphasis on finding and attracting the best talent. Our solution helped with the growing competition for talent which was a result of rising candidate awareness. Powerful reports and dashboard like Headcount summary, Turnover analytics, Employee Service Record and Job Change Analytics were prebuilt to help ease users to onboard to Power BI. The users could easily slice and dice the details by various classification such as race, gender, ethnicity job level, skill level, company, location etc. whether it was for headcount analysis or turnover.