Data Warehouse
Welcome to the data warehouse help website! Are you a system analyst, data analyst, database administrator, programmer, project leader looking for one-stop information about data warehouse? The www.DataWarehouseHelp.com website is designed especially just for you. In our website you can find various data warehouse topic including data warehouse definition, architecture, design, references, books…etc.
Data warehouse definition
Let’s start with a simple question about data warehouse definition. What is data warehouse? Well, there are several popular data warehousing definitions from well-known data warehousing authors such as Bill Inmon and Ralph Kimball. Each data warehouse definition has its own approach however they share the same desirable feature that data warehouse has enterprise focus so that it enables to provide strategic information to help business to make decision faster and more effective.
Data warehouse architectures
This section discusses about various data warehouse architectures including Bill Inmon’s enterprise data warehouse and Ralph Kimball’s dimensional data warehouse. We also examine federated data warehouse architecture that has been the most practical approach for building data warehouse system. In addition, you will know how to differentiate between data warehouse and data mart.
Data warehouse concepts
In this section, you will find all fundamental data warehousing concepts including star schema, snowflake schema, dimension, fact table, logical data model, physical data model, slowly changing dimension…etc.
Data warehouse design
This section covers one of the most important topic in data warehousing: data warehouse design. You will learn various data warehouse design methodologies including bottom-up, top-down and hybrid design.
ETL – extract, transform and load
ETL plays a crucial role in data warehousing environment. In this section, you will find all information on ETL architecture, ETL process, ETL tools and etc.
Business intelligence
Business intelligence is decision support system (DSS) which aim to support better business decision making. Business intelligence often uses data provided by data warehouse. The concept of business intelligence is usually missed with data warehouse therefore in this section, we give you the definition of business intelligence and how it differ from data warehouse. You will also find a lot of useful topics about business intelligence including business intelligence architecture, business intelligence solutions and business intelligence applications…etc.
Data warehouse books
Are you looking for the best data warehouse books so you can master data warehouse or even build a good data warehouse for your business? You can find the data warehouse books with the good deals in data warehouse books section.