Implementing Dimensions

SQL Server 2014    |    Intermediate
  • 10 videos | 49m 58s
  • Earns a Badge
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
A SQL Server Analysis Services (SSAS) cube includes measures and measure groups. Explore measures, including how to create and configure them for use in a cube.

WHAT YOU WILL LEARN

  • Create a basic measure
    Create a measure group
    Design granularity
    Create linked measure groups
    Use aggregation functions to create a additive measure
  • Use aggregation functions to create a non-additive measure
    Explain how to define a semi-additive measure
    Use aggregation functions to create a semi-additive measure
    Configure measure properties
    Configure measure group properties

IN THIS COURSE

  • 5m 41s
    Learn how to create a basic metric. FREE ACCESS
  • 4m 18s
    Learn how to create a measure group. FREE ACCESS
  • Locked
    3.  Designing Granularity
    7m 21s
    During this video, you will learn how to design a granular structure. FREE ACCESS
  • Locked
    4.  Creating Linked Measure Groups
    2m 54s
    During this video, you will learn how to create measure groups that are linked. FREE ACCESS
  • Locked
    5.  Using an Additive Measure in a Cube
    4m 42s
    Learn how to use aggregation functions to create an additive measure. FREE ACCESS
  • Locked
    6.  Using a Non-Additive Measure in a Cube
    5m
    In this video, you will use aggregation functions to create a measure that is not additive. FREE ACCESS
  • Locked
    7.  Defining Semi-Additive Behavior
    3m 34s
    After completing this video, you will be able to explain how to define a semi-additive measure. FREE ACCESS
  • Locked
    8.  Using a Semi-Additive Measure in a Cube
    4m 32s
    In this video, learn how to use aggregation functions to create a measure that is only partially additive. FREE ACCESS
  • Locked
    9.  Configure Measure Properties
    6m 22s
    In this video, learn how to configure measure properties. FREE ACCESS
  • Locked
    10.  Configure Measure Group Properties
    5m 33s
    In this video, you will learn how to configure properties for measure groups. 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

Course Working with Containers: Introduction to Kubernetes
Rating 4.5 of 35 users Rating 4.5 of 35 users (35)
Book SQL Server Analytical Toolkit: Using Windowing, Analytical, Ranking, and Aggregate Functions for Data and Statistical Analysis
Book Business Analytics with SAS Studio: Deliver Business Intelligence by Combining SQL Processing, Insightful Visualizations, and Various Data Mining Techniques , First Edition