Designing & Implementing Dimensions

SQL Server 2014    |    Intermediate
  • 10 videos | 1h 3m 51s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 13 users Rating 4.5 of 13 users (13)
A data warehouse combines data from multiple sources that can be used to create analytical reports. Explore schemas and tables that are created within it, and how to create dimension and fact tables.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 10m 18s
    Upon completion of this video, you will be able to describe the SQL Server Business Intelligence platform. FREE ACCESS
  • 5m 47s
    Upon completion of this video, you will be able to understand slowly changing dimensions. FREE ACCESS
  • Locked
    3.  Dimension Tables and Attributes
    7m 54s
    After completing this video, you will be able to describe how to implement dimensions and attributes. FREE ACCESS
  • Locked
    4.  Hierarchies
    3m 59s
    Upon completion of this video, you will be able to describe how to design hierarchies. FREE ACCESS
  • Locked
    5.  Schema Options
    3m 9s
    After completing this video, you will be able to recognize attributes of star and snowflake schemas. FREE ACCESS
  • Locked
    6.  Fact Tables
    6m 24s
    After completing this video, you will be able to describe how to implement fact tables. FREE ACCESS
  • Locked
    7.  Auditing and Lineage
    4m 42s
    In this video, learn how to determine when to use auditing and lineage tracing. FREE ACCESS
  • Locked
    8.  Keys
    5m 45s
    Upon completion of this video, you will be able to recognize when to use keys. FREE ACCESS
  • Locked
    9.  Implement Dimensions
    10m 40s
    In this video, learn how to use dimensions. FREE ACCESS
  • Locked
    10.  Implement Data Lineage
    5m 15s
    In this video, learn how to implement data lineage for a dimension table. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel Data Visualization
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Book Data Mesh in Action
Book Database Performance at Scale: A Practical Guide

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Designing Control Flow
Rating 5.0 of 3 users Rating 5.0 of 3 users (3)
Course Designing a Fact Table
Rating 4.3 of 18 users Rating 4.3 of 18 users (18)
Course Connection Managers & Data Sources
Rating 3.8 of 6 users Rating 3.8 of 6 users (6)