What you'll learn:
- Participant will be able to pass the job interview on this technology
- If the participant is already working then the person will feel more confident in handling real time project as this course will deepen the understanding
Microsoft SSAS Multidimensional Model Technology is a part of Microsoft Business Intelligence - MSBI. The OLAP cubes MDX expressions to generate the report. Please check MDX Training Part 1 and MDXTraining Part 2 to learn MDXexpressions
The following topics are covered in Microsoft SQL Server Analysis Services OLAP Cube Online Video Training Course
Impersonation Options in SSAS
Named Calculation Key Column Name Column
Sorting one attribute using another attribute
How to increase processing performance using attribute relationship
Ragged Hierarchy
Parent-Child Hierarchy
Star and SnowFlake Schema
Types of Relationships - Regular,Referenced,Fact and Many to Many
Role Playing Dimension
Creating Empty Cube
Creating Multiple Cubes in a Project
Dimensions at project level and cube level
Why do we need Partitions in SSAS
How to create Partitions in SSAS
Aggregations in SSAS
Usage Based Aggregations
How to enable and disable Usage Based Aggregations
Storage Modes - MOLAP ROLAP HOLAP
Outdated Cube and what is the need of Proactive Caching
ProActive Caching Implementation
Perspectives - Subset of Cube's Objects
Translations - Multi Language Support
Key Performance Indicators Implementation
Trends Implemetation using Isempty() and ParallelPeriod
Actions in SSAS
Backup and Restore - SSAS Database
Scheduling Process Full Option using XMLA and SQL Server Agent
Processing Options at DimensionLevel - Process Update Process Add
Processing MeasureGroup - Process Data, Index, Add, Clear,Default
Processing Multiple Objects(Dimensions and Measure Groups) together in SSAS
Write Back Option - WhatIF Analysis in Excel
SSAS Security
Security at Dimension Level
CellSecurity - Restricting Measures Data
How to test Security Settings in SSMS
How to test Security Settings in Excel
