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.
What you'll learn
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.
Table of contents
- Introduction 3m
- Business Need: Return All Members 3m
- Business Solution: Return All Members 2m
- Business Need: Manage 'Divide by Zero' 3m
- Business Solution #1: Manage 'Divide by Zero' 4m
- Business Solution #2: Manage 'Divide by Zero' 2m
- Business Need: Restrict Output to Associated Members 4m
- Business Solution: Restrict Output to Associated Members 4m
- Business Need: Calculate Contribution to Parent 2m
- Business Solution - Step #1: Calculate Contribution to Parent 4m
- Business Solution - Step #2: Calculate Contribution to Parent 3m
- Business Solution - Step #3: Calculate Contribution to Parent 4m
- Conclusion and Summary 2m
- Introduction 2m
- Business Need: Best Performers - and Everyone Else 3m
- Business Solution Pt. 1: Best Performers - and Everyone Else 3m
- Business Solution Pt. 2: Best Performers - and Everyone Else 3m
- Business Need and Initial Solution: Extract and Present a Tuple 5m
- Business Solution Pt. 2: Extract and Present a Tuple 4m
- Business Need: Restrict Set Membership via Filtering 2m
- Business Solution: Restrict Set Membership via Filtering 4m
- Business Need: Exclude Set Members via Except() 2m
- Business Solution Pt. 1: Exclude Set Members via Except() 2m
- Business Solution Pt. 2: Exclude Set Members via Except() 2m
- Business Need: Set Sophistication with Extract() 2m
- Business Solution: Set Sophistication with Extract() 4m
- Business Need: Set Sophistication with Generate() 2m
- Business Solution Pt. 1: Set Sophistication with Generate() 2m
- Business Solution Pt. 2: Set Sophistication with Generate() 3m
- Conclusion and Summary 2m
- Introduction 2m
- Business Need: To-date Accretions 5m
- Business Solution Pt. 1: To-date Accretions 6m
- Business Solution Pt. 2: To-date Accretions 5m
- Business Need: Compound Date-based Calculations 3m
- Business Solution: Compound Date-based Calculations 5m
- Business Need: Moving Averages to Smooth Values Over Time 2m
- Business Solution: Moving Averages to Smooth Values Over Time 4m
- Business Need: Last Dates Concepts 2m
- Business Solution Pt. 1: Last Dates Concepts 5m
- Business Solution Pt. 2: Last Dates Concepts 6m
- Business Solution Pt. 3: Last Dates Concepts 4m
- Business Need: Deliver the Current Date 2m
- Business Solution Pt. 1: Deliver the Current Date 6m
- Business Solution Pt. 2: Deliver the Current Date 4m
- Conclusion and Summary 2m
- Introduction 2m
- Business Need: Retrieve Basic Dimension, Level, and Hierarchy Information 1m
- Business Solution Pt. 1: Retrieve Basic Dimension, Level, and Hierarchy Information 5m
- Business Solution Pt. 2: Retrieve Basic Dimension, Level, and Hierarchy Information 4m
- Business Need: Horizontal Navigation 2m
- Business Solution Pt. 1: Horizontal Navigation 6m
- Business Solution Pt. 2: Horizontal Navigation 4m
- Business Need: Vertical Navigation - Nuclear Family 3m
- Business Solution Pt. 1: Vertical Navigation - Nuclear Family 2m
- Business Solution Pt. 2: Vertical Navigation - Nuclear Family 4m
- Business Need: Vertical Navigation - Extended Family 2m
- Business Solution Pt. 1: Vertical Navigation - Extended Family 3m
- Business Solution Pt. 2: Vertical Navigation - Extended Family 6m
- Business Solution Pt. 3: Vertical Navigation - Extended Family 4m
- Business Solution Pt. 4: Vertical Navigation - Extended Family 5m
- Business Solution Pt. 5: Vertical Navigation - Extended Family 3m
- Conclusion and Summary 2m
- Introduction 3m
- Business Need: Perform Basic Allocation Using MDX 3m
- Business Solution Pt. 1: Perform Weighted Allocations 4m
- Business Solution Pt. 2: Perform Weighted Allocations 5m
- Business Solution Pt. 3: Perform Unweighted Allocations 5m
- Business Need: Perform ABC Classification 5m
- Business Solution Pt. 1: Perform ABC Classification 4m
- Business Solution Pt. 2: Perform ABC Classification 5m
- Business Solution Pt. 3: Perform ABC Validation 4m
- Business Solution Pt. 4: Perform ABC Parameterization 5m
- Conclusion and Summary 2m
- Introduction 1m
- Business Need: MDX Analysis in Action 4m
- Business Solution Pt. 1: MDX Analysis in Action 4m
- Business Solution Pt. 2: MDX Analysis in Action 5m
- Business Solution Pt. 3: MDX Analysis in Action 3m
- Business Solution Pt. 4: MDX Analysis in Action 5m
- Business Solution Pt. 5: MDX Analysis in Action 3m
- Business Solution Pt. 6: MDX Analysis in Action 5m
- Business Solution Pt. 7: MDX Analysis in Action 2m
- Business Need Pt. 1: Key Performance Indicators 5m
- Business Need Pt. 2: Key Performance Indicators 3m
- Business Solution Pt. 1: Key Performance Indicators 5m
- Business Solution Pt. 2: Key Performance Indicators 6m
- Business Solution Pt. 3: Key Performance Indicators 2m
- Business Solution Pt. 1: Use MDX to Query KPI 4m
- Business Solution Pt. 2: Use MDX to Query KPI 2m
- Conclusion and Summary 2m