Implementing Custom Logic
SQL Server 2014
| Intermediate
- 7 videos | 50m 9s
- Includes Assessment
- Earns a Badge
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 KPIsdescribe and display KPIscreate calculated members using the Cube Designercreate named sets using the Cube Designer
-
define time intelligence calculations using the Business Intelligence Wizardcreate relative measures, including using growth, YoY, same period last yearimplement rank, percentile and percentage of total using MDX
IN THIS COURSE
-
1.Using KPIs in a Multidimensional Model - Part I6m 14sUP NEXT
-
2.Using KPIs in a Multidimensional Model - Part II7m 4s
-
3.Creating Calculated Members in a Multidimensional Model5m 38s
-
4.Creating Named Sets in a Multidimensional Model5m 56s
-
5.Defining Time Intelligence Calculations7m 25s
-
6.Creating Relative Measures8m 11s
-
7.Using Ranking, Percentile, and Percentage of Total9m 41s
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.