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