Analytics & BI · Nestlé
From scattered HR data to workforce planning teams can act on
HR analytics for a Nestlé workforce division in North America, so planners can see available resources against production targets
The challenge
Workforce planning needed a clear view of available people against production targets, but HR data lived in SAP and other systems with no model built for planning. Reports took manual effort and arrived too late to steer allocation.
How we approached it
- Data martsHR data marts on SAP data, with data models redesigned for reporting
- ETL pipelinesAutomated daily ingestion using AWS Glue and Databricks
- Workforce analyticsBI dashboards showing available resources against production targets
- OrchestrationA medallion architecture with clear bronze, silver and gold layers
- CollaborationWorking sessions with HR to understand pain points and agree requirements
What was delivered
A tested, layered HR data platform with daily refreshes and dashboards built around workforce planning decisions.
Impact
DailyAutomated refresh replaced manual pulls
Planners get faster, contextual insight into workforce capacity, with fewer operational bottlenecks in reporting.
More work
Related case studies
AI workflow automation · EMEA
From manual lead handling to automated marketing operations
80% less manual workload across 20+ EMEA countries
Read the case study →Data strategy · PetMediaGroupOne source of truth from 50+ scattered sources
50+ sources unified into one warehouse
Read the case study →Forecasting · DaikinFrom missed forecasts to plans the business trusts
61% → 87% forecast accuracy across 3 countries
Read the case study →