SSAS Online Training at SQL School is carefully designed to involve Datawarehouse Implementation, OLAP Data Modelling, Cube Development, Dimension Modelling, MDX Programing, DAX Expressions, MDX & DAX Reports, Data Mining with Forecasts and Tuning and Debugging operations. Classes are completely practical and interactive with one real-time Case Study.
Pre-requisites: Participant needs to have knowledge on SQL Server T-SQL Queries to join our Real-time Practical Data Modelling (SSAS) Training Course.
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
Description | SSAS | SSAS & Power BI | T-SQL, SSAS & Power BI |
Total Duration | 2 Weeks | 6 Weeks | 8.5 Weeks |
SSAS: OLAP Cube Design | ![]() |
![]() |
![]() |
Multidimensional Cube Design | ![]() |
![]() |
![]() |
Tabular Mode Cube Design | ![]() |
![]() |
![]() |
MDX Queries & Expressions | ![]() |
![]() |
![]() |
DAX Queries & Expressions | ![]() |
![]() |
![]() |
Data Modelling with MDX | ![]() |
![]() |
![]() |
Data Modelling with DAX | ![]() |
![]() |
![]() |
Power BI Report Design | ❌ | ![]() |
![]() |
Power BI Desktop, Custom Visuals | ❌ | ![]() |
![]() |
Data Modelling with Power Query | ❌ | ![]() |
![]() |
Data Modelling with DAX | ❌ | ![]() |
![]() |
Power BI Cloud, Excel Analysis | ❌ | ![]() |
![]() |
Power BI Mobile, R, REST API | ❌ | ![]() |
![]() |
Python Integration, Data Flows | ❌ | ![]() |
![]() |
Power BI Report Server | ❌ | ![]() |
![]() |
Basic SQL, SQL Server | ❌ | ❌ | ![]() |
SQL Server Architecture | ❌ | ❌ | ![]() |
SQL Server T-SQL Concepts | ❌ | ❌ | ![]() |
Joins, Queries, Stored Procedures | ❌ | ❌ | ![]() |
Normal Forms and RAID | ❌ | ❌ | ![]() |
MCSA Cerrtification Guide | ❌ | ❌ | ![]() |
Total Course Fee* |
INR 7,000 USD 95 |
INR 15,000 USD 203 |
INR 19,000 USD 257 |
Schedules for SQL Server & T-SQL | |||
S No | Timings (IST) | Start Date | |
---|---|---|---|
Regular Schedules [Mon - Fri] | |||
1 | 6 AM - 7 AM | Mar 23rd | Register |
2 | 8 AM - 9 AM | Apr 6th | Register |
3 | 6 PM - 7 PM | Mar 15th | Register |
4 | 8 PM - 9 PM | Mar 1st | Register |
5 | 9 PM - 10 PM | Apr 19th | Register |
SSAS Training Schedules | ||||
S No | Timings (IST) | Start Date | ||
---|---|---|---|---|
Regular Schedules [Mon - Fri] | ||||
1 | 10 AM - 11 AM | Mar 17th | Register | |
2 | 5 PM - 6 PM | Mar 23rd | Register |
Training Schedules for Power BI | ||||
S No | Timings (IST) | Start Date | ||
---|---|---|---|---|
Regular Schedules [Mon - Fri] | ||||
1 | 8 AM - 9 AM | Mar 9th | Register | |
2 | 6 PM - 7 PM | Apr 12th | Register | |
3 | 9 PM - 10 PM | Mar 24th | Register |
If above schedule does not work, opt for SSAS Training Videos
SSAS TRAINING HIGHLIGHTS :
✔ Basic to Adv. ETL | ✔ Basic to Adv. DAX |
✔ Data Modelling | ✔ OLAP DB Design |
✔ Power Query | ✔ Basic to Adv. MDX |
✔ Kimball BI Design | ✔ Inmon BI Design |
✔ Star, Snowflake | ✔ Data Warehousing |
✔ OLTP, File Data | ✔ JSON, XML Data |
✔ Resume Guidance | ✔ MCSA MSBI Exam |
All Session Are Completely Practical & Real Time
Ch 1: SQL SERVER INTRODUCTION
|
Ch 5: SQL Basics - 3, T-SQL INTRO
|
Ch 9: JOINS, T-SQL QUERIES Level 3
|
Ch 2: SQL SERVER INSTALLATIONS
|
Ch 6 : CONSTRAINTS,INDEXES Basics
|
Ch 10: VIEW, SPs, Function Basics
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 7: JOINS, T-SQL Queries : Level 1
|
Ch 11: Triggers & Transactions
|
Ch 4: SQL BASICS - 2
|
Ch 8: Group By, T-SQL Queries Level 2
|
Ch 12 : ER MODELS, NORMAL FORMS
|
Real-time Case Study - 1
(Sales & Retail) Objective : Database Design, Table Design and Relations. Involves Purchases, Products, Customers and Time Data with Various Data Types. |
Real-time Case
Study - 2
(Sales & Retail) Objective : Queries, Excel Integration Pivot Tables, Pivot Charts, ODC Connections |
SSAS - Multidimensional Mode |
SSAS - Tabular Mode |
Ch 1: INTRODUCTION TO SSAS & CONFIGURATION
|
Ch 7: TABULAR MODE INSTALLATION, CUBE DESIGN
|
Ch 2: BASIC CUBE DESIGN WITH SSAS, EXCEL PIVOT
|
Ch 8: TABULAR MODE CUBE DESIGN, DAX - 1
|
Ch 3: HIERARCHIES, MDX - LEVEL 1
|
Ch 9: TABULAR MODE - DAX LEVEL 2
|
Ch 4: CALCULATIONS, MDX - LEVEL 2
|
Ch 10: OLAP DATABASE MANAGEMENT
|
Ch 5: PARTITIONS, AGGREGATIONS, PERSPECTIVES
|
Ch 11: Real-time Project for SSAS
|
Ch 6: KPIs, OLAP CUBE DEPLOYMENTS
|
Power BI with SSAS [For Power BI Plan C]
|
Part 1: Power BI Report Design |
Part 2: ETL, Data Modeling, DAX |
Part 3: Power BI Cloud, Admin |
Ch 1 : POWER BI BASICS
|
Ch 7 : POWER QUERY LEVEL 1
|
Ch 13 : POWER BI CLOUD - 1
|
Ch 2: BASIC REPORT DESIGN
|
Ch 8 : POWER QUERY LEVEL 2
|
Ch 14 : POWER BI CLOUD - 2
|
Ch 3 : Visual Sync, Grouping
|
Ch 9 : POWER QUERY LEVEL 3
|
Ch 15 : EXCEL & RLS
|
Ch 4 : Hierarchies, Filters
|
Ch 10 : DAX Functions - Level 1
|
Ch 16 : Report Server, RDL
|
Ch 5 : Bookmarks, Azure, Modeling
|
Ch 11 : DAX Functions - Level 2
|
Ch 17: MSBI Integrations
|
Ch 6 : Visualization Properties
|
Ch 12 : DAX FUNCTIONS Level 3
|
Ch 18 : REAL-TIME PROJECT
|