Microsoft SSAS Training

Microsoft SSAS Training Online course taught by 8+ years experienced working professional. 100% practical course with real-time projects and Lifetime Access to Digital library. Sample Resume fast-track orΒ  1 to 1 classes. Course Duration: 10+ hours.

Pre-requisites: Basic Computer knowledge.

Microsoft SSAS Training Topics

  • 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
  • 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
  • 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 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
  • 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
  • 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 & 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
  • Need for Data Mining Structures
  • Data Mining Algorithms and Rules
  • DMX Queries and Forecast Reports
  • Data Mining Scope and DMX Ranks
  • 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 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 & 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

  • Need for Optimization and Audits
  • Designing Aggregations using UBO
  • Aggregations For Optimization Levels
  • Audit Query Filters and Reuse Options
  • OLAP Restore Options and XMLA
  • Cube Analysis with Excel Tables
  • Excel Pivots and Refresh Options
  • Configuring ODC (Office) Connections
  • Prediction Functions and Analysis
  • DMX and MDX Queries Interfaces
  • 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
  • MDX and OLAP Operations with ETL
  • Scheduling SSAS Operations (XMLA)
  • Comparing SSAS 2012 & SSAS 2014
about course 01

Microsoft SSAS Training Online

Usually, We provide a 1-hour class from Monday through Friday. We can also arrange fast-track and one to one classes at no extra charges.

CV, Interview Preparation

The instructor will share a sample resume before course completion. During course, you can seek the faculty’s help to make your CV. We’ll give you interview question answers.

interview image
model certificate image

Microsoft SSAS Certification

We’ll guide you on how to get certified as ssas developer. Our course isn’t aiming to get certified but covered real-time examples. Course helpful to get a job and fulfilling day to day activities in the office.

Microsoft SSAS Developer Salary, Career

Regarding the Microsoft framework, SSAS is an excellent framework.As long as Microsoft SSAS will be in demand

career image
project support image

Microsoft SSAS Project Support

We can provide job support for an additional fee. Contact the support team for fee details. You can choose either the hourly rate or monthly fee.

Our Happy Student Reviews!