SSAS Tabular Workshop

Milano, IT

Sorry, this course is closed.

Leave your email if you want to be notified when a new edition of SSAS Tabular Workshop will be available in Italy.

 By pressing the Notify button you are agree to our Privacy Policy.

The course is aimed to professionals who want to exploit the full power of the Tabular models in Analysis Services 2016/2017.

This two-day workshop covers the Tabular modeling in Microsoft SQL Server Analysis Services 2016/2017 and includes a large number of demos that each student can try on his own notebook to make practice with Tabular modeling and administration. Most of the topics are valid also for versions 2012/2014.

No knowledge of previous versions of Analysis Services (Multidimensional) is required, because Tabular is based on different concepts and on the DAX language (instead of MDX). You will also learn the differences between the two technologies (Tabular and Multidimensional) and when to choose one over the other.

After this course, you can attend the Mastering DAX Workshop in order to learn how to write complex measures and queries using the DAX Language, which is just shortly introduced in the SSAS Tabular Workshop course. This course has been renewed in 2016 and covers all the new features introduced by Analysis Services 2016 and 2017.

SSAS Tabular Workshop è un corso intensivo di 3 giorni per imparare a creare modelli con Analysis Services 2012 Tabular e a usare DAX per definire misure e interrogare il database.

Partecipando al corso imparerai a usare Visual Studio per creare modelli Tabular, a gestire correttamente un workspace server, a impostare correttamente il caricamento dei dati dalle fonti esterne, a pubblicare i modelli sfruttando la security, a ottimizzare le attività di interrogazione e processing.

I nostri docenti ti assisteranno durante gli Hands-on-Lab, laboratori pratici nei quali potrai creare modelli e scrivere espressioni DAX per risolvere tipici scenari di business.

Scheda del corso:

  • Architettura BISM (Tabular vs. Multidimensional)
  • Installazione Analysis Services
  • Panoramica su funzionalità di modellazione in Tabular
  • Caricamento dati
  • Linguaggio DAX
  • Evaluation Context (Filter Context, Row Context)
  • Query in Tabular
  • Vertipaq Engine: funzionamento e compressione dati
  • Gerarchie in Tabular
  • Tabular vs. PowerPivot
  • Role-based row-level Security
  • Interfacce di programazione per Tabular
  • Deployment e uso delle partizioni
  • Modalità InMemory e DirectQuery
  • Ottimizzazione e Monitoring

Questo corso sarà completamente in ITALIANO.


09:00 – 17:00
(nei primi due giorni sarà possibile rimanere fino alle 18:00 per eventuali domande o completare il lab)


SSAS Tabular Outline (PDF)


No knowledge of previous versions of Analysis Services (Multidimensional) is required.


Microsoft Italia Innovation Campus

Via Lombardia, 2/A-1 - Peschiera Borromeo
Milano, IT
View on Google Maps

Looking for another city?

We bring our courses to you all over the world. Here are the current scheduled classroom events.
Please note that each course is taught exclusively by SQLBI trainers (no external trainers are involved).
Early Bird
 Seattle, WA, US Feb 6-8
 Atlanta, GA, US Feb 11-13
 Amsterdam, NL Feb 19-21
 London, UK Mar 13-15
 Vancouver, BC, CA Mar 13-15
 Chicago, IL, US Mar 25-27
 Amsterdam, NL Apr 9-11
 Amsterdam, NL May 8-10
 Cincinnati, OH, US May 21-23
 Helsinki, FI May 21-23
 Aarhus, DK Jun 18-20
 Brisbane, QLD, AU Jul 17-19
 Melbourne, VIC, AU Jul 23-25
 Sydney, NSW, AU Jul 30-Aug 1
 Melbourne, VIC, AU Aug 6-8
 Perth, WA, AU Aug 14-16
Other locations On-Site On-Site On-Site On-Site On-Site