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