Warning: DOMDocument::loadXML(): Start tag expected, '<' not found in Entity, line: 1 in /home/sitctrai/public_html/sqldbaonlinetraining/wp-content/plugins/premium-seo-pack/modules/title_meta_format/init.social.php on line 483
Contact Us :info@spectoittraining.com, India :+91-9533456356,USA :+1-847-787-7647

MSBI SSAS Online Training

MSBI SSAS Online Training Course Content

Introduction to SSAS

  • Introduction to SSAS 2012 & 2014
  • SSAS Multidimensional Mode
  • SSAS Tabular Mode & In-Memory

Datawarehouse Architecture & OLAP

  • Understanding Real-world Databases
  • Identifying OLAP / Analysis Entities
  • Need for Cubes and Measures
  • Kimball & Inmon BI Methods

Basic SSAS Entities & Usage

  • Data Source and Data Source Views
  • Computed and Named Queries
  • Building Entity Relationships
  • Identifying Facts and Dimensions
  • Identifying Measurable Aggregates
  • Identifying Attributes and Hierarchies
  • Deciding Datawarehouse Schema

Dimension Entities

  • Dimensions from Entities & Relations
  • Cube & Database Dimensions

Dimension Wizard and Attributes

  • Creating Dimensional Entities
  • Attributes and Member Names
  • Choosing Dimension Templates
  • Applying Time Dimensions
  • Hierarchies and Limitations
  • Attribute Relations and Uses
  • Composite Attribute Keys
  • Building Levels and Hierarchies

Cube Wizard and Relations

  • Planning for Cube Design
  • Identifying Cube Entries
  • Additives & Semi Additives

Cube Customization Options

  • Calculations and Options
  • MDX Scripting for Calculations
  • Calculation Sets and Scripts
  • BI Enhancements and MDX
  • Time Calculations with MDX

Dimension Types & Usage

  • Role Playing Dimensions
  • Fact & Factless Dimensions
  • Referenced Dimensions & Usage
  • Conformed Dimensions
  • Degenerate Dimensions
  • Hierarchy Dimensions and Relations

Cube Design Options and KPI

  • Dimension Usage and Granularity
  • Building Fact Less Dimensions
  • 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
  • Deciding Storage Modes
  • Aggregation Design & Caching

MDX Functions, FILTERS and JOINS

  • MDX Functions & Conditional JOINS
  • Complex MDX Queries & FILTERS
  • CROSSAPPLY versus MDX JOINS
  • CROSSAPPLY & MDX 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 Ranking

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 Predicates
  • Hierarchial MDX in Tabular Mode
  • Filtered MDX in Tabular Mode

Deployment (Tabular & Multidimensional)

  • Deployment Options and Pre-requisites
  • Deployment Process and Tools
  • Creating OLAP (SSAS) Databases
  • Processing Options and stages
  • Managing Deployment Process

SSAS Logs (Tabular & Multidimensional)

  • SSAS Database and Cube Audits
  • Choosing correct log providers
  • Managing SSAS Log Providers

OLAP Database Management

  • OLAP & Tabular Database Backups
  • Compressions and Encryptions
  • Backup Options and Restores
  • Scheduling Backups and Jobs
  • DB Synchronizations and XMLA
  • Managing Partitions & Aggregations

Usage Based Optimization (UBO)

  • Need for Optimizations and Audits
  • Designing Aggregations using UBO
  • OLAP Restore Options and XMLA

Using OLAP Structures

  • Cube Analysis with Excel Tables
  • Excel Pivots and Refresh Options
  • Configuring ODC Connections
  • Prediction Functions and Analysis
  • DMX and MDX Interfaces

Managing Security with MDX

  • SSAS Security Roles and Scope
  • Object Level Access and MDX
  • Item Level Security and DAX
  • Dynamic Security with MDX
  • Security Audits and Query Logs

Schedules and SSAS Upgrades

  • Using SSIS for DW Management
  • MDX and OLAP Operations in SSIS
  • Scheduling SSAS operations (XMLA)
  • Comparing SSAS 2012 & 2014