SSAS Classroom Training

SSAS Classroom Training (with MDX & DAX)

SSAS Classroom Training at SQL School is carefully designed to involve Cube Design, OLAP Data Modelling, Cube Development, MDX Programing, Mining ith Forecasts and Tuning operations. Classes are completely practical and interactive with one real-time Case Study.

Prerequisites: Participant should have knowledge on SQL Server T-SQL Queries & Tuning to join this Real-time Practical SSAS Training Course.


Schedules for MSBI - SSAS Classroom Training

Schedules Timings Free Demo
Schedule 1: 8 AM to 9:30 AM Register Today
Schedule 2: 8 PM to 9:30 PM Register Today

This MSBI SSAS Classroom Training includes ONE Real-time Project.
Trainer Profile, Duration, Pricing
Trainer: Mr Sai Phanindra T (11+ Yrs Exp, MS FTE)
Duration: 2.5 Weeks (Mon - Fri/Sat)

Total Course Fee: INR 5500/-
Training Location & Lab:
SR Nagar - Ameerpet, Hyderabad (India). Map
Course includes Real-time Project, Placement, Support.

If none of the above LIVE SSAS Classroom Training schedules work for you? please opt for On-demand, 24x7 SSAS Training Videos

Module I: SSAS Development
Module II: Advanced Cube Design
Module III: Deployment & MDX/DAX

SSAS Installation and Configuration

  • Introduction to SSAS 2014 & 2016
  • Multidimensional Mode Configuration
  • Tabular Mode Configuration, In-Memory
  • Testing SSAS Workspace Servers in SSDT
  • Understanding Realworld Databases
  • Need for OLAP Databases and Mining
  • Need for Cubes and Faster Reports
  • Identifying OLAP / Analysis Entities
  • Kimball and Inmon Methds - BI Design
  • SSAS Usage and Target Access Methods
  • Column Storage, Row Storage Options

Basic SSAS Entities & Usage

  • Data Source and Data Source Views
  • Computed Columns and Attributes
  • Building Relationships For Cubes
  • Identifying Facts and Dimensions
  • Identifying Measurable Aggregates
  • Identifying Attributes and Hierarchies
  • Deciding Cube (MOLAP) Schema
  • Named Queries and Relations in DSV
  • Database Dimensions from DSV Entities
  • Cube Dimensions from DSV Relations
  • Cube & Database Dimensions - Issues

Dimension Wizard and Attributes

  • Creating Multi-Dimensional Entities
  • Attributes and Key Member Names
  • Cube Dimension Templates and Options
  • Applying Time Based Dimensions
  • Dimension Hierarchies and Limitations
  • Cube Attribute Relations and Uses
  • Composite Attribute Keys in OLAP Cubes
  • Building Attribute Levels and Hierarchies
  • Duplicate Attribute Key Errors
  • Common Deployment & Security Errors
  • Deployment Warnings in Real-World

Cube Wizard and Relations

  • Cube Design - Regular Templates
  • Cube Measures and Dimension Keys
  • Additive and Semi Additive Measures
  • Cube Customization Options and MDX
  • Calculations and MDX Members
  • MDX Scripts for Member Calculations
  • Cube Calculation Sets and MDX Scripts
  • BI Enhancements and MDX in MOLAP
  • Time Based Calculations with MDX

Dimension Types & KPI

  • Role Playing Dimensions and MDX
  • Fact and Factless Dimensions
  • Referenced Dimensions & Usage
  • Conformed Dimensions & Usage
  • Degenerate Dimensions & Usage
  • Junk & Hierarchical Dimensions
  • Dimension Usage and Granularity
  • Building Fact Less Dimensions
  • Static and Dynamic KPIs with MDX
  • Parent and Child KPIs with MDX
  • Defining KPIs and Goals using MDX
  • Perspectives using MDX Expressions
  • SSAS Actions with MDX and XMLA

SSAS Partitions and Aggregations

  • Local and Remote Cube Partitions
  • Storage Modes - MOLAP, ROLAP, HOLAP
  • Aggregations and Proactive Caching
  • Tuning Cube Partition Processing
  • Row Estimations and Aggregations
  • Assigning Aggregations, Scripts
  • Usage Based Optimization (UBO)

MDX Functions, FILTERS and JOINS

  • MDX Functions & Conditional JOINS
  • Complex MDX Queries & FILTERS
  • CROSSAPPLY and MDX Query Filters
  • Cube and Dimension Writebacks
  • MDX with Roleplaying Dimensions
  • MDX Transactions & Limitations

Data Mining and Forecast

  • Need for Data Mining Structures
  • Data Mining Algorithms and Rules
  • DMX Queries and Forecast Reports
  • Data Mining Scope and DMX Ranks

Tabular Mode Cube Design

  • Entity Identification Procedures
  • Workspace Configuration Settings
  • In-Memory Processing Options
  • Advance Cube Design Scenarios
  • Aggregated Measures with KPIs
  • Partitioned Dimensions & Usage
  • Conditional MDX Scripts & Options
  • Hierarchical MDX in Tabular Mode
  • MDX Filters and Joins in Tabular Mode

Deployment (Tabular, Multidimensional)

  • Deployment Options and Pre-requisites
  • Cube Deployment Process and Tools
  • SSAS Deployment Wizard Tool & Errors
  • Storage Locations - Cube & Partitions
  • Creating OLAP Databases, Scripts
  • Processing Options and Schedules
  • Managing Deployment Process (OLAP)
  • SSAS Database and Cube/Mining Audits
  • MDX Query Log Tables in DB Engine
  • Flight Recorder Options and Sampling
  • Managing SSAS Log Providers

Usage Based Optimization (UBO)

  • Need for Optimization and Audits
  • Designing Aggregations using UBO
  • Aggregations For Optimization Levels
  • Audit Query Filters and Reuse Options
  • OLAP Restore Options and XMLA
  • Sub Queries and Nested Sub Queries
  • FILTER Expressions and Tuning

Using OLAP Structures & Schedules

  • Cube Analysis with Excel Tables
  • Excel Pivots and Refresh Options
  • Configuring ODC (Office) Connections
  • Prediction Functions and Analysis
  • DMX and MDX Queries Interfaces
  • MDX and OLAP Operations with ETL
  • Scheduling SSAS Operations (XMLA)

OLAP Database Management

  • OLAP & Tabular Database Backups
  • OLAP Compressions and Encryptions
  • Backups, Restores and Passwords
  • Scheduling Backups and Jobs
  • OLAP DB Synchronizations and XMLA
  • Partitions - Splits and Merge Options
  • Managing Partitions & Aggregations

Managing Security with MDX

  • SSAS Security Roles and Scope
  • Object Level Access and Dynamic MDX
  • Item Security and DAX Expressions
  • Dynamic Cube Security with MDX
  • OLAP Security Audits and Query Logs
  • OLAP Management with ETL/DWH
  • Comparing SSAS 2012 & SSAS 2014


SSAS (with MDX, DAX) Training Course Curriculum : Brochure Download


Our SSAS Trainings are completely practical, realtime. Register today for free Demo


Benefits of our SSAS Training Course:

After the SSAS Classroom Training participant should be able to:

  • Completely Practical and Realtime
  • Theory material provided in Advance
  • Highly Interactive and Interesting
  • Daily Tasks and Weekly Assignments
  • Certification Guidance and FAQs
  • 24x7 Server Access with Realtime DBs
  • Design and Understand OLAP Cube Structures
  • Decide to Multidimensional and Tabular Techniques
  • Design MDX Queries and Expressions for Cube Reports
  • Tune OLAP Cube Structures with UBO and Partitions
  • Perform Aggregation Design and KPIs with DAX Expressions
  • Deploy and Implement SSAS OLAP Databases with Data Mining


Trainer : Mr. Sai Phanindra T, 11+ Yrs of Experience exclusively on SQL Server, SQL DBA, more..

Training Reviews

Register Now



SQL Server, SQL DBA, MSBI DWH Trainings


[+] More Courses

Register Today


Register Today For Free Demo