Course Details

SQL Server Analysis Services (SSAS) is the technology from the Microsoft Business Intelligence stack, you can use SSAS to create cubes using data from data marts / data warehouse for deeper and faster data analysis.

About SSAS

Microsoft SQL Server Analysis Services, SSAS, is an online analytical processing (OLAP) solutions and data mining tool in Microsoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services, Reporting Services and Analysis Services. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors – Multidimensional and Tabular.

CourseSSAS Training
Mode of Training Instructor Led Live Online Training
Duration 30 hours
Timings Flexible (Our Rep will work with you on the timings that suits your needs)
Course Material Our Expert Trainer will share you all the necessary course material,  ppt’s, videos and pdf’s
Examples Trainer will cover Real time scenarios during the training
Interview Questions Click here to see the Interview Questions

Why to attend Tekslate Online Training ?​

Classes are conducted by Certified SSAS Working Professionals with 100 % Quality Assurance.

With an experienced Certified practitioner who will teach you the essentials you need to know to kick-start your career on SSAS. Our training make you more productive with your SSAS Training Online. Our training style is entirely hands-on. We will provide access to our desktop screen and will be actively conducting hands-on labs with real-time projects.

SSAS Training Curriculum

SSAS Installation and Configuration

Introduction to SSAS 2012 & 2014, Multidimensional Mode Configuration, Tabular Mode Configuration, In-Memory, Testing SSAS Workspace Servers in SSDT, Understanding Realworld Databases, Need for OLAP Databases and Mining, Need for Cubes and Faster Reports, Identifying OLAP / Analysis Entities, Kimball and Inmon Methds – BI Design, SSAS Usage and Target Access Methods, Column Storage, Row Storage Options.

Basic SSAS Entities & Usage

Data Source and Data Source Views, Computed Columns and Attributes, Building Relationships For Cubes, Identifying Facts and Dimensions, Identifying Measurable Aggregates, Identifying Attributes and Hierarchies, Deciding Cube (MOLAP) Schema, Named Queries and Relations in DSV, Database Dimensions from DSV Entities, Cube Dimensions from DSV Relations, Cube & Database Dimensions – Issues.

Dimension Wizard and Attributes

Creating Multi-Dimensional Entities, Attributes and Key Member Names, Cube Dimension Templates and Options, Applying Time Based Dimensions, Dimension Hierarchies and Limitations, Cube Attribute Relations and Uses, Composite Attribute Keys in OLAP Cubes, Building Attribute Levels and Hierarchies, Duplicate Attribute Key Errors, Common Deployment & Security Errors, Deployment Warnings in Real-World.

Cube Wizard and Relations

Cube Design – Regular Templates, Cube Measures and Dimension Keys, Additive and Semi Additive Measures, Cube Customization Options and MDX, Calculations and MDX Members, MDX Scripts for Member Calculations, Cube Calculation Sets and MDX Scripts, BI Enhancements and MDX in MOLAP, Time Based Calculations with MDX.

Dimension Types & KPI

Role Playing Dimensions and MDX, Fact and Factless Dimensions, Referenced Dimensions & Usage, Conformed Dimensions & Usage, Degenerate Dimensions & Usage, Junk & Hierarchical Dimensions, Dimension Usage and Granularity, Building Fact Less Dimensions, Static and Dynamic KPIs with MDX, Parent and Child KPIs with MDX, Defining KPIs and Goals using MDX, Perspectives using MDX Expressions, SSAS Actions with MDX and XMLA.

SSAS Partitions and Aggregations

Local and Remote Cube Partitions, Storage Modes – MOLAP, ROLAP, HOLAP, Aggregations and Proactive Caching, Tuning Cube Partition Processing, Row Estimations and Aggregations, Assigning Aggregations, Scripts, Usage Based Optimization (UBO).

MDX Functions, FILTERS and JOINS

MDX Functions & Conditional JOINS, Complex MDX Queries & FILTERS, CROSSAPPLY versus MDX JOINS, CROSSAPPLY and MDX Query Filters, Cube and Dimension Writebacks, MDX with Roleplaying Dimensions, MDX Transactions & Limitations.

Data Mining and Forecast

Need for Data Mining Structures, Data Mining Algorithms and Rules, DMX Queries and Forecast Reports, Data Mining Scope and DMX Ranks.

Tabular Mode Cube Design

Entity Identification Procedures, Workspace Configuration Settings, In-Memory Processing Options, Advance Cube Design Scenarios, Aggregated Measures with KPIs, Partitioned Dimensions & Usage, Conditional MDX Scripts & Options, Hierarchical MDX in Tabular Mode, MDX Filters and Joins in Tabular Mode.

Deployment ( Tabular & Multidimensional)

Deployment Options and Pre-requisites, Cube Deployment Process and Tools, SSAS Deployment Wizard Tool & Errors, Storage Locations – Cube & Partitions, Creating OLAP Databases, Scripts, Processing Options and Schedules, Managing Deployment Process (OLAP), SSAS Database and Cube/Mining Audits, MDX Query Log Tables in DB Engine, Flight Recorder Options and Sampling, Managing SSAS Log Providers.

OLAP Database Management

OLAP & Tabular Database Backups, OLAP Compressions and Encryptions, Backups, Restores and Passwords, Scheduling Backups and Jobs, OLAP DB Synchronizations and XMLA, Partitions – Splits and Merge Options, Managing Partitions & Aggregations.

Usage-Based Optimization (UBO)

Need for Optimization and Audits, Designing Aggregations using UBO, Aggregations For Optimization Levels, Audit Query Filters and Resuse Options, OLAP Restore Options and XMLA.

Using OLAP Structures

Cube Analysis with Excel Tables, Excel Pivots and Refresh Options, Configuring ODC (Office) Connections, Prediction Functions and Analysis, DMX and MDX Queries Interfaces.

Managing Security with MDX

SSAS Security Roles and Scope, Object Level Access and Dynamic MDX, Item Security and DAX Expressions, Dynamic Cube Security with MDX, OLAP Security Audits and Query Logs.

Schedules and SSAS Upgrades

OLAP Management with ETL/DWH, MDX and OLAP Operations with ETL, Scheduling SSAS Operations (XMLA), Comparing SSAS 2012 & SSAS 2014.

Benefits to our Global Learners

  • Tekslate services are Student-centered learning.
  • Qualitative & cost effective learning at your pace.
  • Geographical access to learn from any part of the world.

SSAS Certification Training in Your City

SSAS Training India

Tekslate provides instructor-led live online training and corporate training. SSAS Training provides you hands on real-time project experience. Our SSAS trainers are certified industry experts and work professionals. We provide customized training for beginners as well working professionals.

SSAS Training United States

Our trainers in US are certified and have in-depth knowledge regarding SSAS Concepts. Tekslate superior quality training is what makes us stand apart from others. Case studies are included in the curriculum of training programs irrespective of the mode you chose. You can avail training in your cities like New York, Los Angeles, Chicago, Houston, and more.

SSAS Training United Kingdom

For experienced professionals in UK, special batches are conducted in different timings. Customized approach to imparting training has made us different from others. You can clarify your doubts after completing the class. You can avail training in your cities like London, Birmingham, Leeds, Glasgow and more.

SSAS Training Canada

There are many companies that offer SSAS training in Canada. Our SSAS course provides basic understanding about the introduction and overview. It is the course that can be educate right from the beginner to the intermediate and advanced level. SSAS Training is provided by Real Time Industry Experts who has huge subject knowledge, skills and enhances the skills of students in the best way. You can avail training in your cities like Montreal, Winnipeg, Mississauga, Ottawa and more

SSAS Training in Hyderabad

We at TekSlate offer interactively designed SSAS training. The SSAS Training course design in Hyderabad aims not only imparting theoretical concepts, but also aid students explore and experiment the subject. By the end of our training program, students can confidently update their profiles with knowledge and Hands on experience.

SSAS Training in Bangalore

TekSlate masters in IT Online Training services. We are aware of industry needs and we are offering SSAS Training in Bangalore in a more practical way. We guarantee efficient training offered by real-time experts in the industry.

SSAS Training in Chennai

TekSlate is one of the top-ranked Institute in SSAS training in Chennai. We provide best quality training for SSAS online with well-experienced professionals. Our unique blend of hands-on training enables students with the productive skills to improve their performance.

SSAS Training in Pune

TekSlate offers Instructor-led online training by Top-Notch Trainers in Pune. Every session will be recorded and provided to you for future reference. Good quality Material will help students explore the subject confidently.

SSAS Training in Mumbai

TekSlate offers best SSAS Training in Mumbai with most experienced professionals. Our Instructors are working professionals in the related technologies. Our team of trainers provides training services in a practical way with a framed syllabus to match with the real world requirements for both beginner level to advanced level.

SSAS Training in Delhi

SSAS Training helps you to develop your IT skills through our wide variant training curricula. TekSlate in Delhi has immense experienced real-time professionals having years of experience. Our training program is very much mixed with both practical and interview point of questions to achieve the expertise in the subject.

What Are The Modes Of Training?

Tekslate basically offers the online instructor-led training. Apart from that we also provide corporate training for enterprises.

Who Are The Trainers?

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Tekslate also verifies their technical background and expertise.

What If I Miss A Class?

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

Can I Request For A Support Session If I Find Difficulty In Grasping Topics?

If you have any queries you can contact our 24/7 dedicated support to raise a ticket. We provide you email support and solution to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers.

What Kind Of Projects Will I Be Working On As Part Of The Training?

You will work on real world projects wherein you can apply your knowledge and skills that you acquired through our training. We have multiple projects that thoroughly test your skills and knowledge of various aspect and components making you perfectly industry-ready.

How Will I Execute The Practical?

Our Trainers will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

If I Cancel My Enrollment, Will I Get The Refund?

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

Will I Be Working On A Project?

The Training itself is Real-time Project Oriented.

Are These Classes Conducted Via Live Online Streaming?

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

Is There Any Offer / Discount I Can Avail?

There are some Group discounts available if the participants are more than 2.

Who Are Our Customers & Our Location ?

As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, India and other parts of the world.

Course Reviews


147 ratings
      • Tekslate has been one of the finest global online learning portals with clear information and learning. I attended the Apache Spark Certification training. The best part is that they have provided IDE ...
      • I have taken 2 instructor-led courses (SAP HANA and BO). The course contents were really rich, and trainers are experts in the technology fields. I would like to recommend the course to my colleagues ...
        Katelyn Thomas
      • After a great research on available online courses, I have decided to opt Tableau Training from Tekslate, am quiet satisfied with that. Coursework is well calibrated to make student more comfortable w ...
        Christinia Beth
      • I have enrolled last month, and finished the course... As a working professional, they given me an exposure to the domain, but also helped to learn the cross technologies and develop an inclination to ...
        Alison Benhar
    drop query

    Send us a Query

    Enroll into this course

    Register for Free Demo

    Three + 6

    Related Articles

    No Related Articles found


    Please leave a message and we'll get back to you soon.
    Three + 6