Microsoft/SQL Server 2016 Analysis Services Tabular Model WorkshopPLUS

Download Course Contents

SQL Server 2016 Analysis Services Tabular Model WorkshopPLUS Course Overview

On the off chance that you need instinctive, intuitive and elite access to your information—and particularly on the off chance that you have huge volumes of information—at that point this course is for you.

Regardless of whether you're new to Analysis Services or are knowledgeable about prior forms, this course will show all of you the data you have to build up an unthinkable information model. You will figure out how to import tables of information from various sources and relate them to shape the establishment of your model. You will at that point figure out how to improve your model with ease of use highlights, for example, chains of importance.

Next, you will figure out how to improve your model with business rationale. You will figure out how to make determined sections, tables and measures utilizing DAX, the language of unthinkable models.

Extra subjects incorporate how to deal with an unthinkable database - including table stockpiling, preparing, authorizations and organization - and how to send your forbidden model to the cloud with Azure Analysis Services.

At last, this course will show you how to think about the two sorts of Analysis Services models: forbidden and multidimensional. This will assist you with determining the suitable information model for your undertaking.

Before the finish of the course, you will have planned, created and conveyed a forbidden model, and you will be prepared to convey superior business client encounters.

The course remembers far reaching hands-for practices that empower you to straightforwardly apply the exercises with test information.

Syllabus :

Module 1: Introducing Analysis Services

This module presents forbidden models and SQL Server 2016 Analysis Services. It covers creating models, bringing information into tables, and characterizing connections.

Module 2: Designing Tabular Models

This module covers improvements to forbidden models, including ease of use and business rationale.

Module 3: Managing Tabular Models

This module presents the arrangement lifecycle for unthinkable models, and the utilization of DirectQuery mode.

Module 4: Making Architectural Decisions

This module covers Azure Analysis Services, and looks at unthinkable models to multidimensional models.

Last test of the year

The fourth seven day stretch of the course is given over the last test of the year, which represents 70% of your evaluation and will be joined with the schoolwork assignments in every module to decide your general score. You should accomplish a general score of 70% or higher to pass this course and gain an authentication.


This is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.
Live Online Training (Duration : 24 Hours) Fee On Request
Group Training Date On Request
1-on-1 Training
4 Hours
8 Hours
Week Days

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Ultra-Fast Track

If you can't spare 24 hours. We can offer you an Ultra-Fast Track for 12 hours

Course Prerequisites
  • Basic Computer Knowledge.

You will learn how to :

  • Choosing the correct model engineering
  • Importing information to make tables and characterizing connections
  • Enhancing model structures with convenience highlights
  • Enhancing model structures with business rationale
  • Managing unthinkable databases
  • Designing for DirectQuery mode
  • Deploying to Azure Analysis Services
  • Comparing unthinkable and multidimensional models


Request More Information

Add Name and Email Address of participant (If different from you)


Yes, fee excludes local taxes.
The Fee includes:
  • Courseware
Yes, Koenig Solutions is a Microsoft Learning Partner