Data Warehouse Tutorial
Data Warehouse is nothing but relational database management system which is used for Querying the data for the purpose to do some analysis and to take some managerial decisions.
The definition for Data Warehouse (DWH) is collecting / Integrating data from different sources and converting that data into Information format for the purpose of taking managerial decisions.
Data Warehouse definition?
Data Warehouse is nothing but subject oriented, time variant, Integrated, history data and non volatile collection of data to do some analysis and to take some managerial decisions.
Data Warehouse Tutorial.
Data Warehouse Tutorials are designed for Beginners and learn Data Warehouse concepts from basics to Advanced topics. Every DWH tutorial is designed and explained in simple and easy steps.
- What is Data Warehouse?
- Data Warehouse Architecture?
- What is Data Mart?
- What is Data Modelling?
- What is Dimensional Table & Fact Tables?
- Schemas in Dimensional Modelling.
- What is Star Schema?
- What is Snow Flake Schema?
- Different types of Dimensions.
- Confirmed Dimension.
- Junk Dimension.
- Slowly changing Dimension.
- Degenerate Dimension.
- Role-playing Dimension.