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 Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition
Book Visual Data Insights Using SAS ODS Graphics: A Guide to Communication-Effective Data Visualization
Book Data Analytics with SAS: Explore Your Data and Get Actionable Insights With the Power of SAS

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Automation Design & Robotics
Rating 4.3 of 993 users Rating 4.3 of 993 users (993)
Course Azure Data Fundamentals: Azure SQL Querying Techniques
Rating 4.8 of 31 users Rating 4.8 of 31 users (31)
Course Creating Tabular Data Models
Rating 4.0 of 7 users Rating 4.0 of 7 users (7)