The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768.

This course incorporates material from the Official Microsoft Learning Product 20768: Developing SQL Data Models

GK On-Demand is also available with digital Microsoft Official Courseware (dMOC). Click here to purchase.

View Entire Schedule

Components, architecture, and nature of a BI solution
Create a multidimensional database with analysis services
Implement dimensions in a cube
Implement measures and measure groups in a cube
Use MDX syntax
Customize a cube
Implement a tabular database
Use DAX to query a tabular model
Use data mining for predictive analysis

Viewing outline for:

Classroom Live Outline

1. Introduction to Business Intelligence and Data Modeling

Introduction to Business Intelligence
Microsoft Business Intelligence Platform

2. Create Multidimensional Databases

Introduction to Multidimensional Analysis
Create Data Sources and Data Source Views
Cubes
Overview of Cube Security
Configure SSAS
Monitoring SSAS

3. Working Cubes and Dimensions

Configure Dimensions
Define Attribute Hierarchies
Implementing Sorting and Grouping Attributes
Slowly Changing Dimensions

4. Working with Measures and Measure Groups

Working with Measures
Working with Measure Groups

5. Introduction to Multidimensional Expressions (MDX)

MDX Fundamentals
Add Calculations to a Cube
Use MDX to Query a Cube

6. Customize Cube Functionality

Implement Key Performance Indicators
Implement Actions
ImplementPerspectives
Implement Translations

7. Implement a Tabular Data Model by Using Analysis Services

Introduction to Tabular Data Models
Create a Tabular Data Model
Use an Analysis Services Tabular Model in an Enterprise BI Solution

8. Introduction to Data Analysis Expression (DAX)

DAX Fundamentals
Using Dax to create Calculated Columns and Measures in a Tabular Data Model

9. Perform Predictive Analysis with Data Mining

Overview of Data Mining
Create a Custom Data Mining Solution
Validate a Data Mining Model
Connecting to and Consume a Data Mining Model
Using the Data Mining add-in for Excel

1. Introduction to Business Intelligence and Data Modeling

Introduction to Business Intelligence
Microsoft Business Intelligence Platform

2. Create Multidimensional Databases

Introduction to Multidimensional Analysis
Create Data Sources and Data Source Views
Cubes
Overview of Cube Security
Configure SSAS
Monitoring SSAS

3. Working Cubes and Dimensions

Configure Dimensions
Define Attribute Hierarchies
Implementing Sorting and Grouping Attributes
Slowly Changing Dimensions

4. Working with Measures and Measure Groups

Working with Measures
Working with Measure Groups

5. Introduction to Multidimensional Expressions (MDX)

MDX Fundamentals
Add Calculations to a Cube
Use MDX to Query a Cube

6. Customize Cube Functionality

Implement Key Performance Indicators
Implement Actions
ImplementPerspectives
Implement Translations

7. Implement a Tabular Data Model by Using Analysis Services

Introduction to Tabular Data Models
Create a Tabular Data Model
Use an Analysis Services Tabular Model in an Enterprise BI Solution

8. Introduction to Data Analysis Expression (DAX)

DAX Fundamentals
Using Dax to create Calculated Columns and Measures in a Tabular Data Model

9. Perform Predictive Analysis with Data Mining

Overview of Data Mining
Create a Custom Data Mining Solution
Validate a Data Mining Model
Connecting to and Consume a Data Mining Model
Using the Data Mining add-in for Excel

1. Introduction to Business Intelligence and Data Modeling

Introduction to Business Intelligence
Microsoft Business Intelligence Platform

2. Create Multidimensional Databases

Introduction to Multidimensional Analysis
Create Data Sources and Data Source Views
Cubes
Overview of Cube Security
Configure SSAS
Monitoring SSAS

3. Working Cubes and Dimensions

Configure Dimensions
Define Attribute Hierarchies
Implementing Sorting and Grouping Attributes
Slowly Changing Dimensions

4. Working with Measures and Measure Groups

Working with Measures
Working with Measure Groups

5. Introduction to Multidimensional Expressions (MDX)

MDX Fundamentals
Add Calculations to a Cube
Use MDX to Query a Cube

6. Customize Cube Functionality

Implement Key Performance Indicators
Implement Actions
ImplementPerspectives
Implement Translations

7. Implement a Tabular Data Model by Using Analysis Services

Introduction to Tabular Data Models
Create a Tabular Data Model
Use an Analysis Services Tabular Model in an Enterprise BI Solution

8. Introduction to Data Analysis Expression (DAX)

DAX Fundamentals
Using Dax to create Calculated Columns and Measures in a Tabular Data Model

9. Perform Predictive Analysis with Data Mining

Overview of Data Mining
Create a Custom Data Mining Solution
Validate a Data Mining Model
Connecting to and Consume a Data Mining Model
Using the Data Mining add-in for Excel

Viewing labs for:

Classroom Live Labs

Lab 1: Exploring a BI Solution
Lab 2: Create a Multidimensional Database
Lab 3: Work with Cubes and Dimensions
Lab 4: Configure Measures and Groups
Lab 5: Use MDX
Lab 6: Customize a Cube
Lab 7: Working with an Analysis Services Tabular Data Model
Lab 8: Create Calculated Columns and Measures using DAX
Lab 9: Using Data Mining

Basic knowledge of the Microsoft Windows operating system and its core functionality.
Experience of querying data usingTransact-SQL.

Earning an MCSA: SQL 2016 Business Intelligence Development certification validates your extract, transform, and load (ETL) and data warehouse skills, along with those for implementing BI solutions using multidimensional and tabular data models and online analytical processing (OLAP) cubes. This certification will qualify you for a position as a BI developer.

MCSA: SQL 2016 Business Intelligence Development

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

SATV Redemption

Redeeming your Microsoft Software Assurance Training Vouchers:

3 Day SATV for a Classroom Live session
3 Day SATV for a Virtual Classroom Live session

Managing SQL Business Intelligence Operations (M10988)

Cart () Loading...

Subtotal

Topics

Brands

Topics

Brands

Developing SQL Data Models (M20768)

Course Overview

Schedule

What You'll Learn

Outline

Classroom Live Outline

Labs

Classroom Live Labs

Prerequisites

Who Should Attend

Vendor Credits

SATV Redemption

Follow-On Courses

Training Exclusives

Course Delivery