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)
  • CALCULATE
  • 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.

Orario:

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

Topics

SSAS Tabular Outline (PDF)

Prerequisites

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

Location

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
Discount
Bundle
Discount
Video
Discount
 Perth, AU Aug 20-22
Perth
 Toronto, ON, CA Sep 18-20
Toronto
 San Francisco, CA, US Oct 1-3
San Francisco
 Amsterdam, NL Oct 10-12
Amsterdam
 London, UK Oct 16-18
London
 Copenhagen, DK Oct 23-25
Copenhagen
 Boston, MA, US Oct 31-Nov 2
Boston
 Houston, TX, US Nov 13-15
Houston
 London, UK Nov 20-22
London
 New York, NY, US Nov 28-30
New York
 Miami, FL, US Dec 3-5
Miami
 Zurich, CH Dec 11-13
Zurich
Other locations On-Site On-Site On-Site On-Site On-Site