FREE OOPS & C# Online Training by Mr. Sandeep Soni, everyday from 6PM (IST) Book your seat

Live Help (Start Chat)


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


Course Overview

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.

Why Our USP…

  • Before subscribing, one can look at Demo Videos for each course to know the Quality and Quantity of subject covered in our trainings.
  • For each topic, we provide only one course by the best trainer in the industry.
  • SME – A Subject Matter Expert will be assigned to every subscriber and will be responsible for addressing all technical queries.
  • Our Course Material is very organized and simple. It can be used for learning and as reference material as well.
  • We provide Interview Questions for each module of the course which will prepare you for interviews.
  • Microsoft Certification Guidance will be provided by Mr. Sandeep Soni (MCT).
  • Every course is accompanied by a Realtime project along with a step-by-step guide and complete source code.
  • You can reach Mr. Sandeep Soni, our core trainer directly and talk to him anytime for any subject related questions. You can also reach out to him for career guidance.

Self-Paced Training

  • Premium Edition Membership (Duration: 12 months)

    Actual Price

    $250 / ₹16750

    Offered Price

    $100 / ₹6700

Personalized Live Online Training


Request For Demo & More Details

Money Saver Packages


  • 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).


Related Certifications

Not available.


Participants should have knowledge on SQL Server.




13 Modules
14.9 Hours of Videos
13 Module wise reference material
Access from Mobie, PC or app

Course Completion Certificate

Trainer Profile

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. Her class sessions are also now available as videos, targeting students who want to learn the course at their own pace and convenience. An avid learner, she has now trained herself in Microsoft Business Intelligence suite of products (SSIS, SSAS and SSRS), a must for everyone specializing in Business Intelligence and will soon be launching the classes which will definitely enhance one's knowledge in SQL Server.


Subject-matter expert

Support Image

Any Technical Queries?

Our Trainers always ready to take your questions related to learning subject and resolve them to the best of thier capablities. You can connect with them either on Skype, email or in special cases call them on Phone or WhatsApp.

Bestdotnet google plus
© Copyright 1997 - 2018 | | All Rights Reserved.