Microsoft Business Intelligence - MSBI Online Training (LIVE, Instructor-Led)

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.

If you are looking for a dedicted SSAS Tabular Mode Training with Azure, Please Click Here

MSBI (SSIS, SSAS, SSRS) Training Plans

	PLAN A	PLAN B	PLAN C
	SSIS, SSRS	T-SQL, SSIS, SSRS	T-SQL, SSIS, SSAS, SSRS
Total Duration	5 Weeks	8 Weeks	11 Weeks
MSBI - SSIS: ETL, Data Warehouse	✔	✔	✔
MSBI - SSIS: Dimension, Fact Loads	✔	✔	✔
MSBI - SSIS: Star & Snowflake Schemas	✔	✔	✔
MSBI - SSRS: Report Design, Hosting	✔	✔	✔
MSBI - SSRS: Azure Cloud Data Source	✔	✔	✔
SQL : Basic SQL, SQL Server Concepts	❌	✔	✔
T-SQL : Queries, Joins, Group By	❌	✔	✔
T-SQL : Queries, SProcs, Lock Hints	❌	✔	✔
T-SQL: Queries, Normal Forms, Excel	❌	✔	✔
MSBI - SSAS: OLAP Cube Design	❌	❌	✔
MSBI - SSAS: MDX, DAX, XMLA, DMX	❌	❌	✔
MSBI - SSAS: Data Modeling with MDX	❌	❌	✔
MSBI - SSAS: Data Modeling with DAX	❌	❌	✔
Total Course Fee*	INR 14000 USD 170	INR 19000 USD 300	INR 26000 USD 350

S No	Time (IST, Mon - Fri)	Start Date
SQL Server & T-SQL Schedules
1	6 AM - 7 AM	Oct 24th	Register
2	8 AM - 9 AM	Oct 18th	Register
3	6 PM - 7 PM	Sep 26th	Register
4	8 PM - 9 PM	Nov 6th	Register
5	9 PM - 10 PM	Oct 4th	Register

S No	Time (IST, Mon - Fri)	Start Date
MSBI Training Schedules
6	9:30 AM - 10:30 AM	Sep 21st	Register

If above schedules 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

MSBI Training (SSIS, SSAS, SSRS) Curriculum:

MSBI Curriculum

Register Today

Module 1 : SQL Server & T-SQL Queries Training [For Plans B, C]

Ch 1: DATABASE INTRODUCTION

Databases Introduction & Purpose
Database Types : OLTP, DWH, OLAP
Microsoft SQL Server Advantages, Use
SQL Server Components and Usage
Microsoft SQL Server - Career Options
Developer, DBA, Data Engineer
Data Analyst, Data Scientist Careers

SQL : Purpose, Real-time Usage Options
SQL Versus Microsoft T-SQL [MSSQL]
Course Plan, Real-time Project, Resume
24 x 7 Online Lab for Remote DB Access
Versions and Editions of SQL Server
SQL Server Pre-requisites : S/W, H/W
System Configuration Checker Tool

Ch 5: SQL Basics - 3, TSQL INTRO

Database Objects : Tables and Schemas
Schemas : Group Tables in Database
Schemas : Security Management Object
Creating Schemas & Batch Concept
Using Schemas for Table Creation
Data Storage in Tables with Schemas
Data Retrieval & Usage with Schemas

Table Migrations across Schemas
Import and Export Wizard in SSMS
Data Imports with Excel File Data
Performing Bulk Operations in SSMS
Temporary Tables : Real-time Use
Local and Global Temporary Tables
# and ## Prefix, Scope of Usage

Ch 9: Functions, Procedures Basics

Functions with SQL Server, TSQL
Scalar, Inline, Table Functions
Variables: Declare, Real-time Use
Creating, Executing Functions
Functions for Computations
Functions for Parameterized Joins
Procedures: Usage in Real-time

Using Parameters in SQL Server
Parameterized Joins in TSQL
Compilation with Stored Procedures
sp_help, sp_helptext, sp_helpindex
sp_helpdb, sp_rename, sp_recompile
System Views For Metadata Audits
DBID, DBName, ObjectID, ObjectName

Ch 2: SQL SERVER INSTALLATION

SQL Server & SSMS Installation Plan
SQL Server Pre-requisites : S/W, H/W
SQL Server 2022 & 2019 Installation
Database Engine Feature, OLTP
Instances : Types and Properties
Default Instance, Named Instances
Service and Service Account Use

Authentication Modes and Logins
Windows Logins and SQL Logins
SQL Server Management Studio
Server Connections with SSMS Tool
Local and Remote Connections
System Databases: Master and Model
MSDB, TempDB, Resource Databases

Ch 6: Constraints, Index Basics

Constraints and Keys - Data Integrity
NULL, NOT NULL Property on Tables
UNIQUE KEY Constraints: Importance
PRIMARY KEY Constraint: Importance
FOREIGN KEY Constraint: Importance
REFERENCES, CHECK & DEFAULT
Candidate Keys and Identity Property

Database Diagrams and ER Models
Relationships Verification and Links
Indexes : Basic Types and Creation
Index Sorting and Search Advantages
Clustered and NonClustered Indexes
Primary Key and Unique Key Indexes
Need for Indexes - working with Keys

Ch 10: TRIGGERS & TRANSACTIONS

Triggers - Purpose, Real-world Usage
FOR/AFTER Triggers - Real time Use
INSTEAD OF Triggers - Real time Use
INSERTED, DELETED Memory Tables
Using Triggers for Data Replication
Enable Triggers and Disable Triggers
Database Level, Server Level Triggers

Transactions : Types, ACID Properties
Transaction Types and AutoCommit
EXPLICIT & IMPLICIT Transactions
COMMIT and ROLLBACK Statements
Batch Concept and Go Statement
Open Transactions in Real-time
Using Conditional Commits, Rollbacks

Ch 3: SSMS Tool, SQL BASICS - 1

Creating Databases: Files [MDF, LDF]
Creating Tables in User Interface
Data Insertion & Report in User Interface
SQL : Purpose and Real-time Usage
SQL Versus T-SQL : Basic Differences
DDL, DML, SELECT, DCL and TCL
Creating SSMS Sessions : SPID

Create, Connect Databases using SQL
Creating Tables with INT, CHAR
Data Storage, Inserts - Basic Level
Table Data Verifications with Select
SELECT Statement for Table Retrieval
Identify Databases and Tables
Identify Sessions and Session ID

Ch 7: Joins Basics, TSQL Queries

JOINS - Table Comparisons Queries
INNER JOINS For Matching Data
OUTER JOINS For (non) Match Data
Join Queries with "ON" Conditions
Left Outer Joins - Example Queries
Right Outer Joins - Example Queries
FULL Outer Joins: Realtime Scenarios

CROSS JOIN and CROSS APPLY
One-way, Two way Data Comparisons
Using Table Aliases & Column Aliases
Optimizing Join Queries with Indexes
Choosing Correct Comparison Columns
Joining Unrelated Tables in TSQL
Self References, Self Joins in TSQL

Ch 11: Normal Forms, Cursors

First Normal Form and Atomicity
Third Normal Form and MVD Property
Boycee-Codd Normal Form : BNCF
Fourth Normal Form : Advantages
Self Reference Keys and 4 NF Usage
1:1, 1:M, M:1, M:M Relationship Types
Computed Columns, Variant Type

Linked Servers, Remote Joins in TSQL
2 Part, 3 Part, 4 Part Naming Styles
Remote Joins Queries and Aliases
Cursors - Basics, Data Operations
Cursors - Life Cycle & Declaration
Cursors Types, FETCH Operations
Cursors - Deallocate, Real-world Use

Ch 4: SQL BASICS - 2

Creating Tables: VARCHAR, FLOAT
Single Row Inserts, Multi Row Inserts
Rules for Data Insertion Statements
SELECT with WHERE Conditions
AND and OR Operators Usage
IN Operator and NOT IN Operator
Between, Not Between Operators

LIKE and NOT LIKE Operators
ORDER BY, TOP & OFFSET
Basic Sub Queries with SELECT
UPDATE Statement & Conditions
DELETE & TRUNCATE Statements
ALTER, ADD COLUMN Statements
DROP Statements: Table, Database

Ch 8: Group By, Views & Excel

GROUP BY: Importance, Realtime Use
GROUP BY Queries and Aggregations
Group By Queries with Having Clause
Group By Queries with Where Clause
Using WHERE and HAVING in T-SQL
Group By with Joins in TSQL
Query Execution Order & Aliases

Joins with Sub Queries, Formatting
Database Objects: Overview & Usage
Views: Types, Usage in Real-time
Creating, Executing & Verifying Views
Storing Queries in Database Views
Excel Analytics - Joins & Views
Excel Office Data Connection Reports

Ch 12: TSQL Merge, Cursors

IIF() Function with SELECT Query
WHEN..THEN..ELSE
WHEN MATCHED, NOT MATCHED
Incremental Loads, Upsert Statement
Stored Procedures: Merge Statement
UNION and UNION ALL Operator
Window Functions: Rank, Dense Rank

Row_Number, PartitionBy in TSQL
Duplicate Row Identification, Deletion
Grouping, Cube, Rollup, Lag, Lead
Data Types: Numerical, Date, Time
Data Types: Characters, Real, Float
Date & Time Functions, DateAdd
String Functions, Concat, SubString

Case Study 1: Database Design with Tables,
Constraints, Keys & Relations

Case Study 2: Joins with Group By,
Sub Queries, Views, Excel Analytics

Module 2 : MSBI (SSIS, SSRS) Training [For MSBI Plan A, B, C]

SQL Server Integration Services (SSIS)	SQL Server Reporting Services (SSRS)
Ch 1: SSIS INTRO, INSTALLATION Integration Services (SSIS) & ETL / DWH SSIS for Data Loads, ETL, Warehouse SSDT : SQL Server Data Tools SSIS Development, LIVE (Deployment) Data Warehouse Design & ETL Process DWH and ETL Structures Implementation SSIS ETL for Data Reads, Data Cleansing Data Warehouse (DWH) Design Principles SSIS 2019, 2017 : SSIS DB Installations SSIS Database, Catalog Folders, Storage SSIS Catalog Database (SSIS DB) Creation SQL Server Data Tools - SSDT / Visual Studio SSDT Installation and Catalog Verification SSIS, ETL, DWH, Data Flow, Data Buffer SSIS Package Environment, SSDT Projects SSIS & ETL Training - Lab Plan, Resources	Ch 1: SSRS INTRO, INSTALLATION Reporting Operations and Report Types Paginated Reports, Interactive Reports Analytical Reports & Mobile Reports Reporting Solutions (SSRS) and Tools Report Engine Architecture, Databases SSRS Report Server Installation Report Databases in SSRS and Usage Web Service URL : Connections, Usage Web Portal URL : Connections, Usage ReportServerDB, TempDB Configuration SQL Server Data Tools (SSDT) Report Builder, Mobile Report Publisher Report Design : Lab Plan, Data Sources 3-Phase Report Life Cycle (End-End) Report Builder Versus Report Designer Report Server, Web Service Integration
Ch 2: SSIS ETL PACKAGES: BASICS Control Flow Tasks Architecture, Purpose Data Flow Tasks Architecture, Purpose SSIS Packages @ Basic Data Flow, ETL SSIS Projects and Package Creation Data Pipelines in Data Flow Tasks SSIS Packages Execution Process Data Flow Objects, OLE DB Connections SSIS Package Creation - Control Flow DTSX Files for Package Execution SSIS Execution, Package Errors & Logs SSIS Transformation: Conditional Split Excel Connection and Memory Reference Source and Destination Assistants DAT File Imports and Annotations SSIS Project Configurations, Debugging SSIS 64 Bit, 32 Bit Configurations	Ch 2: BASIC REPORT DESIGN Working with SQL Server Data Tools Report Templates and Project, Solution Basic Reports - Understanding Entities Report Project Wizard Usage, Reports Data Source Connections and Databases Query Designer, Query Builder, Imports Table, Matrix Reports with Report Wizard Layout, Format - Drilldown Reports, Blocks Stepped Reports, Multi Field Drilldowns Report Template - Datasets & Reports Table Headers & Formatting Expressions Alternate Row Colors, Global Expressions Formatting Styles, Expressions, Reusability Expressions: IIF,Format,Ceiling,Round Textbox Properties: Date Format, Numbers Report Sources, Static/Dynamic Properties
Ch 3: MERGE & FUZZY LOOKUP MERGE and UNION ALL Transformations SORT, NOSORT and Advanced Sort Synchronous, Asynchronous Tfns Row, Partial Blocking Transformations Fully Blocking Transformations - Buffers Avoiding Fully Blocking Transformation Bulk Load Operations, SSIS Data Imports IsSorted & SortKey Position Options SSIS Package Performance & Resources Data Conversion Expressions Fuzzy Lookup Transformation, References Nomatch Cleansing @ Conditional Split Index Creations, Lookup Transformation Data Conversion, Derived Columns Varchar, Nvarchar, Error Redirections Threshold Values, Search Delimiters _Similarity, _Confidence Columns	Ch 3: GROUPING, REPORT PARAMETERS Grouping : Row Groups, Column Groups Row Groups, Parent - Child Groups Adding Groups to Existing & New Rows Group Headers & Footers, Sub Totals Field Visibility, Toggle with Parent Row Group, Header/Footer Properties Column Groups for Table Report, Options Drill-down Report, Row Groups, Visibility Column Group Advance Mode. Fixed Values Repeating Column Headers on Every Page Creating Parameters, Dataset Conditions Single Value and Multi Value Parameters Dynamic Parameters, Dependency Queries SSRS Parameters with Dynamic Conditions Dataset Links to Parameters, List Values SSRS Expressions, Global Fields, Values Advanced Options : Auto / Manual Refresh
Ch 4: SSIS CHECKPOINT & PIVOT Execute SQL Task and OLE DB Queries Transaction Options For SSIS Executables Precedence - Success/Failure/Completion SSIS Package Rollbacks Execution Options Checkpoints Purpose with Data Flow Tasks Checkpoint Files and SSIS Logging Tasks Transactions with Checkpoint File in SSIS Checkpoint Option Advantages, Limitations FailPackageOnFailure, Checkpoint Property REQUIRED/SUPPORT/ NOTSUPPORTED Transaction Property, CHECKPOINT Files Legacy Data, Data Cleansing, Formatting Denormalization, Keys. Need for OLTP PIVOT Transformation, Connection Assistant Pivot Usage - Implementation. Key Values Lineage ID - Purpose. Data Mappings Lineage IDs for Column Mapping, Pivot Keys SSIS Input Columns and Mappings Data Viewer : Data Transfer Verification Data Type Conversions, Error Redirection	Ch 4: CHARTS, DASHBOARDS, FITLERS Chart Reports - Design, Properties Series Values and Category Groups Report Categories with Series Groups Report Category Types and Differences Visualizations: Trend, Discrete Chart Clustered, Non Clustered Attributes Series Labels: Properties, Formatting Series Actions: Multi - Valued Parameters Report Actions: URL, Report Filters Dashboards : Creation and Real-time Use Multiple Chart Areas, Legends in Charts Dashboard Exports and Report Filters Static and Parameterized Report Filters Series, Markers Chart Areas, Limitations 3-Dimensional Report Properties, Visibility Range Charts, Data Bars, Area Charts Report Actions with Parameters, Joins Dataset and Toolbox Filters, Bookmarks Filters Vs Parameters - Difference Filter Conditions in Dataset, Toolbox
Ch 5: EVENTS, LOOPS, EXPRESSIONS SSIS Package Events, Validation, Execution PreExecution, Progress, Cleanup Events SSIS Events, Errors/Warnings/Information Configuring sysssislog System Tables Debugging : Data Viewers and Breakpoints ForEach Loop Container. File Connections Variables For Linking DFT, Control Flow Dynamic Connections with Variables Iterations, Fetch, Index Mapping SSIS Expressions for ETL and DWH FOR LOOP Expressions in SSIS Init/EvalExpression, AssignExpression SSIS Expressions, Functions, Values Data Insertions, Data Serializations Counter Values, Variables & Parameters SSIS for OS Level Operations, Loops Execute SQL Task : Return Values	Ch 5: EXPRESSIONS, SHARED DATASETS Shared Data Sources, Shared DataSets Date-Time Expressions with RDL Files FORMAT Function in SSRS, Parameters Data Type Conversions, Int / String Types String Functions, Page Breaks in SSRS LOOKUP Function, Dataset Joins in SSRS Field Value Replacement with Datasets Using LIST Item from SSRS Toolbox Field Expressions and Field Properties #VALX, #VALY, #PERCENT, #SERIES #LABEL, #AXISLABEL, #LEGENDTEXT 3D Pie Charts, Funnel and Tree Map 3D Funnel, Sunburst, Shape Charts Doughnut, Pyramid, 3D Pyramid Reports Parameterized Gauge Reports - Filters Indicators : Value, State Expressions RDL Expressions, Custom Functions
Ch 6: SSIS with ETL, Warehouse (DWH) OLTP Database : Historical Data Loads Data Warehouse (DWH) Purpose, Usage Dimensions, Attributes, Members Types Dimension Tables, Fact Tables Design TYPE1 and TYPE2 ETL Implementation SCD Type1, Type 2 for DWH in Sales Inferred Members and Legacy Loads Initial Data Loads with Data Marts Business Keys & non Identity Columns Surrogate Keys, Alternate Business Keys Cascading OLTP / Stage to DWH Rows Fixed Attributes, Changing Attributes Historical Attributes. Inferred Updates ETL Date, Row Status Transformations Attribute Key Types in SCD, Limitations Historical Attributes and Data Delta SSIS Connection Assistants - Reuse SCD Transformations in Real-time	Ch 6: REPORT BUILDER, GAUGES Report Builder Installation & Usage Differences with Report Designer Tool Data Source Creation with Report Builder Dataset Creation with Report Builder Dataset Design with Parameters, Filters Query Designer with Report Builder Toolbox Items Insertion and Properties Column Aggregates, Auto Group By Edits Adhoc Reports with Column Groups Dynamic Row Colors, Report Expression Gauge Reports: End User Access Report Types - Radial, Linear Gauges Indicators, Pointers, Scale Ranges Browser Compatibility, Offline Reports Gauge, Gauge Panel Properties, Filters Scale Properties, Values, Label Options Ranges & Labels, Items, Needle Options Parameterized Gauge Reports, Datasets
Ch 7: Checksum & DWH Design Checksum Transformation in ETL Loads Configuring Checksum: SSIS 2019, 2017 Transformation Logic, Parity Checks CRC Checksum For Type I, Type II ETL DWH DWH Dimension Tables With Checksum Lookup Transformation, Row Redirection OLE DB Command and Input Parameters Parameter Mapping, Dynamic Updates Cache Transformation CAW Memory Files Memory Connection Lookup with Cache Tuning Lookup: Caching, Index Options Pre-ETL Activities, DB Recovery Models FULL/ PARTIAL CACHE & NOCACHE Performance Tuning and Pre-ETL Loads Dependent Data Flow Tasks, Post ETL Internal Parameters and Query Updates Cache Allocation Options with ETL DWH	Ch 7: REPORT BUILDER, MAP REPORTS Map Reports - Map Layers and Map Items Map Gallery - ESRI Share Files (Geo Data) SQL Server Data Sources, Geo Spatial data Business Analysis Dashboards For Maps Polygon, Tile, Line and Point Map Layer Map Visualization and Bubble Map Reports Data Fields, Labels, Visualization Indicators Fields to Visualize, Color Rules and Labels Editing Report Builder Reports in Designer SSRS Deployment: Report Designer Reports SSRS Deployment: Report Builder Reports Report Deployment - Builds, Config Files Webservice URL, Webportal URL Access Data Source, Data Set Folders, Report URL Deployment of Shared Data Sources Deployment of Shared Datasets, Reports Report Manager Uploads for RDL Files
Ch 8: CDC Transformations for DWH DML Audits with Change Data Capture CDC Tables with SQL Server Connections CDC Connections & ADO.NET Integration CDC Control Flow and CDC State Values INITIAL LOADS & PRCESSING RANGE State Variables, Net Changes, Logging Initial & Incremental Dimension Loads Dynamic CDC Control, OLEDB Command Internal Parameters and Usage Options Parameter Mapping For ETL Type1, Type2 Integrating Control Flow for CDC @ ETL CDC Splitter - Row Inserts, Updates CDC Precautions, Input & Output Range Derived Column Transformations with CDC Limitations of ADO.NET Connections Master Child Packages,Parameter Binding Package Passwords, Project Parameters Project Configuration Options(32,64 bit)	Ch 8: REPORT MANAGEMENT Data Source Management, Subscriptions Dependant Items, Security Operations Edit Shared Data Sources in Web Portal Shared Data Source Enable and Hide Connection Types, Edits and Security Shared Dataset Operations: Report Edits Data Preview, Downloads, Link Reports Report Security: Browser Role, User Access Content Management, My Reports, Publisher Report Builder, Report Definitions, Uploads Report Tuning: Caching, Rebuilds, Refresh Report Tuning: Report Snapshot, Schedules Subscriptions: Standard and Data Driven Email and File share Subscriptions in SSRS Schedules and Report Delivery Options Report Server Settings, Shared Schedules Report Timeout, Report Parts and Publish Report Builder Sub Reports, Report Parts
Ch 9: Fact Table Design, DWH Loads Fact Table - Design and ER Model DWH : STAR & SNOWFLAKE Schemas Time Dimensions and ETL Date / Time Link Time Dimension to Facts, Lookups Parent-Child Packages for Fact Loads Inferred Members for NULL Dimensions SCD Wizard for DWH Fact Table Design Parameter Mapping for Incr Updates ETL Load IDs - Dimension Attributes Error Handling, Event Handling in SSIS Text Qualifiers with Flat File Sources Fact Load Design for Initial, Incr Loads End-to-End DWH Design Implementation Direct Data Loads and Staging Tables Fact Table Staging and Incr Updates	Ch 9: MOBILE, KPI, CUBE REPORTS Mobile Reports : Creation & Usage Excel and Report Server Sources Working with Mobile Report Publisher Elements Layout: Master, Tablet Grids and Color Palette. Deployment RSMobile Formats: Uploads, Downloads Shared Dataset in Report Builder Tool KPI Reports: Design from Web Portal KPI: Value, Goal, Status, Trend KPI Visuals: Bar, Line, Step, Area Custom URLs and Mobile Reports Cube Reports with SSAS MDX, DAX SSRS Cube Reports with Parameters MDX Default Parameters, Options SSAS OLAP Cube Actions with SSRS
Ch 10: DWH MIGRATIONS, SCRIPT Task DataWarehouse Migrations with SSIS Using SSIS Containers, Db Integrity Task Pre-Database Migration Task Precautions Online and Offline DB Transfer Options Copy / Move with DWH Migrations SMTP : Simple Mail Transfer Protocol SQL Server Agent and Package Events Data Profiling with ADO.NET Connectors XML Files & SSIS Data Profiler Tool Script Task - Working in SSIS Control Flow Script Task - VB.NET Program Compilations Variables, Parameters with SSIS Script Task Read Only, Read Write Variable Expressions Expressions and Debugging, Break Points Variables, Parameters Mapping Expressions File System Tasks and Limitations SQLDataAdapters & System.Data.SQLClient	Ch 10: PROJECT WORK in SSRS SQL Server Data Sources and Datasets Designing RDL [Paginated], Expressions Chart Reports, Line Reports, Options Dataset with Parameters and Filters Trend Analysis, Continuous Data Reports Data Bar Reports and Stacked Reports Multi-series Charts, Dynamic Chart Size Axis Display Control : Paginated Reports Parameters and Filters - When to use which Complete Project Solution & Explanation Work Flow Operations and Report Types Report Design, Builds, Report Deployment Report Edits, Data Source Changes to Azure Azure SQL Database for SSRS DB Source Report Management, Security, Subscriptions Report Tuning, Caching, Snapshot Options Project FAQs and Explanations for Resume
Ch 11: SSIS DEPLOYMENTS, UPGRADES SSISDB Catalog Deployments, ISPAC Files Package Builds, Verification, Scripts Project Deployment Wizard Targets, Logs DB Catalog Folders & Projects Creation Package Executions - Scripts, Reports Package Validations, 32/64 bit Options Configurations & Parameter Management Package Jobs @ SQL Agent. Job Steps Job Schedules and Notifications Event Logs Package Security - SSISDB Logins, Users Folder Level and Project Level Security Project Migration Utilities, Upgrades Package Imports, Exports with ISPAC Files Command-Line Deployment,Execution Utility Package Execution & Validation Reports Package Versions and Restores, Rollbacks	End to End Implementation (Real-time) End to End MSBI Implementation Process Project Requirements and SDLC Life Cycle Database Design and Entity Selection Understanding OLTP Databases, Relations Design of DWH : Data Warehouse Database SCD Techniques for ETL, Dimension Loads Fact Loads, STAR / SNOWFLAKE Schemas DWH Database Limitations for Analysis OLAP Databases for Data Analysis Cube Design and Operational Modes Mode Selection and Capacity Planning Tabular Mode OLAP Cube: Advantages Excel Analysis and Reports with MDX Using DAX for Modeling, Cube Reports Paginated Reports with OLAP, DWH MSBI Limitations, Need for Azure BI
Ch 12: Realtime Project for SSIS & DWH	MSBI Resume Guidance, Interview FAQs

SQL Server Integration Services (SSIS)

SQL Server Reporting Services (SSRS)

Ch 1: SSIS INTRO, INSTALLATION

Integration Services (SSIS) & ETL / DWH
SSIS for Data Loads, ETL, Warehouse
SSDT : SQL Server Data Tools
SSIS Development, LIVE (Deployment)
Data Warehouse Design & ETL Process
DWH and ETL Structures Implementation
SSIS ETL for Data Reads, Data Cleansing
Data Warehouse (DWH) Design Principles
SSIS 2019, 2017 : SSIS DB Installations

SSIS Database, Catalog Folders, Storage
SSIS Catalog Database (SSIS DB) Creation
SQL Server Data Tools - SSDT / Visual Studio
SSDT Installation and Catalog Verification
SSIS, ETL, DWH, Data Flow, Data Buffer
SSIS Package Environment, SSDT Projects
SSIS & ETL Training - Lab Plan, Resources

Ch 1: SSRS INTRO, INSTALLATION

Reporting Operations and Report Types
Paginated Reports, Interactive Reports
Analytical Reports & Mobile Reports
Reporting Solutions (SSRS) and Tools
Report Engine Architecture, Databases
SSRS Report Server Installation
Report Databases in SSRS and Usage
Web Service URL : Connections, Usage
Web Portal URL : Connections, Usage

ReportServerDB, TempDB Configuration
SQL Server Data Tools (SSDT)
Report Builder, Mobile Report Publisher
Report Design : Lab Plan, Data Sources
3-Phase Report Life Cycle (End-End)
Report Builder Versus Report Designer
Report Server, Web Service Integration

Ch 2: SSIS ETL PACKAGES: BASICS

Control Flow Tasks Architecture, Purpose
Data Flow Tasks Architecture, Purpose
SSIS Packages @ Basic Data Flow, ETL
SSIS Projects and Package Creation
Data Pipelines in Data Flow Tasks
SSIS Packages Execution Process
Data Flow Objects, OLE DB Connections
SSIS Package Creation - Control Flow

DTSX Files for Package Execution
SSIS Execution, Package Errors & Logs
SSIS Transformation: Conditional Split
Excel Connection and Memory Reference
Source and Destination Assistants
DAT File Imports and Annotations
SSIS Project Configurations, Debugging
SSIS 64 Bit, 32 Bit Configurations

Ch 2: BASIC REPORT DESIGN

Working with SQL Server Data Tools
Report Templates and Project, Solution
Basic Reports - Understanding Entities
Report Project Wizard Usage, Reports
Data Source Connections and Databases
Query Designer, Query Builder, Imports
Table, Matrix Reports with Report Wizard
Layout, Format - Drilldown Reports, Blocks

Stepped Reports, Multi Field Drilldowns
Report Template - Datasets & Reports
Table Headers & Formatting Expressions
Alternate Row Colors, Global Expressions
Formatting Styles, Expressions, Reusability
Expressions: IIF,Format,Ceiling,Round
Textbox Properties: Date Format, Numbers
Report Sources, Static/Dynamic Properties

Ch 3: MERGE & FUZZY LOOKUP

MERGE and UNION ALL Transformations
SORT, NOSORT and Advanced Sort
Synchronous, Asynchronous Tfns
Row, Partial Blocking Transformations
Fully Blocking Transformations - Buffers
Avoiding Fully Blocking Transformation
Bulk Load Operations, SSIS Data Imports
IsSorted & SortKey Position Options
SSIS Package Performance & Resources

Data Conversion Expressions
Fuzzy Lookup Transformation, References
Nomatch Cleansing @ Conditional Split
Index Creations, Lookup Transformation
Data Conversion, Derived Columns
Varchar, Nvarchar, Error Redirections
Threshold Values, Search Delimiters
_Similarity, _Confidence Columns

Ch 3: GROUPING, REPORT PARAMETERS

Grouping : Row Groups, Column Groups
Row Groups, Parent - Child Groups
Adding Groups to Existing & New Rows
Group Headers & Footers, Sub Totals
Field Visibility, Toggle with Parent
Row Group, Header/Footer Properties
Column Groups for Table Report, Options
Drill-down Report, Row Groups, Visibility
Column Group Advance Mode. Fixed Values

Repeating Column Headers on Every Page
Creating Parameters, Dataset Conditions
Single Value and Multi Value Parameters
Dynamic Parameters, Dependency Queries
SSRS Parameters with Dynamic Conditions
Dataset Links to Parameters, List Values
SSRS Expressions, Global Fields, Values
Advanced Options : Auto / Manual Refresh

Ch 4: SSIS CHECKPOINT & PIVOT

Execute SQL Task and OLE DB Queries
Transaction Options For SSIS Executables
Precedence - Success/Failure/Completion
SSIS Package Rollbacks Execution Options
Checkpoints Purpose with Data Flow Tasks
Checkpoint Files and SSIS Logging Tasks
Transactions with Checkpoint File in SSIS
Checkpoint Option Advantages, Limitations
FailPackageOnFailure, Checkpoint Property
REQUIRED/SUPPORT/ NOTSUPPORTED
Transaction Property, CHECKPOINT Files

Legacy Data, Data Cleansing, Formatting
Denormalization, Keys. Need for OLTP
PIVOT Transformation, Connection Assistant
Pivot Usage - Implementation. Key Values
Lineage ID - Purpose. Data Mappings
Lineage IDs for Column Mapping, Pivot Keys
SSIS Input Columns and Mappings
Data Viewer : Data Transfer Verification
Data Type Conversions, Error Redirection

Ch 4: CHARTS, DASHBOARDS, FITLERS

Chart Reports - Design, Properties
Series Values and Category Groups
Report Categories with Series Groups
Report Category Types and Differences
Visualizations: Trend, Discrete Chart
Clustered, Non Clustered Attributes
Series Labels: Properties, Formatting
Series Actions: Multi - Valued Parameters
Report Actions: URL, Report Filters

Dashboards : Creation and Real-time Use
Multiple Chart Areas, Legends in Charts
Dashboard Exports and Report Filters
Static and Parameterized Report Filters
Series, Markers Chart Areas, Limitations
3-Dimensional Report Properties, Visibility
Range Charts, Data Bars, Area Charts
Report Actions with Parameters, Joins
Dataset and Toolbox Filters, Bookmarks
Filters Vs Parameters - Difference
Filter Conditions in Dataset, Toolbox

Ch 5: EVENTS, LOOPS, EXPRESSIONS

SSIS Package Events, Validation, Execution
PreExecution, Progress, Cleanup Events
SSIS Events, Errors/Warnings/Information
Configuring sysssislog System Tables
Debugging : Data Viewers and Breakpoints
ForEach Loop Container. File Connections
Variables For Linking DFT, Control Flow
Dynamic Connections with Variables
Iterations, Fetch, Index Mapping

SSIS Expressions for ETL and DWH
FOR LOOP Expressions in SSIS
Init/EvalExpression, AssignExpression
SSIS Expressions, Functions, Values
Data Insertions, Data Serializations
Counter Values, Variables & Parameters
SSIS for OS Level Operations, Loops
Execute SQL Task : Return Values

Ch 5: EXPRESSIONS, SHARED DATASETS

Shared Data Sources, Shared DataSets
Date-Time Expressions with RDL Files
FORMAT Function in SSRS, Parameters
Data Type Conversions, Int / String Types
String Functions, Page Breaks in SSRS
LOOKUP Function, Dataset Joins in SSRS
Field Value Replacement with Datasets
Using LIST Item from SSRS Toolbox
Field Expressions and Field Properties

#VALX, #VALY, #PERCENT, #SERIES
#LABEL, #AXISLABEL, #LEGENDTEXT
3D Pie Charts, Funnel and Tree Map
3D Funnel, Sunburst, Shape Charts
Doughnut, Pyramid, 3D Pyramid Reports
Parameterized Gauge Reports - Filters
Indicators : Value, State Expressions
RDL Expressions, Custom Functions

Ch 6: SSIS with ETL, Warehouse (DWH)

OLTP Database : Historical Data Loads
Data Warehouse (DWH) Purpose, Usage
Dimensions, Attributes, Members Types
Dimension Tables, Fact Tables Design
TYPE1 and TYPE2 ETL Implementation
SCD Type1, Type 2 for DWH in Sales
Inferred Members and Legacy Loads
Initial Data Loads with Data Marts
Business Keys & non Identity Columns

Surrogate Keys, Alternate Business Keys
Cascading OLTP / Stage to DWH Rows
Fixed Attributes, Changing Attributes
Historical Attributes. Inferred Updates
ETL Date, Row Status Transformations
Attribute Key Types in SCD, Limitations
Historical Attributes and Data Delta
SSIS Connection Assistants - Reuse
SCD Transformations in Real-time

Ch 6: REPORT BUILDER, GAUGES

Report Builder Installation & Usage
Differences with Report Designer Tool
Data Source Creation with Report Builder
Dataset Creation with Report Builder
Dataset Design with Parameters, Filters
Query Designer with Report Builder
Toolbox Items Insertion and Properties
Column Aggregates, Auto Group By Edits
Adhoc Reports with Column Groups

Dynamic Row Colors, Report Expression
Gauge Reports: End User Access
Report Types - Radial, Linear Gauges
Indicators, Pointers, Scale Ranges
Browser Compatibility, Offline Reports
Gauge, Gauge Panel Properties, Filters
Scale Properties, Values, Label Options
Ranges & Labels, Items, Needle Options
Parameterized Gauge Reports, Datasets

Ch 7: Checksum & DWH Design

Checksum Transformation in ETL Loads
Configuring Checksum: SSIS 2019, 2017
Transformation Logic, Parity Checks CRC
Checksum For Type I, Type II ETL DWH
DWH Dimension Tables With Checksum
Lookup Transformation, Row Redirection
OLE DB Command and Input Parameters
Parameter Mapping, Dynamic Updates

Cache Transformation CAW Memory Files
Memory Connection Lookup with Cache
Tuning Lookup: Caching, Index Options
Pre-ETL Activities, DB Recovery Models
FULL/ PARTIAL CACHE & NOCACHE
Performance Tuning and Pre-ETL Loads
Dependent Data Flow Tasks, Post ETL
Internal Parameters and Query Updates
Cache Allocation Options with ETL DWH

Ch 7: REPORT BUILDER, MAP REPORTS

Map Reports - Map Layers and Map Items
Map Gallery - ESRI Share Files (Geo Data)
SQL Server Data Sources, Geo Spatial data
Business Analysis Dashboards For Maps
Polygon, Tile, Line and Point Map Layer
Map Visualization and Bubble Map Reports
Data Fields, Labels, Visualization Indicators
Fields to Visualize, Color Rules and Labels

Editing Report Builder Reports in Designer
SSRS Deployment: Report Designer Reports
SSRS Deployment: Report Builder Reports
Report Deployment - Builds, Config Files
Webservice URL, Webportal URL Access
Data Source, Data Set Folders, Report URL
Deployment of Shared Data Sources
Deployment of Shared Datasets, Reports
Report Manager Uploads for RDL Files

Ch 8: CDC Transformations for DWH

DML Audits with Change Data Capture
CDC Tables with SQL Server Connections
CDC Connections & ADO.NET Integration
CDC Control Flow and CDC State Values
INITIAL LOADS & PRCESSING RANGE
State Variables, Net Changes, Logging
Initial & Incremental Dimension Loads
Dynamic CDC Control, OLEDB Command
Internal Parameters and Usage Options

Parameter Mapping For ETL Type1, Type2
Integrating Control Flow for CDC @ ETL
CDC Splitter - Row Inserts, Updates
CDC Precautions, Input & Output Range
Derived Column Transformations with CDC
Limitations of ADO.NET Connections
Master Child Packages,Parameter Binding
Package Passwords, Project Parameters
Project Configuration Options(32,64 bit)

Ch 8: REPORT MANAGEMENT

Data Source Management, Subscriptions
Dependant Items, Security Operations
Edit Shared Data Sources in Web Portal
Shared Data Source Enable and Hide
Connection Types, Edits and Security
Shared Dataset Operations: Report Edits
Data Preview, Downloads, Link Reports
Report Security: Browser Role, User Access
Content Management, My Reports, Publisher

Report Builder, Report Definitions, Uploads
Report Tuning: Caching, Rebuilds, Refresh
Report Tuning: Report Snapshot, Schedules
Subscriptions: Standard and Data Driven
Email and File share Subscriptions in SSRS
Schedules and Report Delivery Options
Report Server Settings, Shared Schedules
Report Timeout, Report Parts and Publish
Report Builder Sub Reports, Report Parts

Ch 9: Fact Table Design, DWH Loads

Fact Table - Design and ER Model
DWH : STAR & SNOWFLAKE Schemas
Time Dimensions and ETL Date / Time
Link Time Dimension to Facts, Lookups
Parent-Child Packages for Fact Loads
Inferred Members for NULL Dimensions
SCD Wizard for DWH Fact Table Design

Parameter Mapping for Incr Updates
ETL Load IDs - Dimension Attributes
Error Handling, Event Handling in SSIS
Text Qualifiers with Flat File Sources
Fact Load Design for Initial, Incr Loads
End-to-End DWH Design Implementation
Direct Data Loads and Staging Tables
Fact Table Staging and Incr Updates

Ch 9: MOBILE, KPI, CUBE REPORTS

Mobile Reports : Creation & Usage
Excel and Report Server Sources
Working with Mobile Report Publisher
Elements Layout: Master, Tablet
Grids and Color Palette. Deployment
RSMobile Formats: Uploads, Downloads
Shared Dataset in Report Builder Tool

KPI Reports: Design from Web Portal
KPI: Value, Goal, Status, Trend
KPI Visuals: Bar, Line, Step, Area
Custom URLs and Mobile Reports
Cube Reports with SSAS MDX, DAX
SSRS Cube Reports with Parameters
MDX Default Parameters, Options
SSAS OLAP Cube Actions with SSRS

Ch 10: DWH MIGRATIONS, SCRIPT Task

DataWarehouse Migrations with SSIS
Using SSIS Containers, Db Integrity Task
Pre-Database Migration Task Precautions
Online and Offline DB Transfer Options
Copy / Move with DWH Migrations
SMTP : Simple Mail Transfer Protocol
SQL Server Agent and Package Events
Data Profiling with ADO.NET Connectors

XML Files & SSIS Data Profiler Tool
Script Task - Working in SSIS Control Flow
Script Task - VB.NET Program Compilations
Variables, Parameters with SSIS Script Task
Read Only, Read Write Variable Expressions
Expressions and Debugging, Break Points
Variables, Parameters Mapping Expressions
File System Tasks and Limitations
SQLDataAdapters & System.Data.SQLClient

Ch 10: PROJECT WORK in SSRS

SQL Server Data Sources and Datasets
Designing RDL [Paginated], Expressions
Chart Reports, Line Reports, Options
Dataset with Parameters and Filters
Trend Analysis, Continuous Data Reports
Data Bar Reports and Stacked Reports
Multi-series Charts, Dynamic Chart Size
Axis Display Control : Paginated Reports
Parameters and Filters - When to use which

Complete Project Solution & Explanation
Work Flow Operations and Report Types
Report Design, Builds, Report Deployment
Report Edits, Data Source Changes to Azure
Azure SQL Database for SSRS DB Source
Report Management, Security, Subscriptions
Report Tuning, Caching, Snapshot Options
Project FAQs and Explanations for Resume

Ch 11: SSIS DEPLOYMENTS, UPGRADES

SSISDB Catalog Deployments, ISPAC Files
Package Builds, Verification, Scripts
Project Deployment Wizard Targets, Logs
DB Catalog Folders & Projects Creation
Package Executions - Scripts, Reports
Package Validations, 32/64 bit Options
Configurations & Parameter Management
Package Jobs @ SQL Agent. Job Steps

Job Schedules and Notifications Event Logs
Package Security - SSISDB Logins, Users
Folder Level and Project Level Security
Project Migration Utilities, Upgrades
Package Imports, Exports with ISPAC Files
Command-Line Deployment,Execution Utility
Package Execution & Validation Reports
Package Versions and Restores, Rollbacks

End to End Implementation (Real-time)

End to End MSBI Implementation Process
Project Requirements and SDLC Life Cycle
Database Design and Entity Selection
Understanding OLTP Databases, Relations
Design of DWH : Data Warehouse Database
SCD Techniques for ETL, Dimension Loads
Fact Loads, STAR / SNOWFLAKE Schemas
DWH Database Limitations for Analysis

OLAP Databases for Data Analysis
Cube Design and Operational Modes
Mode Selection and Capacity Planning
Tabular Mode OLAP Cube: Advantages
Excel Analysis and Reports with MDX
Using DAX for Modeling, Cube Reports
Paginated Reports with OLAP, DWH
MSBI Limitations, Need for Azure BI

Ch 12: Realtime Project for SSIS & DWH

MSBI Resume Guidance, Interview FAQs

Module 3: MSBI-SSAS Training [For MSBI Plan C]

Chapter 1: Tabular Mode Introduction

Databases : Types; OLTP, OLAP, DWH
Need for OLAP Databases and Cubes
OLTP versus OLAP Databases
DWH versus OLAP Databases
SQL Server Components & Features
SQL Server Analysis Services (SSAS)
SSAS Modes of Implementation
Tabular Mode: Advantages

Tabular Mode for OLAP Databases
SQL Server (Instance) Installation
Tabular Mode Server Installation
Management Studio (SSMS) Installation
Tabular Mode Server Connections
Server Properties; Data Directories
Visual Studio Tool: Purpose, Installation

Chapter 5: Cube Deployment & MDX

OLAP Cube Deployments: Phases
Builds and Rebuilds - Output Results
Deployment Phase & Process Phase
Processing Options; Transactions
Processing Options : Donot Process
Deploy All and Deploy Changes Only
Cube Processsing Modes: In-Memory
Direct Query Options For Deployment

Cube Access from SSMS : Cube Browser
XMLA Scripts : OLAP DB Scripting
MDX: Multi Dimensional Expressions
MDX Queries : Auto & Manual Modes
MDX Queries: ORDER, TOP, WHERE
MDX Queries: MEMBERS, FILTERS
Generating MDX Queries from SSMS

Chapter 9: DAX - Level 4

Statistical DAX Functions
COUNTROWS, COUNTX
DISTINCTCOUNT
COUNTBLANK
COUNT, COUNTA
MIN, MINA & MINX
MAX, MAXA & MAXA
AVERAGE, AVERAGEA, AVERAGEX

Parent and Child Functions
PATH, PATHITEM
PATHCONTAINS
PATHLENGTH
Math & Trig Functions
SUM Vs SUMX

Chapter 2: Tabular Mode Cube Design

Using Visual Studio Tool : Tabular Mode
Cube Design - BISM and Explorer
Workspace and In-Memory Database
Cube Architecture: Measure Groups
Measures and Aggregations in Cube
Dimension Tables and Realtime Use
Attributes (Columns) and Members
Data Models For Cube Design

Data Source : Creations; Data Imports
Entity Selection and Data Source View
Data Models : Entity Relationships
Adding and Editing Relationships
Aggregated Measures and Attributes
Identify Measure Groups, Dimensions
Analyse in Excel. Cube Reports

Chapter 6: DAX - Level 1

DAX: Data Analysis Expressions
Role of DAX in Data Analytics
Implementations of DAX in OLAP
DAX : Entities & Naming Format
DAX Data Types and Operators
DAX Expressions : Purpose, Usage
DAX Queries: Purpose, Usage
DAX Functions : High Level Usage

DAX Expressions : Calculated Columns
DAX Column for Cube Design
ISBLANK() and IF() Functions
CALCUALTE () and SUM Functions
Understanding DAX Measures
Column Operations and Data Types
Calculation Operations, In-Memory

Chapter 10: DAX - Level 3

Time Intelligence Functions
OPENINGBALANCEMONTH
OPENINGBALANCEQUARTER
OPENINGBALANCEYEAR
CLOSINGBALANCEMONTH
CLOSINGBALANCEQUARTER
CLOSINGBALANCEYEAR
PREVIOUSDAY, PREVIOUSMONTH

FIRSTNONBLANK, NEXTMONTH
PREVIOUSQUARTER
TOTALMTD, TOTALQTD
TOTALYTD, NEXTDAY
PARALLELPERIOD
SAMEPERIODLASTYEAR

Chapter 3: Cube Objects

OLAP Cube Design Concepts
OLAP Cube Objects in Tabular Mode
Understanding Grid View
Grid View Versus Relation View
Insert / Rename / Freeze Columns
Relationship Edits and Rules
Hierarchies: Creation & Precautions
Hierarchies Usage for Data Analytics

Perspectives : Purpose & Creation
Using Hierarchies and Perspectives
Excel Analytics with Hierarchies
Excel Analytics with Perspectives
Cube Partitions: Creation with SQL
Entity Partitions and Tuning Concepts
Grouping Entities - Snowflake

Chapter 7: DAX - Level 2

DAX Functions and Real-time Use
Filter Functions in DAX
ALL, ALLSELECTED
ALLEXCEPT, CALCULATE
CALCULATETABLE, FILTER
LOOKUPVALUE, OFFSET
Calculation Groups and Use
Cube Calculations & Deployments

Table Manipulation DAX Functions
ADDCOLUMNS & SUMMARIZE
GROUPBY, DATATABLE
UNION, EXCEPT
INTERSECT, ROW
NATURALINNERJOIN
NATURALOUTERJOIN

Chapter 11: DAX - Level 4

Date & Time Functions
CALENDAR, CALENDARAUTO
DATE, DATEDIFF, TIME
DATEVALUE, NOW
DAY, YEAR, MONTH
QUARTER, HOUR
MINUTE, SECOND
EDATE, EOMONTH

DAX Calculations with Joins
KPI: Key Performance Indicator
Using KPIs with DAX Concepts
Using KPIs with MDX Queries
KPIs Versus DAX Calculations
Translations & Cube Access

Chapter 4: CUBE Data Models

Data Modelling Concepts @ Databases
Data Models with OLAP Databases
Dimensions & Fact Table Identification
STAR Schema : Design Patterns
STAR Schema : Advantages & Cautions
SNOWFLAKE Schema : Design Patterns
STAR Versus SNOWFLAKE Schemas
OLTP Database Sources for OLAP

Cube Design with STAR Schema
STAR Schema Data Models with OLAP
SNOWFLAKE Data Models with OLAP
Snowflake Schema : Data Sources
Snowflake Schema : Cube Design
Azure Data Sources with OLAP Cubes
Using Azure SQL Databases with STAR

Chapter 8: DAX - Level 3

Logical DAX Functions
IFERROR, SWITCH
IF and AND (&&)
OR(||), NOT
COALESCE
USERPRINCIPALNAME()
USERELATIONSHIP
RELATEDTABLE

Text DAX Functions
UPPER, LOWER
LEFT, RIGHT, LEN
CONCATENATE
CONCATENATEX
ROW, SEARCH, REPT
MID, FIND, EXACT

Chapter 12: Power BI Integrations

Using OLAP Cubes with Power BI
Storage Modes, Power BI In-Memory
Import and Connect LIVE Options
Creating Calendar Table in Power BI
Cumulative Total/ Running Total
Display Top Products for each region
DAX shortcuts in Power BI Desktop
Performance Advantages with OLAP

MDX Queries with SSMS Tool
Using MDX and DAX in Power BI
RLS: Row Level Security & DAX
Implementing RLS in Tabular Mode
Implementing RLS in Power BI
DAX Expressions for RLS

MSBI / DW (SSIS, SSAS, SSRS) Training Course : Free Demo

Participants may join for complete MSBI (SSIS, SSAS, SSRS) Course or for individual modules. Practical, Real-time.

New batch for MSBI Training (LIVE, Instructor Led) start every 15 days. Register Today

All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Wise Tasks and 24x7 LIVE Server.

SQL Server T-SQL, Azure SQL, Azure DBA, Azure BI, Azure Data Engineer, Power BI Training

Online Video

Online Video

Online Video

Online Video

Online Video

Online Video

Online Video

Online Video

Online Video

Online Register

Details Register

Online Register

Online Video

Details Register

Microsoft Business Intelligence - MSBI Online Training (LIVE, Instructor-Led)

MSBI (SSIS, SSAS, SSRS) Training Plans

MSBI Training (SSIS, SSAS, SSRS) Curriculum:

Ch 1: DATABASE INTRODUCTION

Ch 5: SQL Basics - 3, TSQL INTRO

Ch 9: Functions, Procedures Basics

Ch 2: SQL SERVER INSTALLATION

Ch 6: Constraints, Index Basics

Ch 10: TRIGGERS & TRANSACTIONS

Ch 3: SSMS Tool, SQL BASICS - 1

Ch 7: Joins Basics, TSQL Queries

Ch 11: Normal Forms, Cursors

Ch 4: SQL BASICS - 2

Ch 8: Group By, Views & Excel

Ch 12: TSQL Merge, Cursors

SQL Server Integration Services (SSIS)

SQL Server Reporting Services (SSRS)

Ch 1: SSIS INTRO, INSTALLATION

Ch 1: SSRS INTRO, INSTALLATION

Ch 2: SSIS ETL PACKAGES: BASICS

Ch 2: BASIC REPORT DESIGN

Ch 3: MERGE & FUZZY LOOKUP

Ch 3: GROUPING, REPORT PARAMETERS

Ch 4: SSIS CHECKPOINT & PIVOT

Ch 4: CHARTS, DASHBOARDS, FITLERS

Ch 5: EVENTS, LOOPS, EXPRESSIONS

Ch 5: EXPRESSIONS, SHARED DATASETS

Ch 6: SSIS with ETL, Warehouse (DWH)

Ch 6: REPORT BUILDER, GAUGES

Ch 7: Checksum & DWH Design

Ch 7: REPORT BUILDER, MAP REPORTS

Ch 8: CDC Transformations for DWH

Ch 8: REPORT MANAGEMENT

Ch 9: Fact Table Design, DWH Loads

Ch 9: MOBILE, KPI, CUBE REPORTS

Ch 10: DWH MIGRATIONS, SCRIPT Task

Ch 10: PROJECT WORK in SSRS

Ch 11: SSIS DEPLOYMENTS, UPGRADES

End to End Implementation (Real-time)

Chapter 1: Tabular Mode Introduction

Chapter 5: Cube Deployment & MDX

Chapter 9: DAX - Level 4

Chapter 2: Tabular Mode Cube Design

Chapter 6: DAX - Level 1

Chapter 10: DAX - Level 3

Chapter 3: Cube Objects

Chapter 7: DAX - Level 2

Chapter 11: DAX - Level 4

Chapter 4: CUBE Data Models

Chapter 8: DAX - Level 3

Chapter 12: Power BI Integrations

SQL Server T-SQL, Azure SQL, Azure DBA, Azure BI, Azure Data Engineer, Power BI Training

For latest schedules Click Here