This impeccable MSBI (SQL BI) Video Training course is carefully designed for aspiring BI Developers, Consultants and Architects. This MSBI Video 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 Video Training course also includes Power Query & DAX for Data Modelling and MDX & DMX for Big Data Analysis and Reports along with Power BI Intergration and Azure Integration. Complete practical and realtime MSBI Training course with 24x7 LIVE server, Resume Guidance, ONE Real-time Project with Interview & Placement Assistance.
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
MSBI | T-SQL, MSBI | T-SQL, MSBI Power BI |
|
No of Videos | 34 Videos | 46 Videos | 64 Videos |
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 | ❌ | ❌ | ✔ |
Total Course Fee* | INR 18000 USD 300 |
INR 23000 USD 325 |
INR 35000 USD 450 |
Trainer: Mr.Sai Phanindra (17+ Yrs of Exper)
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
Video 1: DATABASE INTRODUCTION
|
Video 5: SQL Basics - 3, T-SQL INTRO
|
Video 9: Triggers & Transactions
|
Video 2: SQL SERVER INSTALLATIONS
|
Video 6 : CONSTRAINTS, INDEXES
|
Video 10: DB Architecture & Group By
|
Video 3: SSMS Tool, SQL BASICS - 1
|
Video 7: JOINS & LINKED SERVERS
|
Video 11: TSQL Queries: Group By, Joins
|
Video 4: SQL BASICS - 2
|
Video 8: VIEW, SPs, FUNCTIONS BASICS
|
Video 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) |
SQL Server Reporting Services (SSRS) |
Video 1: SSIS INTRO, INSTALLATION
|
Video 1: SSAS INTRO, CONFIGURATION
|
Video 1: SSRS INTRO, INSTALLATION
|
Video 2: SSIS ETL PACKAGES: BASICS
|
Video 2: CUBE DESIGN WITH SSAS, EXCEL
|
Video 2: BASIC REPORT DESIGN
|
Video 3: MERGE & FUZZY LOOKUP
|
Video 3: HIERARCHIES, MDX - LEVEL 1
|
Video 3: GROUPING, REPORT PARAMETERS
|
Video 4: SSIS CHECKPOINT & PIVOT
|
Video 4: CALCULATIONS, MDX - LEVEL 2
|
Video 4: CHARTS, DASHBOARDS, FITLERS
|
Video 5: EVENTS, LOOPS, EXPRESSIONS
|
Video 5: PARTITIONS & AGGREGATIONS
|
Video 5: EXPRESSIONS, SHARED DATASETS
|
Video 6: SSIS with ETL, Warehouse (DWH)
|
Video 6: KPIs, OLAP CUBE DEPLOYMENTS
|
Video 6: REPORT BUILDER, GAUGES
|
Video 7: Checksum & DWH Design
|
Video 7: TABULAR CUBE DESIGN
|
Video 7: REPORT BUILDER, MAP REPORTS
|
Video 8: CDC Transformations for DWH
|
Video 8: TABULAR MODE CUBES, DAX - 1
|
Video 8: REPORT MANAGEMENT
|
Video 9: Fact Table Design, DWH Loads
|
Video 9: TABULAR MODE - DAX LEVEL 2
|
Video 9: MOBILE, KPI, CUBE REPORTS
|
Video 10: DWH MIGRATIONS, SCRIPT Task
|
Video 10: OLAP DATABASE MANAGEMENT
|
Video 10: PROJECT WORK in SSRS
|
Video 11: SSIS DEPLOYMENTS, UPGRADES
|
Video 11: Real-time Project for SSAS
|
End to End Implementation (Real-time)
|
Video 12: Realtime Project for SSIS & DWH
|
Video 12: Integration with Power BI [Plan C]
|
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
|
Job-Oriented Real-time Training @ SQL School Training Institute - Trainer: Mr.Sai Phanindra (17+ Yrs of Exper)