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
-
6m 14sAfter completing this video, you will be able to describe and display key performance indicators. FREE ACCESS
-
7m 4sAfter completing this video, you will be able to describe and display key performance indicators. FREE ACCESS
-
5m 38sLearn how to create calculated members using the Cube Designer tool. FREE ACCESS
-
5m 56sIn this video, you will create named sets using the Cube Designer. FREE ACCESS
-
7m 25sDuring this video, you will learn how to define time intelligence calculations using the Business Intelligence Wizard. FREE ACCESS
-
8m 11sDuring this video, you will learn how to create relative measures, including using growth, year-over-year, and same period last year. FREE ACCESS
-
9m 41sIn 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
Journey
How to Transform Tables with SQL