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 Azure DevOps |
|
Total Duration | 6 Weeks | 8 Weeks | 12 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: MCSA Certification Guidance | ✔ | ✔ | ✔ |
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 | ❌ | ✔ | ✔ |
Azure DevOps Benefits | ❌ | ❌ | ✔ |
SDLC, Dev & Operations, DevOps | ❌ | ❌ | ✔ |
DevOps Tools, Git & GitHub | ❌ | ❌ | ✔ |
Docker, Kubernetes, AzureDevOps | ❌ | ❌ | ✔ |
Azure Boards, Azure Repos | ❌ | ❌ | ✔ |
Azure Testing, Azure Artifacts | ❌ | ❌ | ✔ |
Azure Pipelines (CI, CD) | ❌ | ❌ | ✔ |
Total Course Fee
* Payable in Installments |
INR 18,000 USD 244 |
INR 22,000 USD 298 |
INR 34,000 USD 460 |
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: 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 |
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
|
Module I: Azure Funda & DevOps Basics |
Module II: Azure DevOps Service - 1 |
Azure DevOps Service - 2
|
Video 1. Azure Fundamentals
|
Video 7: Organizations & Projects
|
Video 13: Azure Functions, App Service, Alerts
|
Video 2. Azure Services, Configurations
|
Video 8: Azure Boards
|
Video 14: Azure DevOps Resources in Portal
|
Video 3. Azure Active Directory, Monitoring
|
Video 9: Azure Repos
|
Video 15: Azure DevOps Strarter, App Insights
|
Video 4. SDLC, Dev & Operations, DevOps
|
Video 10: Azure Pipelines For CI/CD - 1
|
Video 16: Power Shell & Azure DevOps
|
Video 5. DevOps Tools, Git & GitHub
|
Video 11: Azure Pipelines For CI/CD - 2
|
Video 17: DevOps Server - Configurations
|
Video 6. Docker, Kubernetes, AzureDevOps
|
Video 12: Azure Testing & Artefacts
|
Video 18: DevOps Server & Visual Tools
|