Implementing Custom Logic

SQL Server 2014
  • 7 Videos | 50m 30s
  • Includes Assessment
  • Earns a Badge
Likes 10 Likes 10
Attain better data aggregation and results for the user in SQL Server Analysis Services (SSAS). Learn how with custom logic implementation into a multidimensional model using calculated members, time intelligence, and named sets.

WHAT YOU WILL LEARN

  • describe and display KPIs
    describe and display KPIs
    create calculated members using the Cube Designer
    create named sets using the Cube Designer
  • define time intelligence calculations using the Business Intelligence Wizard
    create relative measures, including using growth, YoY, same period last year
    implement rank, percentile and percentage of total using MDX

IN THIS COURSE

  • Playable
    1. 
    Using KPIs in a Multidimensional Model - Part I
    6m 17s
    UP NEXT
  • Playable
    2. 
    Using KPIs in a Multidimensional Model - Part II
    7m 7s
  • Locked
    3. 
    Creating Calculated Members in a Multidimensional Model
    5m 41s
    FREE ACCESS
  • Locked
    4. 
    Creating Named Sets in a Multidimensional Model
    5m 59s
    FREE ACCESS
  • Locked
    5. 
    Defining Time Intelligence Calculations
    7m 28s
    FREE ACCESS
  • Locked
    6. 
    Creating Relative Measures
    8m 14s
    FREE ACCESS
  • Locked
    7. 
    Using Ranking, Percentile, and Percentage of Total
    9m 44s
    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 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

COURSE Managing Tabular Data Models
Likes 11 Likes 11  
COURSE Design & Install Analysis Services
Likes 11 Likes 11  
COURSE Azure Data Fundamentals: Provisioning & Configuring Relational Data Services
Likes 0 Likes 0