SSAS Tabular Workshop

The 3-day workshop covers the Tabular modeling in Microsoft SQL Server Analysis Services 2012 and includes exercises to make practice with DAX and Tabular modeling.

Prerequisitese

The course is aimed to professionals who want to exploit the full power of the new Tabular models in Analysis Services. No knowledge of previous versions of Analysis Services and Unified Dimensional Model (UDM) is required, because Tabular is based on different concepts and on the new DAX language.
You will also learn the differences between the two technologies (Tabular and Multidimensional) and when to choose one over the other.

Training Material Delivered to each attendee:

  • One copy of the book: Microsoft SQL Server Analysis Services 2012: The BISM Tabular Model
  • Course slides in PDF format
  • Demo files used in the course

Agenda

  • BISM Architecture
  • Tabular Modeling
  • Guided Tour on Tabular
  • Loading Data
  • DAX Basics
  • Evaluation Contexts
  • Querying Tabular
  • VertiPaq Engine
  • Tabular Hierarchies
  • Tabular Presentation Layer
  • Tabular vs. PowerPivot
  • Handling Security
  • Interfacing with Tabular
  • Tabular Deployment
  • Tabular vs. Multidimensional
  • Optimizations and Monitoring

Trainer

Alberto Ferrari or Marco Russo

Copyright 2017 Orange Man · RSS Feed · Log ind · Google+

Organic Themes