• Online, Self-Paced
Course 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.

Learning Objectives

Dimensions in SQL Server 2014

  • 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

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration
  • Systems Development