Solution
Databricks, Power BI
Solution
Databricks, Power BI
Industry
CPG
Region
North America
Technology
Databricks
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.