Visão Geral

Curso SQL Server MDX Overview, ensina aos participantes as principais técnicas de uso do MDX com Analysis Services para fornecer soluções de business intelligence de alto desempenho.

Objetivo

Após realizar este Curso SQL Server MDX Overview, você será capaz de:

• Construir e executar consultas MDX
• Trabalhar com tuplas e conjuntos
• Crie membros calculados
• Trabalhe com várias funções em uma única consulta
• Crie conjuntos complexos para recuperar os dados exatos que os usuários precisam
• Execute funções de agregação e navegue em hierarquias de dados
• Monte métricas de negócios baseadas em tempo

Pre-Requisitos

Requisitos de software

• Pelo menos 8 GB de RAM (16 GB de RAM recomendados para SQL Server 2016 ou posterior)
• Uma instalação completa da versão do SQL Server (ferramentas de servidor e cliente) que você está usando para a classe, incluindo o Analysis Services
• A versão do Windows de 64 bits necessária varia de acordo com a versão do SQL Server

Materiais

Conteúdo Programatico

Welcome to MDX

1. The Business Intelligence Landscape
2. The Dimensional Model
3. Implementing the Dimensional Model
4. The MDX Language

Using the MDX Query Editor

1. SQL Server Management Studio
2. The MDX Query Editor
3. Building a Simple MDX Query
4. Exploring the Step-by-Step Cube
5. Building a More Complex Query

Understanding Tuples

1. N-dimensional Space
2. Cube Space
3. Accessing Data with Tuples
4. Understanding Cells
5. Working with Partial Tuples
6. Building Tuples with User-Hierarchies

Working with Sets

1. Set Basics
2. Understanding the SELECT Statement
3. Building Sets with Functions
4. Limiting Sets

Working with Expressions

1. Expression Basics
2. Calculated Members
3. Building Dynamic Expressions
4. Resolving Contextual Conflicts
5. Building Complex Expressions

Building Complex Sets

1. Assembling Ordered Sets
2. Retrieving the First or Last Tuples of a Set
3. Filtering Sets
4. Combining Sets
5. Performing Advanced Set Construction

Performing Aggregation

1. Performing Summation
2. Calculating Averages
3. Identifying Minimum and Maximum Values
4. Counting Tuples in Sets

Navigating Hierarchies

1. Accessing Immediate Relatives
2. Accessing Extended Relatives
3. Navigating within a Level

Working with Time

1. Understanding the Time Dimension
2. Calculating an Accumulating Total
3. Performing Period-over-Period Analysis
4. Combining Time-Based Metrics

Enhancing the Cube (Optional)

1. Understanding the MDX Script
2. Constructing Calculated Members
3. Assembling Named Sets

Building Reports (Optional)

1. Getting Started
2. Connecting to Analysis Services
3. Designing the Dataset
4. Adding Parameters to the Dataset
5. Presenting the Data in the Report