DSI Developed Course:

SQL Server Analysis Services
Multidimensional Models

Audience

Duration

Prerequisite

Requirement

This course is intended for Information Technology Development Professionals

1-3 Days

Development Experience

Students require a computer with access to the internet

Course Overview

This course introduces participants to the basics of SQL Server Analysis Services Multidimensional models.  Participants learn how to create and deploy multidimensional models with an emphasis on MDX.

The course is delivered by an instructor making use of PowerPoint slides and interactive demonstrations.  The learning is reinforced by providing hands-on workshops where the participants have the opportunity to practice the techniques being taught.  Access to a computer with connectivity to the internet is mandatory to access the training portal.

 

Topics covered include:

• Introduction to Multidimensional Analysis

• Creating Data Sources and Views

• Creating a cube

• Cube Security

• Configuring Dimensions

• Defining Attribute Hierarchies

• Sorting and Grouping Attributes

• Working with measures

• Working with Measure Groups

• MDX Fundamentals

• Adding Calculations to a Cube

• Using MDX to Query a cube

• Working with Key Performance Indicators

• Working with Actions

• Working with Perspectives

• Working with Translations

• Options for Creating an Analysis Services Tabular Data Model Project

• Perspectives

• Partitions

• DirectQuery Mode

• Security

• Deployment Options

• DAX

• Time Intelligence

follow us

416 538-6849 ext.1

Copyright © 2017 Dimensional Strategies Inc. All rights reserved.