SSAS Training

SQL SERVER Analysis Services in the technology form Microsoft Business Intelligence stack and is used to develop online analytical processing (OLAP) solutions.

Interview Questions Online Exam Download Syllabus

SQL Server Analysis Services (SSAS) is a component of Microsoft SQL Server.

It is used to develop OLAP(Online Analytical Processing) Solutions. It is used for storing and retrieving large amount of data which can be used for analysis.

This extensive SSAS training Course is provided for participant to have in depth knowledge of developing OLAP Solution.

SSAS Training Modules: 13

Total Video Duration: 14 Hours 55 Minutes

Mrs. Vandana Soni
A well known trainer at Deccansoft for more than 6 years, she is a specialist in SQL Server 2008 and has taught well over many students. Her uniqueness lies in conducting her classes with ease and clarity, making her students understand even the most complex queries with no difficulty at all.

Online SSAS Training Course Objectives

The course will allow learners to

Understand need of OLAP.
Learn basic concepts related to OLAP like Cube, Dimension, Measures, Dimension Table, Fact Table, Hierarchies etc.
Understand Star and Snow Flake Schema.
Use SSDT (SQL Server Data Tools) to develop OLAP Database.
Work with Data Source and data Source View.
Develop Cube using Cube Wizard.
Create Dimensions using Wizard and Designer.
Work with Regular, Snow Flake and Time Dimension.
Configure Attribute properties, Understand Natural Hierarchies and Unnatural Hierarchies.
Work with attribute relationship, Role playing dimension.
Work with measure group, adding removing measures.
Understand relationships like Fact relationship, referenced relationship etc.
Work with Calculation, Named Query and Named Calculation.
Work with KPI, Perspective, Translation.
Work with Partition, Aggregation.
Understand different storage modes like ROLAP, MOLAP and HOLAP.
Work with Security, Roles.
Understand Processing and Deployment.
Learn MDX (Multidimensional Expressions Language).

SSAS Training Prerequisites

Participants should have knowledge on SQL Server.

To watch Free Videos you have to Login and creating of account is absolutely free. It will help you to understand the Quality of our Training and the Simple Language with which our Trainers have explained the topic.

Click here to download course syllabus

Subscribe Now for SSAS