Skip to main content

Posts

Showing posts with the label DataWarehouse

Data Warehouse Architecture in detail

 Data Warehouse A data warehouse is a centralized repository of structured, organized, and historical data that is used for reporting, analysis, and business intelligence purposes. It is a historical collection of data from different sources that is integrated, cleansed, and organized for analysis.  Data warehouses are used to support business intelligence (BI) and decision-making. Characteristics of a Data Warehouse: Centralized repository : A data warehouse is a centralized repository of data, which means that it is a single source of truth for all of the data that is stored in it.  Historical data : Data warehouses typically contain historical data, which means that they store data that has been collected over a period of time.  Integrated data : The data in a data warehouse is integrated, which means that it has been combined from different sources.  Cleansed data : The data in a data warehouse is cleansed, which means that it has been cleaned of errors and inconsistencies. . Organ