SSAS Training & Certification | SSAS Online Course

Key Highlights

+1 930 200 4823

10 Hrs Instructor Led Training

Self-paced Videos

20 Hrs Project & Exercises

Certification

Job Assistance

Flexible Schedule

Lifetime Free Upgrade

Mentor Support

Curriculum

A complete index of
job-ready skills curated
to meet the industrial need.
Explore.

SSAS Installation and Configuration

Introduction to SSAS 2012 & 2014
Multidimensional Mode Configuration
Tabular Mode Configuration, In-Memory
Testing SSAS Workspace Servers in SSDT
Understanding Real-world 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

Basic SSAS Entities & Usage 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
CROSS APPLY versus MDX JOINS
CROSS APPLY 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

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

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

Using 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

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

Schedules and SSAS Upgrades

OLAP Management with ETL/DWH
MDX and OLAP Operations with ETL
Scheduling SSAS Operations (XMLA)
Comparing SSAS 2012 & SSAS 2014

We have made a tailored curriculum covering the latest industry-ready concepts to serve every individual’s learning desires.

SSAS Training Objectives

1. What are the SSAS training course objectives?

By the end of the SSAS training, you will be able to:

Understand the need for OLAP and basic concepts related to OLAP like Cube, Dimension, Measures,
Understand Star and Snowflake Schema.
Use SSDT (SQL Server Data Tools) to develop the OLAP Database.
Work with Data Source and Data Source View.
Work with attribute relationship, Roleplaying dimension, measure group, adding removing measures.
Work with KPI, Perspective, Translation.
Work with Partition, Aggregation, Security, Roles.
Understand different storage modes like ROLAP, MOLAP and HOLAP.

2. Why should you learn the SSAS course?

There are numerous job opportunities for skilled SSAS professionals around the globe.
Top multinational companies are hiring certified SSAS professionals worldwide.
The average salary of a certified SSAS professional is around $95000 USD per annum.

3. Who should attend SSAS training?

Business Intelligence professionals
Analysts
Database administrators.
Data Warehousing professionals

Aspirants are willing to build their career in the administrative field.

4. What are the prerequisites for learning SSAS training?

The following are the prerequisites for learning SSAS course:

No prior knowledge of SSAS, MDX, Dimensional modelling or Data Mining is required.
Basic working knowledge of SQL Server like working with tables, views, stored procedures etc is required.

The following job roles will get benefited by taking up this course:

Business Intelligence professionals
Analysts
Database administrators.
Data Warehousing professionals

5. What projects are included in this SSAS training course?

The tutor will take care of handling the projects. We will provide two real-time projects with a highly-skilled guide who can assist you throughout the project.

+1 930 200 4823