Designing & Implementing Dimensions

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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE