Advanced SQL Server Analysis Services (SSAS)

The following is a list of available Advanced SQL Server Analysis Services (SSAS) classes at ISInc. If you do not see the course you are interested in, please contact us. We can setup dedicated, online and onsite classes too! Minimum students required: 4, Maximum students: 15

Course Number: ISI-1410


- SQL Server 2012 Analysis Services: understanding and comparing Tabular and Multidimensional models, and when to use which type of model
- Introducing the SQL Server Data Tools development environment
- SSAS Tabular basic concepts: tables, columns, relationships and measures
- X Velocity Architecture (in memory data function)
- Loading data into SSAS Tabular
- Basic DAX: creating simple calculated columns and measures
- Handling regular and parent/child hierarchies
- Intermediate DAX: aggregating data with SUM(), SUMX() and other functions
- Advanced DAX: evaluation contexts and an introduction to the CALCULATE() function
- More Advanced DAX: using the CALCULATE() function in measures
- DAX Queries
- Reading DAX Query Plan
- Configuring Tabular models for use with Power View
- Implementing security on a Tabular model, including dynamic security
- Writing time intelligence calculations in DAX
- Processing and partitioning
- Real-time BI with DirectQuery
- Debug/Analyst Performance Issues

List Price