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
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
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.