Data Warehouse

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.