SSAS Training

SSAS Training
4.5 138

SSAS Training curriculum involves many fundamental topics, including, Datawarehouse Implementation, OLAP Data Modelling, Cube Development, Dimension Modelling, MDX Programing, DAX Expressions, MDX & DAX Reports, Data Mining with Forecasts and Tuning and Debugging operations.

Date :
20 May 2017
Course Duration (Hrs):
Date :
21 May 2017
Course Duration (Hrs) :
Date :
27 May 2017
Course Duration (Hrs) :
Date :
03 Jun 2017
Course Duration (Hrs) :
Date :
04 Jun 2017
Course Duration (Hrs) :
Contact Us Now!    

Microsoft SQL Server Analysis Services, SSAS, is an online analytical processing (OLAP), data mining and reporting tool in Microsoft SQL Server. It is purposefully used by the organizations to analyze and make sense of the information which possibly spread out across multiple databases, or in disparate tables.

Analysis Services are considered to be an online analytical data engine used in business analytics, thus providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.

SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. 


SSAS Training is carefully designed to involve Datawarehouse Implementation, OLAP Data Modelling, Relational Databases, Data Mining and Debugging operations to create, design and visualize the models.

SSAS training classes teach attendees how to set up and use Analysis Services to help understand their data, then extract the information they need. SSAS training also helps you build agile and responsive Business Intelligence solutions. 


SSAS Training Curriculum

curriculum_moduleSSAS Installation and Configuration

Introduction to SSAS 2012 & 2014

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 Methods – BI Design

SSAS Usage and Target Access Methods

Column Storage, Row Storage Options

curriculum_moduleBasic 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

curriculum_moduleDimension 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

curriculum_moduleCube 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

curriculum_moduleDimension 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

curriculum_moduleSSAS 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)

curriculum_moduleMDX 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

curriculum_moduleData Mining and Forecast

Need for Data Mining Structures

Data Mining Algorithms and Rules

DMX Queries and Forecast Reports

Data Mining Scope and DMX Ranks

curriculum_moduleTabular 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

curriculum_moduleDeployment (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

curriculum_moduleOLAP 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

curriculum_moduleUsage-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

curriculum_moduleUsing OLAP Structures

Cube Analysis with Excel Tables

Excel Pivots and Refresh Options

Configuring ODC (Office) Connections

Prediction Functions and Analysis

DMX and MDX Queries Interfaces

curriculum_moduleManaging 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

curriculum_moduleSchedules and SSAS Upgrades

OLAP Management with ETL/DWH

MDX and OLAP Operations with ETL

Scheduling SSAS Operations (XMLA)

Comparing SSAS 2012 & SSAS 2014



SSAS Course FAQs

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

The Training itself is Real-time Project Oriented.

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

There are some Group discounts available if the participants are more than 2.

As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, India and other parts of the world. We are located in USA. Offering Online Training in Cities like

New York, New jersey, Dallas, Seattle, Baltimore, Houston, Minneapolis, Los Angeles, San Francisco, San Jose, San Diego, St. Louis, Jacksonville, Towson, Salt Lake City, Davidson, Murfreesboro, Alexandria, Sunnyvale, Santa clara, Carlsbad, San Marcos, Franklin,Tacoma, Bellevue, Austin, Garland, Raleigh-Cary, Boston, Orlando, Fort Lauderdale, Miami, Gilbert, Tempe, Chandler, Scottsdale, Peoria, Honolulu, Columbus, Raleigh, Nashville, Plano, Toronto, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Hyderabad, Bangalore, Pune, Mumbai, Delhi, Dubbai, Doha, Melbourne, Brisbane, Perth, Wellington, Auckland etc…


Job Support

Mindmajix Job support’s aim is to train and support as many young IT professionals as possible in achieving their tasks for attaining quality jobs in the regular workforce.

For a fresher in IT, the actual requirement of programming and development standards could be partially or completely different in the job environment. Job support gives graduates that extra guidance before or after they attempt employment into IT sector by assisting them with the SASS training by highly experienced and real time professionals with full stack technical background in the SASS field. They address your complete issues that you face periodically.

We have wide-spread services across India, USA, Australia and other countries, assisting software employed people to excel in their jobs when they have an onset of a worsening condition.

Our trainers support you solve your technical problem and guide you to the right path in order to obtain a favourable solution. Once we understand your project, the subsequent problems are solved even better and faster.

What we assure?

* Our trainers make it a point to make you capable of understanding the real world scenarios.

* Our trainers will provide exceptional Technical assistance and help you out solve your Technical problems at your jobs in an efficient way.

* We assist the person learn a new job, and ensure extra assistance or a different format for learning the role vividly.

We Specialize in providing most reliable support and you can entirely entrust to us.

Drop Us A Query

Course Reviews


138 ratings
  • 597
  • 421
  • 314
  • 26
  • 11
Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.