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.
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.
Author Name: Bill Pearson
Author Description:
Bill has been working with computers since before becoming a “big eight” CPA, after which he carried his growing information systems knowledge into management accounting, internal auditing, and various capacities of controllership. Bill created Island Technologies Inc. in 1997, and has developed a large and diverse customer base. Bill’s background as a CPA, Internal Auditor and Management Accountant enable him to provide value to clients as a liaison between Accounting / Finance and Information … more
Table of Contents
- Course Overview
1min - Introduction and Foreword
6mins - Basic Solutions
39mins - Set-focused Solutions
46mins - Time and Date Solutions
62mins - Navigation and Hierarchical Solutions
58mins - Analytics and KPI Solutions
44mins - Beyond the Basic Cube Structure
61mins
User Reviews
Be the first to review “Business Solutions with MDX”
Related Products
Query data in a KQL database in Microsoft Fabric
This tutorial provides a brief introduction to KQL (Kusto Query Language) queries using Querysets and the major differences between KQL and T-SQL when using Querysets.
Describe the business value of the Microsoft Power Platform
Learn about the components of Microsoft Power Platform, the business value for customers, and how the technology works with other Microsoft products.
Predictive Analytics for Business
Learn how to leverage predictive analytics to inform business decisions and strategies.
Describe building automation with Microsoft Power Automate
Microsoft Power Automate builds process automation. Power Automate allows anyone with knowledge of the business process to create repeatable flows that, when triggered, and perform the process for them.
Configure Power BI report filters
Report filtering is a complex topic because many techniques are available for filtering a Microsoft Power BI report. However, with complexity comes control, allowing you to design reports that meet requirements and expectations. Some filtering techniques apply at design time, while others are relevant at report consumption time (in reading view). What matters is that your report design allows report consumers to intuitively narrow down to the data points that interest them.
Use visuals in Power BI
Create and customize visuals to present data in compelling and insightful ways.
There are no reviews yet.