Conversation Between Colleagues

LARGE FACILITIES MAINTENANCE PROVIDER RELIANCE ON SPREADSHEETS

Lack of focus and investment in certain functional platforms left a newly formed JV struggling to consolidate results and was drowning in spreadsheets

Challenges

  • No single view of people metrics with three different approaches for a workforce of 6,000+ employees and contractors

  • People data maintained manually on dozens of excel workbooks

  • Inconsistent definitions between business units

  • Many sources of truth

  • Significant time to produce reports and a consolidated view

Solution

  • Initial diagnosis and deep dive on various people related metrics and definitions

  • Designed and Built a people data cube to maintain headcount, leave, diversity & other people sensitive data for HR teams

  • Re-defining of key HR terms, definitions and key business metrics on people data

  • Alignment across various HR teams

  • Designed dashboard reporting and rolled this out for board reporting and cost centre managers

Added Value

  • One source of the truth for reporting on people

  • Highlighting gaps on contracts in areas of diversity, leave, absenteeism and paygrades

  • Ability to make more strategic decisions

  • Assurance of an accurate dataset for purposes of planning and reporting