Designing and Implementing Dimensions

Designing and Implementing Dimensions

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

Overview/Description
A data warehouse combines data from multiple sources that can be used to create analytical reports. This course covers schemas and tables that are created within it and how to create dimension and fact tables.

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.2

Lesson Objectives

Designing and Implementing Dimensions

start the course

describe the SQL Server Business Intelligence platform

understand slowly changing dimensions

describe how to implements dimensions and attributes

describe how to design hierarchies

recognize attributes of star and snowflake schemas

describe how to implement fact tables

determine when to use auditing and lineage

recognize when to use keys

implement dimensions

implement data lineage of a dimension table

Course Number:
md_idwm_a01_it_enus

Expertise Level
Intermediate