Microsoft/Developing SQL 2016 Data Models (SSAS)

Overview Schedule & Fees Course Benefits Student Feedback FAQ Course Modules

Developing SQL 2016 Data Models (SSAS) Certification Training Course Overview

Developing SQL Data Models course imparts core skills to implement multidimensional databases using SSAS (SQL Server Analysis Services), and create tabular semantic data models for analysis. This SSAS training is meant for database professionals who create enterprise BI solutions in order to fulfil the role of a BI Developer. This SQL Data Model Development course is also suitable for power users, information workers and data analysts.

Test your current knowledge Qubits42

Developing SQL 2016 Data Models (SSAS) (24 Hours) Download Course Contents

Live Virtual Classroom 1300

Group Training 01 - 03 Nov GTR 09:00 AM - 05:00 PM CST (8 Hours/Day) 13 - 15 Dec GTR 09:00 AM - 05:00 PM CST (8 Hours/Day)	1-on-1 Training (GTR) 4 Hours 8 Hours Week Days Weekend Start Time : At any time 12 AM 12 PM Training Schedule: GTR=Guaranteed to Run

Special Solutions for Corporate Clients! Click here

Hire Our Trainers! Click here

Recording Available only $99

Customers who bought this course also bought

is recommended before.

is recommended after.

SSRS: Analyzing Data with SQL Server Reporting Service (10990) Training Course

AZ-303 Microsoft Azure Architect Technologies Certification Training Course

Microsoft Power BI Certification Training Course : Exam DA 100

AZ-204: Developing Solutions for Microsoft Azure Certification Training

Developing SQL Databases Training Course ( Exam 70-762)

AZ-104: Microsoft Azure Administrator Training Course

PL-900T00-A: Microsoft Power Platform Fundamentals Training Course

10% discount on 2nd course:

Course Modules

Module 1: Introduction to Business Intelligence and Data Modeling

Introduction to Business Intelligence
The Microsoft business intelligence platform
Lab : Exploring a Data Warehouse

Module 2: Creating Multidimensional Databases

Introduction to multidimensional analysis
Course details Creating data sources and data source views
Creating a cube
Overview of cube security
Lab : Creating a multidimensional database

Module 3: Working with Cubes and Dimensions

Configuring dimensions
Define attribute hierarchies
Sorting and grouping attributes
Lab : Working with Cubes and Dimensions

Module 4: Working with Measures and Measure Groups

Working with measures
Working with measure groups
Lab : Configuring Measures and Measure Groups

Module 5: Introduction to MDX

MDX fundamentals
Adding calculations to a cube
Using MDX to query a cube
Lab : Using MDX

Module 6: Customizing Cube Functionality

Implementing key performance indicators
Implementing actions
Implementing perspectives
Implementing translations
Lab : Customizing a Cube

Module 7: Implementing a Tabular Data Model by Using Analysis Services

Introduction to tabular data models
Creating a tabular data model
Using an analysis services tabular model in an enterprise BI solution
Lab : Working with an Analysis services tabular data model

Module 8: Introduction to Data Analysis Expression ﴾DAX﴿

DAX fundamentals
Using DAX to create calculated columns and measures in a tabular data model
Lab : Creating Calculated Columns and Measures by using DAX

Module 9: Performing Predictive Analysis with Data Mining

Overview of data mining
Using the data mining add‐in for Excel
Creating a custom data mining solution
Validating a data mining model
Connecting to and consuming a data mining model
Lab : Perform Predictive Analysis with Data Mining

Download Course Contents

Request More Information

Request a call back?

Course Prerequisites

Working knowledge of Transact-SQL.
Working knowledge of relational databases.

Upon Completion of this Course, you will accomplish following:-

Understand the architecture, components and features of BI solution
Use analytics of SSAS to create a multidimensional database
Deploy dimensions into a cube
Deploy measures and measure groups into a cube
Implement MDX syntax
Perform customizations on a cube
Create a tabular database
Query tables using DAX
Conduct predictive analysis using data mining

Give an edge to your career with Microsoft certification training courses. Students can join the classes for 20768 :Developing SQL Data Models ( SSAS) at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.