SSAS (SQL Server Analysis Services) Training

One of the top providers of online IT training worldwide is VISWA Online Trainings. To assist beginners and working professionals in achieving their career objectives and taking advantage of our best services, We provide a wide range of courses and online training.

4627 Reviews 4.9

Learners : 1080

Duration :  30 Days

About Course

Our SSAS (SQL Server Analysis Services) is a decision assistance and business analytics analytical data engine (VertiPaq). For business reports and client apps like Power BI, Excel, Reporting Services reports, and other data visualisation tools, it offers enterprise-grade semantic data models. Enrol today to earn your certification.

SSAS Training Course Syllabus

What Is Microsoft BI?

✔ Core concept – BI is the cube or UDM

✔ Example cube as seen using Excel pivot table

✔ MSBI is comprehensive – more than Analysis Services on SQL Server

✔ Demonstration of SQL Reporting Services with cube as data source

Using SSAS in BIDS

✔ Understanding the development environment

✔ Creating Data Sources and Data Source Views

✔ Creating cubes – using Cube Build Wizard

✔ Refining Dimensions and Measures in BIDS

Intermediate SSAS

✔ KPIs Calculations

✔ Translations – cube metadata and currency localization

✔ Actions – regular, drill-through and reporting

Cube Storage and Aggregation

✔ Storage topics – basic aggregations, MOLAP

✔ Advanced Storage Design – MOLAP, ROLAP, HOLAP

✔ Partitions – relational and Analysis Services partitions

✔ Customizing Aggregation Design – Processing Design

✔ Welcome to the Real-Time – Proactive Caching

✔ Cube processing options


✔ Basic syntax

✔ Using the MDX query editor in SQL Server Management Studio

✔ Most-used Functions & Common tasks

✔ New MDX functions

✔ Adding calculated members

✔ Adding scripts

✔ Adding named sets

Live Instructor Based Training With Software
Lifetime access and 24×7 support
Certification Oriented content
Hands-On complete Real-time training
Get a certificate on course completion
Flexible Schedules
Live Recorded Videos Access
Study Material Provided

SSAS Training - Upcoming Batches

Coming Soon



Coming Soon



Coming Soon



Coming Soon



Don't find suitable time ?


Live Virtual Training

  • Schedule your sessions at your comfortable timings.
  • Instructor-led training, Real-time projects
  • Certification Guidance.

Self-Paced Learning

  • Complete set of live-online training sessions recorded videos.
  • Learn technology at your own pace.
  • Get access for lifetime.

Corporate Training

  • Learn As A Full Day Schedule With Discussions, Exercises,
  • Practical Use Cases
  • Design Your Own Syllabus Based
For Business

SSAS Training FAQ'S

What is SQL Server Analysis Services (SSAS)? List out the features?

Microsoft SQL Server 2014 Analysis Services (SSAS) offers online analytical processing (OLAP) and data mining capabilities for business intelligence applications. Analysis Services supports OLAP by enabling us to create, develop, and manage multidimensional structures that include data generated from other data sources, such as relational databases. Analysis Services provides us with the ability to develop, create, and visualize data mining models that are constructed from other data sources by utilizing a wide range of industry-standard data mining algorithms.

Some of the key features are:

1. Ease of use with a lot of wizards and designers.
2. Flexible data model creation and management
3. Scalable architecture to handle OLAP
4. Provides integration of administration tools, data sources, security, caching, reporting, etc.
5. Provides extensive support for custom applications

By learning through VISWA Online Trainings, advance in your job.

What is the difference between SSAS 2005 and SSAS2008?
  1. A blank cube cannot be created in 2005, however, it is possible to do it in 2008.
  2. The Attribute Relationships tab in the Dimension Designer is a new tool in Analysis Services 2008 to implement attribute relationships, which are complicated in SSAS 2005.
  3. In 2005, we are limited to only 2000 divisions per Measure Group, and in 2008, that restriction is lifted.
What is OLAP? How is it different from OLTP?
  1. On-line analytical processing is known as OLAP. It is a feature or a group of technologies that enables end users to efficiently access data from data warehouses using a variety of tools, including Microsoft Excel, Reporting Services, and numerous other outside business intelligence applications.
  2. OLTP is characterized by less frequent data updates and contains past data; it is utilized for analysis to support daily business decisions. OLTP (On-Line Transactional Processing), on the other hand, is used to support daily business operations. It is characterized by frequent data updates, contains the most recent data, and only contains a small amount of historical data based on the retention policy determined by business needs.
What is a Data Source? What are the different data sources supported by SSAS?

The connection details needed by SSAS to connect to the underlying database and load the data into SSAS during processing are contained in A-DATA SOURCE. Apart from other attributes like Query timeout, Isolation, etc., a data source primarily comprises the following data:

  1. Provider
  2. Server Name
  3. Database Name
  4. Impersonation Information

Both .Net and OLE DB providers are supported by SSAS. The key sources that SSAS supports are the ones listed below: SQL Server, MS Access, Oracle, Teradata, IBM DB2, and any other relational database that has the proper OLE DB provider.


Vishnu Gadipudi
Vishnu Gadipudi
I Enrolled in VISWA Online Trainings for IBM Integration BUS course . Recently I Completed IBM Integration BUS Batch. It was Really Awesome Experience. Best Place To Learn , Experienced Trainer, Gives Us High Level Knowledge....
Navya Biradavolu
Navya Biradavolu
I was enrolled for looker Bl Tool,it was amazing experience . especially soft skill batch is one of my favourite batch . overall learning process is quite impressive.
Indla sneha
Indla sneha
I have joined I have joined VISWA Online TRAININGS for Java full stack course and i have completed Advance Java module. I had a good knowledge of Hibernate, spring,spring boot,spring MVC. Tutor has knowledge in depth and is supportive. Srinadh sir solved all our doubts....
bindu hima
bindu hima
I am recently completed Talend course and trainer is Rajendra very professional and helpful. All the doubts were solved in a precise manner.
Tarunasree Gowra
Tarunasree Gowra
"I truly enjoyed this course." Chaitanya sir fantastic-very knowledgeable. Sir give us very informative and clear instruction on how to achieve the goal. Thank you!
Tejaswini Kommu
Tejaswini Kommu
Overall Linux Admin sessions batch was very good. Mr. RAM Krishna teaching was very helpful to remind our basic concepts in linux & networking.
Gopanaboina Mounika
Gopanaboina Mounika
It was great learning with such a great and experienced staff. Praveen Sir (Oracle EPM Cloud - FCCS) was very helpful and operations team also very helpful in solving any minor problems students go through process.
Jyothi Gutlapalli
Jyothi Gutlapalli
I like to share my experience which provide lots of courses and one of those I recently completed my Salesforce BA Course and I like to tell you it was a great experience and my knowledge and confidence is really boosted after completing this course.
Good experience and great learning platform for Hyperion Essbase and Planning. The faculty is also well trained and soft spoken.
Chaitu Viswa
Chaitu Viswa
It was very good session for QlikView. I would like to thank to teacher Mr.Chandu for providing guidance for the required modules. Thanks VISWA Team for giving apportunity to leran new skills.

Quick Links