SSAS Tabular Workshop


Milano, IT

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. The course is aimed to professionals who want to exploit the full power of the Tabular models in Analysis Services. 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:

Questo corso sarà completamente in ITALIANO.

Orario:

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


Course outline (PDF)

Each attendee must bring his/her laptop for exercises. We will provide the configuration required, or in alternative it will be possible to connect to a virtual machine on the cloud using Remote Deskop and the Internet connection available in the training room.



Course location


Microsoft Italia Innovation Campus
Via Lombardia, 2/A-1 - Peschiera Borromeo
Milano, IT
Get directions


Course Book

Each participant will receive a copy of:
Tabular Modeling in SQL Server Analysis Services (2nd Edition)

Marco Russo & Alberto Ferrari
Microsoft Press