Clinical DataWarehouse for a Datadriven Healthcare

Protect, promote and improve the health of citizens.

Regulate the organization, functioning, and management according to criteria of effectiveness, efficiency, and cost-effectiveness.

Manage resources, people and technologies according to the needs and the demand for the well-being of the population.

Assess the obtained results  in terms of health protection services.

The pre-existing organization made it difficult to identify both the data sources to be used and their cleanliness and uniformity. This procedure was necessary for each processing and was often carried out by different people: the generated results were different from each other. This resulted in a problem of trust in the data themselves, as well as in the difficulty to share homogeneous information that constituted a common heritage for the evaluation and business planning.

In the first phase of the project, it was decided to operate a low-impact technological update on the DWH infrastructure, extending the resources of the Vertica databases present in the company and supporting a system of Master Data Management for the company master data. This evolution enabled the preparation of a staging environment for production data, the structuring of a normalized top-level layer and the definition of two second-level layers (test and production) that group the data marts of the development and production environments. The availability of regional datacentres Lepida on cloud and the layered architecture made it possible to rapidly enrich the information content of the corporate DWH, integrating and executing at the same time the different processing phases of the data.

KNOWAGE fits into this architecture directly above the two second-level layers. Through the Behavioral Model, KNOWAGE regulates visibility on analyses and data based on user profiling.

The different functionalities of the SI and PM modules allow the rapid creation of standard reports with performance indicators and production monitoring.

Furthermore, it is now possible to launch data linkage actions and statistical analysis of health and administrative data with equal speed.

The main results of this project are above all the collection, normalization and centralized and systematic processing of data obtained thanks to the new DWH, from which derives the guarantee of a controlled and safe access by the different company counterparts to the information available.

This result is accompanied by the possibility of creating more articulated and complex analyzes based on the principles of value based health care model, of equity models and of the population health management.

SOLID ANALYSES

The analyses, carried out by Strategic Executives and Managers, are now based on a centralized and standardized system of data management and data quality.

REPEATABLE ANALYSES

Thanks to process optimization and advanced data analytics systems, analyses are constantly repeated and updated.

READABLE ANALYSES

The user has an immediate overall view of the processes. Using filters, drill down and cross navigation he can analyze a specific phenomenon in depth and on more dimensions in an intuitive way.