All case studies. Browse by sector

DataCactus dataCactus
Case studies How we work
Talk to us

Case studies · Charities & care

HR analytics pipelines for a national charity

Fortnightly manual extracts from the HR and payroll systems became automatic daily updates into one organised set of figures, with each manager seeing only their own teams.

Client
A national health charity
Built with
Azure Data Factory, Azure Functions, Power BI

The problem

The charity already used Power BI for HR reporting, but the data behind it was extracted by hand from the HR system and the payroll platform every two weeks. The flat data model limited what could be reported, and sharing was managed through basic filters rather than proper access control.

What we built

  1. 1An automatic daily feed from the HR system
  2. 2Browser automation for the payroll platform where no API was available
  3. 3The data organised so payroll, leave, turnover and vacancies can be viewed by employee, department and employment type
  4. 4Access set by the organisation chart, so each manager sees only their own teams

What changed

  • —Refreshes moved from every two weeks to daily without staff involvement
  • —Reports became easier to build and could be shared securely by role

More in Charities & care

Referral automation for a special-education and care provider A special-education and care provider Corporate services source of truth for a social-impact charity A national social-impact charity Sector page Charities & care Referrals, reporting and back office for providers and charities