Data Warehouse
Intelligently combining data, automatically finding important insights, and informing users in a straightforward, clear manner.
NHS organisations gain accessible and understandable HR analytics to support evidence-based decisions that ultimately advance workforce efficiency and effectiveness.
Providing understandable HR analytics to support evidence-based decisions, that ultimately advance workforce efficiency and effectiveness.
Solution Benefits
Intelligently combines data
Automatically finds important insights
Informs users in a clear straightforward manner
How does it work?
We maintain an SQL Server Data Warehouse that extracts data each night from the live Workforce application databases along with external client data sources. The Data Warehouse is made up of a variety of services including a set of development tools (for the creation of the modules that extract, merge, manipulate, cleanse, and conform the data) and a set of databases (to hold the various stages of data, including the final reporting datasets, making up hundreds of millions of lines of data).
A BI tool (Tableau) sits on top of the data warehouse which is used to provide visual insights into the data to enable the end user to make decisions more quickly and easily by either self-service, push email alerts or subscriptions. This tool also provides alerts to crucial KPIs which are sent directly to the user’s email including standardised Board Report packs to remove the need to copy and paste from multiple sources every month.
The Data Warehouse benefits trust leaders by intelligently combining data, automatically finding important insights, and informing users in a straightforward, clear manner. NHS organisations gain accessible and understandable HR analytics to support evidence-based decisions that ultimately advance workforce efficiency and effectiveness.
Related Solutions
NHS At Work Rota & Roster
An electronic scheduling solution, designed, created and owned by the NHS with central funding from NHS England. It allows trusts to create Rota patterns and Rosters with staff members to fulfil those patterns of work.
Task Management
Digital task management tool supporting: Patient flow, rapid response, elective recovery, care coordination, community discharge, virtual wards, portering and lateral flow staff self-testing reporting. Staff can log, share and coordinate daily tasks, enabling healthcare workers to share information and optimise patient care.
Talk to our Experts
Our Liaison Workforce Experts are here to help. Find out how they can help you with your HR Analytics.
