Designing Dimensions

SQL Server 2014    |    Intermediate
  • 10 videos | 58m 29s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
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

  • 5m 11s
    In this video, you will learn how to create a dimension using the Dimension Wizard. FREE ACCESS
  • 4m 21s
    In this video, you will learn how to configure a dimension structure using the Dimension Designer. FREE ACCESS
  • Locked
    3.  Configuring Dimension Attribute Relationships
    5m 52s
    In this video, find out how to configure dimension attribute relationships using the Dimension Designer. FREE ACCESS
  • Locked
    4.  Developing New Custom Attributes on Dimensions
    9m 31s
    Learn how to develop a custom dimension attribute. FREE ACCESS
  • Locked
    5.  Creating User-Defined Hierarchies
    6m 35s
    Learn how to create user-defined hierarchies in dimensions. FREE ACCESS
  • Locked
    6.  Defining Translations for Dimension Metadata
    4m 8s
    In this video, you will learn how to create a translation for dimension metadata. FREE ACCESS
  • Locked
    7.  Creating a Time Dimension Using the Dimension Wizard
    6m 41s
    In this video, you will learn how to create a time dimension using the Dimension Wizard. FREE ACCESS
  • Locked
    8.  Modifying a Time Dimension Using the Designer
    3m 44s
    During this video, you will learn how to modify a time dimension using the Dimension Designer. FREE ACCESS
  • Locked
    9.  Managing Parent-Child Dimensions
    7m 16s
    During this video, you will learn how to manage dimensions that have a parent-child relationship. FREE ACCESS
  • Locked
    10.  Creating Linked Dimensions
    5m 10s
    In this video, you will learn how to create linked dimensions. 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

Book Hands-On System Design: Learn System Design, Scaling Applications, Software Development Design Patterns with Real Use-Cases
Course Microsoft Azure Infrastructure Solutions: Data Solutions
Rating 4.6 of 34 users Rating 4.6 of 34 users (34)
Journey Data Infrastructure with Apache Cassandra
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)