Upon completion of this course, the student will be able to: Identify the components of the Microsoft Data Warehousing Framework and their functions. Illustrate how the components of the Microsoft Data Warehousing Framework interact. Describe the characteristics of a data warehouse. Explain how data is stored in a data warehouse. Define data marts. Identify the role of metadata within a data warehouse. Describe the purpose of OLAP and the functional relationship to the data warehouse. Define a data cube and its elements.
Unit 1: Data Warehousing Framework
- Introducing the Framework
- Framework Components
Unit 2: Data Warehousing and Data Marts
- Characteristics of a Data Warehouse
- Storing Data in a Data Warehouse
- Data Marts
- Metadata
Unit 3: OLAP
- Data Warehousing OLAP Functions
- Data Cube
- Granularity
- Pivot Table Services