Data Warehouse (DWH)

Data Warehouse (DWH) is a system that consolidates data from different systems in the hospital (HBYS, LIS, finance, etc.) into a single centralized, consistent structure for analysis.

DWH is fed by operational systems through ETL processes and provides a reliable data foundation for business intelligence / analytical tools.

Other names / abbreviation: Data Warehouse, DWH.

What is it used for?

The data warehouse integrates scattered and differently structured data for analysis, stores historical data, and creates a single source of truth for consistent reporting/analytics.

Key features

• Centralized data model: Consistent integration of different sources.
• Historical data: Storage of data over time.
• Analytical foundation: Reliable source for BI and reporting.
• Data quality: Consistency and validation checks.

Integration and standards

Data Warehouse (DWH) does not operate in isolation; it typically exchanges data with the following systems and processes:

• ETL platform
• Operational systems (HBYS, LIS)
• Business Intelligence (BI)

Frequently referenced standards and regulations:

• KVKK
• Data modeling approaches

Benefits provided

• Integrated data for analysis
• Historical data storage
• Consistent reporting foundation

Selection and evaluation criteria

Main criteria considered when evaluating a data warehouse (DWH):

• Scalability
• ETL/BI integration
• Data quality tools

Points to consider

• Without data quality, the warehouse cannot produce reliable analytics.