Industry
CPG
Region
North America
Solution
Databricks, Power BI
Context
This case study showcases how our Talent Acquisition Dashboard transformed our client’s recruitment process by delivering real-time insights and automating manual tasks. With Power BI integration, the dashboard equipped the client’s team with the tools to make data-driven decisions, streamline hiring strategies, and enhance overall efficiency in talent acquisition.
Problem statement
Our client aimed to improve site-level recruitment and workforce management through a centralized, data-driven solution. They wanted to equip site business partners and P&O stakeholders with real-time insights to track essential metrics such as offer acceptance rates, recruitment rates, turnover, and vacancy status within a unified, intuitive dashboard. With clear, actionable visuals, they sought a solution that would empower stakeholders to make informed decisions, optimize workforce dynamics, and improve resource management across sites, effectively addressing their need for streamlined, data-backed workforce planning.
This dashboard also provides answers to critical questions such as:
- What is the average time to hire and time to fill for my site?
- How many offers have been accepted?
- What is the recruitment rate of my site?
- What is the rate of turnover on my site?
- How many positions are vacant on my site?
Impact
- 120+ Hours Saved: Average time saved monthly by automating data collection and reporting.
- 60+ Users: Regular weekly users of the dashboard, indicating its widespread adoption.
- 400+ Dashboard Views: The dashboard was accessed over 400 times in a month, demonstrating its value in ongoing decision-making.
- Improved Focus on Talent Strategies: With data tasks automated, the team shifted its focus to strategic hiring plans and meeting recruitment targets.