CASE STUDY
BI & ANALYTICS

Savings and accurate reports with help of new Data Warehouse

Sogeti builds Extract, Transform and Load (ETL) processes to collect and process data from multiple resources.

Background

HSE Procurement works with vast amount of suppliers and vendors, for all aspects of purchasing. From stationary to syringes and x-ray machines to hospital dinners, HSE purchasing is a complicated and a large undertaking. As with any large organisation, the HSE have multiple systems, which store this information across many regions and facility types. Because of this, the HSE undertook a large project to consolidate as much logistics activity, as possible, into a central National Distribution Centre (NDC).

Solution

HSE required a Data Warehouse to hold purchasing information from all parts of the HSE. To achieve this, Sogeti and HSE designed a Data Warehouse to hold this information. Sogeti built Extract, Transform and Load (ETL) processes on Microsoft SQL Server and SQL Server Integration Services, to collect and process data from multiple data sources, like SAP. The ETL processes transform the data from these multiple sources, into a more homogenous format. Views were created to extract and process the data in the Warehouse, so that the HSE QlikView visualisation team can display the data in an easily readable format.

Benefits

Sogeti built a robust ETL, Data Warehouse and .Net solution to allow HSE to report accurately on their procurement data on a national level and to view individual purchases at a granular level. The system is designed with robust error handling to allow it to run with minimal support or intervention. HSE procurement can analyse purchasing data, find savings opportunities, and then Project Manage the creation and running of frameworks and contracts, in a .Net application, to realize savings.

todo todo
Contact
  • bi-a-lead
    John McIntyre
    BI & Analytics Lead
    +353 83 1189604
About HSE

The Health Service Executive (HSE) is responsible for the provision of health and personal social services for everyone living in Ireland, with public funds.

HSE is Ireland's largest employer with over 67,000 direct employees, and another 40,000 in funded health care organisations. It has an annual budget of over €13 billion, more than any other public sector organisation.