FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -A data warehouse is a central repository of information that can be analyzed to make more informed decisions. Data flows into a data warehouse from transactional systems, relational databases, and other sources, typically on a regular cadence.

Detailed explanation-2: -A data warehouse is a type of data management system that is designed to enable and support business intelligence (BI) activities, especially analytics. Data warehouses are solely intended to perform queries and analysis and often contain large amounts of historical data.

Detailed explanation-3: -Data warehousing improves the speed and efficiency of accessing different data sets and makes it easier for corporate decision-makers to derive insights that will guide the business and marketing strategies that set them apart from their competitors. Improve their bottom line.

Detailed explanation-4: -Data Warehouse (DWH), is also known as an Enterprise Data Warehouse (EDW). A Data Warehouse is defined as a central repository where information is coming from one or more data sources. Three main types of Data warehouses are Enterprise Data Warehouse (EDW), Operational Data Store, and Data Mart.