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.

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.

Benefits

Intelligently combines data

Automatically finds important insights

Informs users in a clear straightforward manner

Solutions To Support Your Current NHS Challenges

I want workforce MI that provides intelligent actionable analytics and insights.

Talk to our Experts

Our Liaison Workforce Experts are here to help. Find out how they can help you with your HR Analytics.