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