SSAS Training

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.

SSAS Training Curriculum
SSAS 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
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
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.

  • 10 Days
  • 0 Units
  • 0 Hrs

Select Your Currency

WOOCS 1.1.8
Drop Us A Query

Create an Account