This impeccable MSBI (SQL BI) course is carefully designed for aspiring BI Developers, Consultants and Architects. This MSBI Online Training includes basic to advanced Business Intelligence, Data Warehouse (DWH) and Data Analytics (OLAP) concepts on SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS). This MSBI Online Training course also includes Power Query & DAX for Data Modelling and MDX & DMX for Big Data Analysis and Reports along with Power BI Cloud and Azure Integration.
Complete practical and realtime MSBI Training with 24x7 LIVE server and Real-time Project with Interview & Placement Assistance.
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
MSBI | T-SQL, MSBI | T-SQL, MSBI Power BI |
|
Total Duration | 6 Weeks | 9 Weeks | 13 Weeks |
MSBI - SSIS: ETL, Data Warehouse | ✔ | ✔ | ✔ |
MSBI - SSIS: Dimension, Fact Loads | ✔ | ✔ | ✔ |
MSBI - SSIS: Star & Snowflake Schemas | ✔ | ✔ | ✔ |
MSBI - SSAS: OLAP Cube Design | ✔ | ✔ | ✔ |
MSBI - SSAS: MDX, DAX, XMLA, DMX | ✔ | ✔ | ✔ |
MSBI - SSAS: Data Modeling with MDX | ✔ | ✔ | ✔ |
MSBI - SSAS: Data Modeling with DAX | ✔ | ✔ | ✔ |
MSBI - SSRS: Report Design, Hosting | ✔ | ✔ | ✔ |
MSBI - SSRS: Azure Cloud Data Source | ✔ | ✔ | ✔ |
MSBI: Real-Time Project | ✔ | ✔ | ✔ |
SQL : Basic SQL, SQL Server Concepts | ❌ | ✔ | ✔ |
T-SQL : Queries, Joins, Group By | ❌ | ✔ | ✔ |
T-SQL : Queries, SProcs, Lock Hints | ❌ | ✔ | ✔ |
T-SQL: Queries, Normal Forms, Excel | ❌ | ✔ | ✔ |
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 | ❌ | ❌ | ✔ |
PL 300 Exam Guidance | ❌ | ❌ | ✔ |
Trainer: Shekhar
SQL Server & T-SQL Schedules | ||||
S No | Time (IST, Mon - Fri) | Start Date | ||
---|---|---|---|---|
1 | 6 AM - 7 AM | June 27th | Register | |
2 | 8 PM - 9 PM | July 12th | Register | |
3 | 9 PM - 10 PM | June 8th | Register | |
4 | 11 PM - 12 AM | June 19th | Register |
MSBI Training Schedules | |||
S No | Time (IST, Mon - Fri) | Start Date | |
---|---|---|---|
5 | 8:30 AM - 9:30 AM | June 7th | Register |
6 | 8:30 PM - 9:30 PM | June 2nd | Register |
If above schedule does not work, opt for MSBI Training Videos
MSBI 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 |
✔ Reports & Dashboards | ✔ Power BI Cloud |
✔ OLTP, File Data | ✔ JSON, XML Data |
✔ Mobile Reports | ✔ Interview FAQs |
✔ Resume Guidance | ✔ MCSA MSBI Exam |
All Session Are Completely Practical & Real Time
Ch 1: DATABASE INTRODUCTION
|
Ch 5: SQL Basics - 3, T-SQL INTRO
|
Ch 9: Triggers & Transactions
|
Ch 2: SQL SERVER INSTALLATIONS
|
Ch 6 : CONSTRAINTS, INDEXES
|
Ch 10: DB Architecture & Group By
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 7: JOINS & LINKED SERVERS
|
Ch 11: TSQL Queries: Group By, Joins
|
Ch 4: SQL BASICS - 2
|
Ch 8: VIEW, SPs, FUNCTIONS BASICS
|
Ch 12 : ER MODELS, NORMAL FORMS
|
Case Study 1 - For Database, Table Design (Constraints, Keys) |
Case Study 2 - For Query Writing + Window Functions (Rank, RowNumber) |
SQL Server Integration Services (SSIS) |
SQL Server Analysis Services (SSAS - Tabular Mode) |
SQL Server Reporting Services (SSRS) |
Ch 1: SSIS INTRO, INSTALLATION
|
Ch 1: Tabular Mode Introduction
|
Ch 1: SSRS INTRO, INSTALLATION
|
Ch 2: SSIS ETL PACKAGES: BASICS
|
Chapter 2: Tabular Mode Cube Design
|
Ch 2: BASIC REPORT DESIGN
|
Ch 3: MERGE & FUZZY LOOKUP
|
Chapter 3: Cube Objects
|
Ch 3: GROUPING, REPORT PARAMETERS
|
Ch 4: SSIS CHECKPOINT & PIVOT
|
Chapter 4: CUBE Data Models
|
Ch 4: CHARTS, DASHBOARDS, FITLERS
|
Ch 5: EVENTS, LOOPS, EXPRESSIONS
|
Chapter 5: Cube Deployment & MDX
|
Ch 5: EXPRESSIONS, SHARED DATASETS
|
Ch 6: SSIS with ETL, Warehouse (DWH)
|
Chapter 6: DAX - Level 1
|
Ch 6: REPORT BUILDER, GAUGES
|
Ch 7: Checksum & DWH Design
|
Chapter 7: DAX - Level 2
|
Ch 7: REPORT BUILDER, MAP REPORTS
|
Ch 8: CDC Transformations for DWH
|
Chapter 8: DAX - Level 3
|
Ch 8: REPORT MANAGEMENT
|
Ch 9: Fact Table Design, DWH Loads
|
Chapter 9: DAX - Level 4
|
Ch 9: MOBILE, KPI, CUBE REPORTS
|
Ch 10: DWH MIGRATIONS, SCRIPT Task
|
Chapter 10: DAX - Level 3
|
Ch 10: PROJECT WORK in SSRS
|
Ch 11: SSIS DEPLOYMENTS, UPGRADES
|
Chapter 11: DAX - Level 4
|
End to End Implementation (Real-time)
|
Ch 12: Realtime Project for SSIS & DWH
|
Chapter 12: Power BI Integrations
|
MSBI Resume Guidance, Interview FAQs
|
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
|