Live Help (Start Chat)
Download syllabus copy Download printable copy

SQL Server Analysis Service Training


SQL Server Analysis Services (SSAS) is component of SQL Server. It is used to design, create and manage multidimensional structures called Cube that contain data aggregated from other data sources.

It enables BI (Business intelligence) workers to perform Data Analysis.

This SSAS Training is provided to help the participant to understand Dimension Modeling in depth.

This training helps the participants to gain complete understanding of dimensions, measures, cube, hierarchies, calculations, KPI, Actions,Perspectives,Partitions and aggregations. Real time requirements provided in this training helps the participant to understand concepts easily and effectively.


  • To understand basic Data Warehousing Concepts
  • To Use SSDT (SQL Server Data Tools) in detail for development of SSAS Project.
  • To gain detail understanding of the dimension modeling concepts like Dimensions Facts,Measures,Members, Attribute, Hierarchy ,Cube .
  • To learn the Cube Development Lifecycle.
  • To learn to create and populate the OLAP Database.
  • To learn basic MDX to query the cube and writing simple expressions.
  • To learn working with calculations.
  • To learn creating KPI
  • To learn how to implement Action, Perspective and Translation.
  • To learn to work with Partitions and aggregations.
  • To learn to deploy the Cube to SSAS Server.
  • To understand how to implement security in SSAS
  • To learn how to browse the cube using SSDT and SSMS


Participants are need to be familiar with RDBMS concepts with skills to write queries. Working experience on any RDBMS would be an added advantage.


  • Regular classroom based training :10  days
  • Fast track (1-1) : Can be arranged as per the convenience of participant.
  • Weekend : 4 sessions
  • Visit online training : by Mrs. vandana  Soni, please visit
  • Online training :10 days

SQL Server Analysis Service Training Syllabus

  1. Need of Analysis
  2. Basics of Data Warehouse
  1. Modeling source schemas — stars and snowflakes
  2. Understanding dimensional
  3. Understanding fact (measures)
  1. Understanding the development environment
  2. Creating Data Sources and Data Source Views
  3. Creating and Deploying cubes
  4. Refining Dimensions and Measures in BIDS
  1. Basic syntax
  2. Using the MDX query editor in SQL Server Management Studio
  3. MDX Members Names
  4. Hierarchies, Levels and Members
  5. Using MDX Expressions
  6. Creating Simple MDX Queries
  1. Configuring dimension
  2. Adding ,removing dimensions
  3. Defining Hierarchies
  4. Creating Linked Dimension
  5. Creating Scenario dimension

Vandana Soni

A well known trainer at Deccansoft for more than 18 years, she is a specialist in SQL Server and has taught well over 80 batches. 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. more

Post an Enquiry

Email Id
Contact No
Scroll to Top