Data Warehouse Components

An Overview 

A central repository where raw data is transformed and stored in a queryable format. It includes commutative and historical data from single or multiple sources.

Introduction to Data Warehouse

1. Data Warehouse Database  A database stores all company data and makes it manageable to report. Database types can be relational, analytical, cloud-based, or data warehouse applications.

Components of Data Warehouse

2. Sourcing, Acquisition, Cleanup, and Transformation Tools (ETL) The tool performs all summarizations, conversions, structural changes, key changes, and condensations required to convert disparate data into decision support data.

3. Metadata  Metadata serves as a framework for data in the data warehouse architecture. Assists in handling, maintaining, constructing, and utilizing data warehouses.

4. Query Tools  With query tools, you can access data and the database catalog, create and implement SQL queries, and manage database objects and database users.

5. Data Marts  A subset of data warehouses focused on particular lines of business, departments, or subject areas. Insights can be accessed instantly without searching through entire data warehouses.

6. Data Warehouse Management and Administration  Managing data warehouses includes:   - Security & priority management  - Data quality checks  - Managing & Updating meta data  - Purging data 

7. Information Delivery System Allocate data from the warehouse and information objects to different data warehouses and end-user products like local databases and spreadsheets.

Best  Practices for Creating Data Warehouse Architecture?

Click Here...