Advanced SQL Server Analysis Services (SSAS)

Course Number: ISI-1410

• Vendor: Microsoft
• Category: Microsoft Technical Courses
• List Price

Description

- 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

$1995.00