Implementing Custom Logic

SQL Server 2014    |    Intermediate
  • 7 videos | 50m 9s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 2 users Rating 4.5 of 2 users (2)
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

  • 6m 14s
    After completing this video, you will be able to describe and display key performance indicators. FREE ACCESS
  • 7m 4s
    After completing this video, you will be able to describe and display key performance indicators. FREE ACCESS
  • Locked
    3.  Creating Calculated Members in a Multidimensional Model
    5m 38s
    Learn how to create calculated members using the Cube Designer tool. FREE ACCESS
  • Locked
    4.  Creating Named Sets in a Multidimensional Model
    5m 56s
    In this video, you will create named sets using the Cube Designer. FREE ACCESS
  • Locked
    5.  Defining Time Intelligence Calculations
    7m 25s
    During this video, you will learn how to define time intelligence calculations using the Business Intelligence Wizard. FREE ACCESS
  • Locked
    6.  Creating Relative Measures
    8m 11s
    During this video, you will learn how to create relative measures, including using growth, year-over-year, and same period last year. FREE ACCESS
  • Locked
    7.  Using Ranking, Percentile, and Percentage of Total
    9m 41s
    In this video, find out how to implement rank, percentile, and percentage of total using MDX. 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

Audiobook Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition
Book SQL Server Analytical Toolkit: Using Windowing, Analytical, Ranking, and Aggregate Functions for Data and Statistical Analysis
Course Querying SQL Databases: Prompt Engineering to Work with Advanced SQL Operations
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)