Business Solutions with MDX

Harness the power of high-performance MDX calculations and queries to take your Analysis Services Multidimensional cubes to a higher level of analysis and reporting.
Course info
Rating
(11)
Level
Intermediate
Updated
Mar 31, 2017
Duration
5h 21m
Table of contents
Course Overview
Introduction and Foreword
Basic Solutions
Set-focused Solutions
Time and Date Solutions
Navigation and Hierarchical Solutions
Analytics and KPI Solutions
Beyond the Basic Cube Structure
Description
Course info
Rating
(11)
Level
Intermediate
Updated
Mar 31, 2017
Duration
5h 21m
Description

Learn how to harness the power of high-performance MDX calculations. In this course, Business Solutions with MDX, you'll confront many common business needs and then be provided a step-by-step MDX solution to each respective requirement. First, you'll learn about basic and set-focused. Next, you'll explore time and date-related topics. Finally, you'll discover the navigation, hierarchical, analytical, and KPI-focused. By the end of this course, you'll have gained an appreciation for "thinking in MDX" through many step-by-step approaches to answering business questions with the language.

About the author
About the author

Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies, focusing his practice upon the integrated Microsoft business intelligence solution. He leverages his years of experience with other enterprise OLAP and reporting applications (Cognos, Business Objects, Crystal, etc.) in regular conversions of these once-dominant applications to the Microsoft BI stack.

More from the author
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Bill Pearson. Welcome to my course Business Solutions with MDX. I'm a business intelligence architect, Microsoft MVP, and analysis services maestro at Island Technologies, Inc. Multidimensional expressions, or MDX, is the powerful query language with which we can retrieve and work with multidimensional data in Microsoft SQL Server Analysis Services. The better we understand MDX, the more elegant and effective our solutions will be. In this course we'll confront many common business needs and then provide a step by step MDX solution to each respective requirement. The main topics we'll cover include solutions that are basic and set-focused, time and dates related, navigation and hierarchical, and analytical and KPI-focused. By the end of this course you'll have gained an appreciation for thinking in MDX through many step by step approaches to answering business questions with the language. Before beginning the course you should have basic familiarity with dimensional modeling and general data warehousing concepts, exposure to MDX basics will also be useful. I hope you'll join me in learning practical MDX with the Business Solutions with MDX course at Pluralsight.

Time and Date Solutions
Having concentrated upon basic solutions and set-focused solutions, we'll next examine time and date solutions in this module of business solutions with MDX. In this section we'll overview the module and discuss our focus here using the incredibly effective MDX language to provide time and date related analysis, somewhat beyond the basics. Our examination will include five independent sections. To-date accretions or accumulations, compound date-based calculations, moving averages, last date concepts, and delivering the current date. The business world, like the natural world, is ruled by cycles - birth, growth, decline, death, and even rebirth. A critical task of analyst is to track measures as they change. We're constantly challenged to interpret the current business state at given times, typically in contrast to what it was in the past. An extended objective, obviously, becomes predicting what it could be in the future. Beginning with the rich time-based functions within the multidimensional expressions language we can assemble powerful metrics that meet and exceed typical business needs. In this module we'll overview some of the common time and date analysis and reporting needs we encounter in the business environment. Then we'll look at a handful or more challenging scenarios. As in the other modules of this course, we'll begin with a current state and a discussion of why we need to enhance that condition. We'll discuss an approach to meeting each of the business requirements with a focus upon an MDX time and date function or functions that are suited to meeting the respective need. For each of the MDX functions we introduce within the steps of meeting the related business need, we'll discuss the syntax and other details of its use and the data it returns.

Beyond the Basic Cube Structure
Analytical and KPI Solutions Part 2. We performed, in part 1 of this module, a general overview of analytical and KPI solutions along with exploring specific solutions for basic allocations in ABC classification. In this, the second part of analytical and KPI solutions, and the last module of our course, we'll spend the majority of our time within an iterative sample MDX analysis path that resembles the kind of analysis path we might encounter in the business environment. And finally, in the last section of this module, we'll take a look at Key Performance Indicators, or KPIs, in Analysis Services.