Designing & Implementing Dimensions

SQL Server 2014
  • 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

Likes 5 Likes 5  
Likes 70 Likes 70  
Likes 13 Likes 13  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL Developer
Likes 152 Likes 152  
Likes 11 Likes 11  
Likes 26 Likes 26