SSAS Online Training

SSAS Online Training



    Keen Technologies 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.

    Course Content

    1.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

    2.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

    3.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

    4.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

    5.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

    6.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)

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

    8.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

    9.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

    10.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

    11.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

    12.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

    13.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

    14.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

    15.Schedules and SSAS Upgrades

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

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • 4 weeks, 2 days
    Contact Us

    +1 475-212-0075

    Drop us a query

    Error: Contact form not found.

    Job Support

    Error: Contact form not found.

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies