HR data to BI
HR and payroll data in Power BI and the data warehouse automatically
An HR-to-BI integration makes employees, contracts, job and department history, absence and leave balances from the HR or payroll system available to Power BI or the data warehouse, so HR and finance report on current figures instead of exports. KoppelHet builds this integration between Nmbrs and Power BI, for example, also across several employers.
Topics
Everything about HR data in Power BI
An HR report in Power BI is only as good as the model underneath. Below is how we get the model right: history, turnover, several employers and who may see what.
History and counting
Looking back in time, and counting people and departures correctly.
Organisation and access
Several employers and countries in one model, and who sees which rows.
The situation
Every month someone exports lists from the HR or payroll system, pastes them into Excel and builds the management report there. With several employers this happens per employer. Figures on absence and turnover never quite match.
International: One report across countries, with local payroll data.
What the integration does
- Employees and contracts per employer
- Job and department history
- Absence and leave balances
- Derived figures such as average length of employment
Edge cases we handle
- History: who held which job in which department on a given date
- Several employers in one report
- Personal data that does not belong in the report
Integrations for this process
- Enterprise HR, International mid-market HR, Dutch HR and payroll to Reporting
Nmbrs → Power BI
Nmbrs to Power BI integration: HR and payroll data ready for reporting per company
AFAS Profit → Power BI
AFAS to Power BI integration: HR data from Profit in Power BI, with history and its own security
Workday → Power BI
Workday to Power BI integration: global HR data in Power BI, with retroactive changes handled correctly
Visma Raet YouForce → Power BI
YouForce to Power BI integration: HR and payroll data from Visma Raet in one reporting model
HiBob → Power BI
HiBob to Power BI integration: people data and work history from Bob in Power BI
Personio → Power BI
Personio to Power BI integration: employees, absence and pay costs from Personio in Power BI
Which systems we connect
Frequently asked questions
Which data ends up in the report?
Only what the report needs. We leave out BSN, address and bank account unless there is a reason to include them.
Can Power BI fetch the data itself?
Yes. The platform makes the data available at a secured address with its own key, and Power BI fetches it on refresh.