SSAS Online Training

SSAS Online Training with MDX & DAX - LIVE, Instructor Led

SSAS Online Training at SQL School is carefully designed to involve 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. 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.

 
 
Schedule for SSAS Online Training (LIVE, Instructor Led)

Schedule: 8 AM to 9:30 AM India Time.

Trainer is a with an MNC, hence fixed timings. Free Demo: Register Today

 

This SSAS Online Training (ETL, DWH) Course includes ONE Real-time Project.     Versions: MSBI 2016, 2014, 2012

 


If above LIVE SSAS Online Training schedules work for you? please opt for On-demand, 24x7 SSIS Training Videos (Completely Practical, Real-time).
Trainer Profile, Duration, Pricing

Trainer: Mr Sai Phanindra T (10+ Yrs Exp, MS FTE)

Duration: 2.5 Weeks (Mon - Fri/Sat)

Total Course Fee: INR 7000/- (USD 120)

Payments by PayPal

If none of the above SSAS Online Training schedules work for you? please opt for On-demand, self paced 24x7 MSBI SSAS Video Training Course

 

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 versus MDX JOINS
  • 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 Resuse Options
  • OLAP Restore Options and XMLA
  • MDX with PARRELPERIOD & DATE
  • 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

 

LIVE SSAS Online Training Course Curriculum : Brochure Download

 

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

 

Benefits of our SSAS Training Course:

After the SSAS Online 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, 10+ 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