On demand Training Videos accessible at your comfortable timings and conveninent environment. Our SSAS Video Training Service (Course Code: VC05) offers complete realtime practical knowledge transfer services for aspiring SQL BI / Cube Developers. Study and Practice Material with Realtime Case Study, Free LIVE Server Access for online Lab are included in this course. Register for SSAS & MDX Video Training
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 |
Real-time, Practical Training Videos, accessible 24x7. Study, Practice Material and Lab Work for every video. Trainer available for doubts clarifications and support. Theory Material to be provided in Advance.
SSAS TRAINING HIGHLIGHTS (Technical) :
✔ Basic to Adv. Cube Design | ✔ 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 |
Video 1: SQL SERVER INTRODUCTION
|
Video 5: SQL Basics - 3, T-SQL INTRO
|
Video 9: JOINS, T-SQL QUERIES Level 3
|
Video 2: SQL SERVER INSTALLATIONS
|
Video 6 : CONSTRAINTS,INDEXES Basics
|
Video 10: VIEW, SPs, Function Basics
|
Video 3: SSMS Tool, SQL BASICS - 1
|
Video 7: JOINS, T-SQL Queries : Level 1
|
Video 11: Triggers & Transactions
|
Video 4: SQL BASICS - 2
|
Video 8: Group By, T-SQL Queries Level 2
|
Video 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 |
Video 1: INTRODUCTION TO SSAS & CONFIGURATION
|
Video 7: TABULAR MODE INSTALLATION, CUBE DESIGN
|
Video 2: BASIC CUBE DESIGN WITH SSAS, EXCEL PIVOT
|
Video 8: TABULAR MODE CUBE DESIGN, DAX - 1
|
Video 3: HIERARCHIES, MDX - LEVEL 1
|
Video 9: TABULAR MODE - DAX LEVEL 2
|
Video 4: CALCULATIONS, MDX - LEVEL 2
|
Video 10: OLAP DATABASE MANAGEMENT
|
Video 5: PARTITIONS, AGGREGATIONS, PERSPECTIVES
|
Video 11: Real-time Project for SSAS
|
Video 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 |
Video 1 : POWER BI BASICS
|
Video 7 : POWER QUERY LEVEL 1
|
Video 13 : POWER BI CLOUD - 1
|
Video 2: BASIC REPORT DESIGN
|
Video 8 : POWER QUERY LEVEL 2
|
Video 14 : POWER BI CLOUD - 2
|
Video 3 : Visual Sync, Grouping
|
Video 9 : POWER QUERY LEVEL 3
|
Video 15 : EXCEL & RLS
|
Video 4 : Hierarchies, Filters
|
Video 10 : DAX Functions - Level 1
|
Video 16 : Report Server, RDL
|
Video 5 : Bookmarks, Azure, Modeling
|
Video 11 : DAX Functions - Level 2
|
Video 17: MSBI Integrations
|
Video 6 : Visualization Properties
|
Video 12 : DAX FUNCTIONS Level 3
|
Video 18 : REAL-TIME PROJECT
|