Audience profile

Data analysts and power information workers

Database professionals who fulfill a BI developer role and create enterprise BI solutions and whose primary responsibilities include:

Implementing multidimensional databases by using SSAS

Creating tabular semantic data models for analysis by using SSAS.

Prerequisites

• M20761 Querying Data with Transact SQL
• 20767 Implementing a SQL Data Warehouse

Course outline

INTRODUCTION TO BUSINESS INTELLIGENCE AND DATA MODELING

• Define the Basics of Business Intelligence
• Get to Know the Microsoft Business Intelligence Platform

Lab: Explore a BI Solution

CREATING MULTIDIMENSIONAL DATABASES

• Apply Multidimensional Analysis
• Create Data Sources and Data Source Views
• Deploy a Cube
• Learn About Cube Security

Lab: Create a Multidimensional Database

WORKING WITH CUBES AND DIMENSIONS

• Configure Dimensions
• Define Attribute Hierarchies
• Sort and Group Attributes

Lab: Work with Cubes and Dimensions

WORKING WITH MEASURES AND MEASURE GROUPS

• Work with Measures
• Practice Using Measure Groups

Lab: Configure Measures and Groups

INTRODUCTION TO MDX

• Navigate the Fundamentals of MDX
• Add Calculations to a Cube
• Query a Cube Using MDX

Lab: Work with MDX

CUSTOMIZING CUBE FUNCTIONALITY

• Implement Key Performance Indicators
• Apply Actions, Perspectives and Translations

Lab: Customize a Cube

IMPLEMENTING A TABULAR DATA MODEL BY USING ANALYSIS SERVICES

• Define and Create Tabular Data Models
• Work with an Analysis Services Tabular Model in an Enterprise BI Solution

Lab: Work with an Analysis Services Tabular Data Model

INTRODUCTION TO DATA ANALYSIS EXPRESSION (DAX)

• Master the Basics of DAX
• Use DAX to Create Calculated Columns and Measures in a Tabular Data Model

Lab: Create Calculated Columns and Measures using DAX

PERFORMING PREDICTIVE ANALYSIS WITH DATA MINING

• Gain an Introduction to Data Mining
• Navigate the Data Mining Add-In for Excel
• Create a Custom Data Mining Solution
• Validate a Data Mining Model
• Connect to and Consume a Data Mining Solution

Lab: Practice Data Mining