Designing Dimensions

SQL Server 2014
  • 10 Videos | 1h 2m 59s
  • Includes Assessment
  • Earns a Badge
Likes 6 Likes 6
In SQL Server Analysis Services (SSAS), a dimension is a collection of related objects used to provide the fact data to one or more cubes. Learn how to create dimensions, and how to configure relationships, hierarchies, and attributes.

WHAT YOU WILL LEARN

  • create a dimension using the Dimension Wizard
    configure a dimension structure using the Dimension Designer
    configure dimension attribute relationships using the Dimension Designer
    develop a custom attribute on a dimension
    create user-defined hierarchies in a dimension
  • define a translation for dimension metadata
    create a time dimension using the Dimension Wizard
    modify a time dimension using the Dimension Designer
    manage parent-child dimensions
    create linked dimensions

IN THIS COURSE

  • Playable
    1. 
    Creating a Dimension Using the Dimension Wizard
    5m 11s
    UP NEXT
  • Playable
    2. 
    Configuring a Dimension Structure Using the Designer
    4m 21s
  • Locked
    3. 
    Configuring Dimension Attribute Relationships
    5m 52s
  • Locked
    4. 
    Developing New Custom Attributes on Dimensions
    9m 31s
  • Locked
    5. 
    Creating User-Defined Hierarchies
    6m 35s
  • Locked
    6. 
    Defining Translations for Dimension Metadata
    4m 8s
  • Locked
    7. 
    Creating a Time Dimension Using the Dimension Wizard
    6m 41s
  • Locked
    8. 
    Modifying a Time Dimension Using the Designer
    3m 44s
  • Locked
    9. 
    Managing Parent-Child Dimensions
    7m 16s
  • Locked
    10. 
    Creating Linked Dimensions
    5m 10s

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 9 Likes 9  
Likes 10 Likes 10  
Likes 11 Likes 11