Designing a Fact Table

Designing a Fact Table

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

Overview/Description
Each data warehouse consists of at least one fact table, which contains fundamental measurements of the business. This course covers the implementation of fact tables using partitions, data compression, and columnstore indexes.

Target Audience
Data warehouse developers and database administrators who create and manage business intelligence solutions as part of their daily tasks, which include implementing data warehouse databases, extracting and transforming data as part of an ETL solution, and data cleansing

Prerequisites
None

Expected Duration (hours)
1.1

Lesson Objectives

Designing a Fact Table

start the course

describe data warehousing and its many relationships

appropriately index a fact table

describe columnstore indexes

demonstrate partitioning

recognize when to use additive and nonadditive measures

implement a fact table

determine the loading method for fact tables

design summary aggregation tables

implement a data warehouse database in SQL Server 2014

Course Number:
md_idwm_a02_it_enus

Expertise Level
Intermediate