Designing & Implementing Dimensions

SQL Server 2014    |    Intermediate
  • 10 Videos | 1h 8m 51s
  • Includes Assessment
  • Earns a Badge
Likes 15 Likes 15
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

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 61 Likes 61  
Likes 12 Likes 12  
Likes 498 Likes 498