Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Abonnieren
Hier kannst du dein Wissen und Können an Millionen von Teilnehmer:innen in aller Welt weitergeben und damit richtig Geld verdienen!
Weitere Infos
Dein Einkaufswagen ist leer.
Weiter einkaufen
SSAS Training MultiDimensional Model - Part 3
Bewertung: 4,4 von 5(150 Bewertungen)
1.481 Teilnehmer:innen
Erstellt vonVikas Munjal
Zuletzt aktualisiert 12/2024
Englisch

Das wirst du lernen

  • 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

Kursinhalt

1 Abschnitt • 49 Lektionen • 6 Std. 11 Min. Gesamtdauer

  • Named Calculation Key Column Name Column18:48
  • Links to download Adventureworks data warehouse0:17
  • Impersonation Options in SSAS9:52
  • Sorting one attribute using another attribute11:40
  • How to increase processing performance using attribute relationship Theory5:35
  • How to increase processing performance using attribute relationship - Practical13:58
  • Lab Exercise - Creating an Analysis Services Multidimensional Project0:06
  • Ragged Hierarchy11:05
  • Parent-Child Hierarchy15:36
  • Star and SnowFlake Schema3:37
  • Introduction to Types of Relationships2:11
  • Regular Relationship2:32
  • Referenced Relationship7:20
  • Fact Relationship6:09
  • Role Playing Dimension0:10

    I am including this topic Role Playing Dimension in between the topic types of relationships because  I discussed empty cube and regular relationship concepts into it. So i believe this is the correct place to discuss this topic before discussing other Relationship Types

  • Role Playing Dimension18:53
  • Many to Many Relationship - Theoretical Explanation5:53
  • Many to Many Relationship - Practical Implementation13:15
  • Dimensions at project level and cube level Using Empty Cube2:15
  • Lab Exercise - Relationships in SSAS0:06
  • Why do we need Partitions in SSAS8:28
  • How to create Partitions in SSAS18:45
  • Designing Aggregations in SSAS16:16
  • Usage Based Aggregations6:00
  • How to disable Usage Based Aggregations0:28
  • Lab Exercise - Partitions and Aggregations in SSAS0:06
  • Storage Modes - MOLAP ROLAP HOLAP10:11
  • Outdated Cube and what is the need of Proactive Caching2:44
  • ProActive Caching - Theoretical Explanation8:10
  • ProActive Caching - Practical Implementation15:12
  • Perspectives - Subset of Cube's Objects5:50
  • Translations - Multi Language Support10:32
  • Theoretical Explanation of Key Performance Indicators and Trends3:30
  • KPI Implemetation8:39
  • Trends Implemetation using Isempty() and ParallelPeriod8:39
  • Actions in SSAS18:28
  • Backup and Restore - SSAS Database4:47
  • Notes- Processing Options0:07
  • Scheduling Process Full Option using XMLA and SQL Server Agent8:55
  • Processing Options at DimensionLevel - Process Update Process Add7:16
  • Processing MeasureGroup - Process Data, Index, Add, Clear,Default6:05
  • Processing Multiple Objects(Dimensions and Measure Groups) together in SSAS1:16
  • Write Back Option - WhatIF Analysis in Excel6:10
  • SSAS Security13:05
  • Security at Dimension Level13:38
  • CellSecurity - Restricting Measures Data12:13
  • How to test Security Settings in SSMS1:37
  • How to test Security Settings in Excel3:19
  • Bonus Lecture1:40

Anforderungen

  • At least participant has learnt the course MDX Training Part 1
  • Or should know how to create a basic cube and the concepts like Dimensions and Measure Group

Beschreibung

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 MDX Training Part 2 to learn MDX expressions

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


Für wen eignet sich dieser Kurs:

  • After the end of the course along with MDX Training Part 1 and MDX Training Part 2, participant will have comprehensive knowledge on SSAS technology

Missbrauch melden