Skip to main content

#MSBI

MSBI (Microsoft Business Intelligence) is an All-in-one solution for end-to-end data analysis and reporting. It includes SSIS for data integration, SSAS for data modeling, and SSRS for reporting and visualization. Learning MSBI can land you in demand roles like BI Developer, Data Analyst, and Report Developer.

Training Schedules

S NoTime (IST, Mon - Fri)Start Date
16 AM - 7 AMAug 5th
28 PM - 9 PMAug 18th
MSBI Training Highlights

MSBI Training (SSIS, SSAS, SSRS)
Curriculum:

Module 1 : Microsoft SQL (TSQL)

Ch 1: SQL SERVER INTRODUCTION

  • Database Introduction
  •  Types of Databases
  •  Need for & ETL, DWH
  •  BI Implementations
  •  SQL Server Advantages
  •  Version, Editions of MSSQL
  •  Data Analyst Job Roles

Ch 2: SQL SERVER INSTALLATIONS

  • SQL Server 2019, 2017
  • SSMS Tools Installation
  • Database Engine (OLTP)
  • SCM, Configuration Tools
  • Instance Types, Uses
  • Authentication Modes
  • Collation, File Stream

Ch 3: SQL BASICS – 1

  • Need for Databases, Tables
  • Need for SQL Commands
  • DDL, DML & DQL Statements
  • Database Creation @ GUI
  • Data Operations @ GUI
  • Session ID, SQL Context
  • DB, Tables, Data @ SQL

Ch 4: SQL BASICS – 2

  • DDL Variants in MSSQL
  • DML Variants in MSSQL
  • INSERT & INSERT INTO
  • SELECT & SELECT INTO
  • Basic Operators in SQL
  • Special Operators in MSSQL
  • ALTER, ADD, TRUNCATE, DROP

Ch 5: Data Imports, Schemas

  • Data Imports with Excel
  •  ORDER BY & UNION
  • UNION ALL For Sorting Data
  •  Creating, Using Schemas
  •  Real-world Banking Database
  •  Table Migrations @ Schemas
  •  2 Part, 3 Part & 4 Part Naming

Ch 6 : Constraints, Index Basics

  • Need for Constraints, Keys
  •  NULL, NOT NULL, UNIQUE
  •  Primary Key & Foreign Key
  •  RDBMS and ER Models
  •  Identity Property, Default
  •  Clustered Index, Primary Key
  •  Non Clustered Index, Unique

Ch 7: Joins & Views Basics

  • JOINS: Purpose. Inner Joins
  • Left / Right / Full Outer Joins
  • Cross Joins, Query Tuning
  • Creating & Using Views
  • DML, SELECT with Views
  • RLS : WITH CHECK OPTION
  • System Views & Metadata

Ch 8: Functions(UDF), Data Types

  • Using Functions in MSSQL
  •  Scalar Value Functions
  • Inline & Multiline Functions
  • Date & Time Functions
  • String, Aggregate Functions
  • Data Types : Integer, Char, Bit
  • SQL Variant, Timestamp, Date

Ch 9: Stored Procedures,Models

  • Stored Procedures & Usage
  • Creating, Testing Procedures
  • Encryption, Deferred Names
  • SPs for Validations, Analysis
  • System SPs, Recompilation
  • Normal Forms & Types
  • Data Models, Self-References

Ch 10: Triggers, Temp Tables

  • Need for Triggers
  • DDL & DML Triggers
  • Using Memory Tables
  • Data Replication, Automation
  • Local & Global Temp Tables
  • Testing & Using Temp Tables
  • SELECT .. INTO & Bulk Loads

Ch 11: DB Architecture, Locks

  • Planning VLDBs : Files, Sizing
  • Filegroups, Extents & Types
  • Log Files : VLF, Mini LSN
  •  Table Location, Performance
  • Schemas, Transfer, Synonyms
  • Transactions Types, Lock Hint
  •  Query Blocking Scenarios

Ch 12 : Cursors & CTEs, Links

  • Cursors : Realtime Use
  • Fetch & Access Cursor Rows
  • CTEs for SELECT, DML
  • CTEs: Scenarios & Tuning
  • Linked Servers, Remote Joins
  • Linked Servers: MSDTC, RPC
  • Tuning Remote Queries

Ch 13: Merge, Upsert & Rank

  • Need for Merge in ETL
  • Incremental Loads with SQL
  • MERGE and RANK Functions
  • Window Functions, Partition
  • Identify, Remove Duplicates

Ch 14: Grouping & Cube

  • Group By & HAVING
  • Cube, Rollup & Grouping
  • Joins with Group By
  • 3 Table, 4 Table Joins
  • Query Execution Order

Ch 15: Self Joins, Excel Analysis

  • Self Joins & Self References
  •  UNION, UNION ALL
  •  Sub Queries with Joins
  •  IIF, CASE, EXISTS Statements
  •  Excel Analytics, Pivot Reports

Case Study 1 –
For Database, Table Design (Constraints, Keys)

Case Study 2 –
For Query Writing + Window Functions
(Rank, RowNumber)

Course 2 : MSBI (SSIS, SSAS, SSRS)

SQL Server Integration Services (SSIS)

Ch 1: MSBI Introduction

  • ETL & DWH basics
  • SSIS need & use
  • SSDT installation guide
  • MSBI tool overview
  • Catalog configuration

Ch 2: Cube Design

  • Visual Studio tabular
  • Cube, measure groups
  • Dimensions and members
  • In-memory workspace

Ch 3: Merge & Fuzzy Lookup

  • Merge & union all
  • Sort vs NoSort
  • Data cleansing logic
  • Fuzzy lookup & splits
  • Thresholds & redirects

Ch 4: Checkpoints, Pivot

  • Checkpoint files, rollback
  • Pivot, denormalization logic
  • Transactions in SSIS
  • Breakpoint vs checkpoint
  • Data flow mapping

Ch 5: Events, Loops, Expressions

  • Event handlers, audits
  • SSIS variables, params
  • Expressions in control flow
  • Logging and debugging
  • Looping techniques

Ch 6: DWH Data Loads

  • OLTP data reads
  • ETL and SCD types
  • Delta & historical loads
  • Parent-child packaging
  • Load types in DWH

Ch 7: Checksum & DWH Design

  • Checksum transformations
  • Lookup with redirection
  • Dynamic updates, mapping
  • DWH table checksum
  • Transaction settings

Ch 8: CDC Transformations

  • Change Data Capture
  • ADO.NET CDC links
  • Initial/incremental loads
  • CDC state management
  • Audits & logging

Ch 9: Fact Table Design

  • Fact & time tables
  • Star/snowflake schemas
  • SCD wizard for facts
  • Parent-child ETL flow
  • Inferred dimension logic

Chapter 10: Fact Table Design

  • Fact & time tables
  • Star/snowflake schemas
  • SCD wizard for facts
  • Parent-child ETL flow
  • Inferred dimension logic

Ch 11: SSIS Deployments

  • ISPAC builds & scripts
  • Catalog projects & folders
  • 32/64-bit validations
  • Execution logs, reports
  • Parameter management

Ch 12: SSIS Project

  • Star/snowflake ETL design
  • E-commerce project domain
  • Business keys & facts
  • Containers for loads
  • Look up with integrity

SQL Server Analysis Services (SSAS)

Ch 1: Tabular Mode Intro

  • OLTP vs OLAP
  • OLAP cubes need
  • SSAS modes overview
  • DWH vs OLAP

Ch 2: Cube Design

  • Visual Studio tabular
  • Cube, measure groups
  • Dimensions and members
  • In-memory workspace

Ch 3: Cube Objects

  • OLAP grid view
  • Hierarchies in cubes
  • Column operations
  • Perspectives overview

Ch 4: Data Models

  • STAR schema design
  • Fact vs dimension
  • Snowflake model use
  • Schema comparisons

Ch 5: Deployment & MDX

  • Cube deployment phases
  • Processing modes
  • Direct query use
  • Build/rebuild options

Ch 6: DAX – Level 1

  • DAX for cubes
  • Entities, syntax basics
  • Calculated columns
  • Query structure

Ch 7: DAX – Level 2

  • Filters, calculate
  • Table functions
  • LOOKUP, UNION
  • Calculation group

Ch 8: DAX – Level 3

  • Logical functions
  • Text handling
  • User functions
  • Row, search tools

Ch 9: DAX – Level 4

  • COUNTX vs COUNTA
  • SUM vs SUMX
  • Parent-child paths
  • Aggregation logic

Ch 10: DAX – Level 5

  • Time intelligence
  • YTD, MTD logic
  • Period functions
  • Opening/closing metrics

Ch 11: DAX – Level 6

  • Calendar functions
  • Date/time usage
  • KPI with DAX
  • Join calculations

 Ch 12: Power BI Link

  • Connect OLAP cubes
  • Storage modes, import
  • Calendar, top products
  • DAX in Power BI

SQL Server Reporting Services (SSRS)

Ch 1: SSRS Intro

  • Report types
  • Engine architecture
  • Server install steps
  • Report databases

Ch 2: Basic Reports

  • Report wizard usage
  • SQL data tools
  • Data sources setup
  • Table/matrix reports

Ch 3: Grouping & Params

  • Row/column groups
  • Group headers/footers
  • Drill-down visibility
  • Toggle options

Ch 4: Charts & Filters

  • Chart types, properties
  • Category groups
  • Clustered attributes

Ch 5: Expressions & Datasets

  • Shared datasets
  • Format and convert
  • LOOKUP & joins

Ch 6: Report Builder

  • Builder vs Designer
  • Dataset filters
  • Toolbox features

Ch 7: Map Reports

  • ESRI maps
  • Map layers/items
  • Geo dashboards
  • Bubble maps

Ch 8: Report Management

  • Subscriptions
  • Web portal access
  • Security settings
  • Shared dataset usage

Ch 9: Mobile, KPI Reports

  • Mobile layouts
  • Excel integration
  • KPI metrics
  • Dataset reusability

Ch 10: SSRS Project Work

  • RDL expressions
  • Line/trend reports
  • Multi-series visuals
  • Filters with datasets

Ch 11: End-to-End Project

  • Azure deployment
  • Tuning & caching
  • OLAP integration
  • Security roles

Ch 12: Power BI Link

  • Connect OLAP cubes
  • Storage modes, import
  • Calendar, top products
  • DAX in Power BI

Module 3: Power BI

Ch 1 : Power BI Introduction

  • Reporting Basics & Types
  • Interactive,Analytical Reports
  • Paginated Reports (RDL)
  • Power BI Eco System
  • Power BI Tools,Service,Server
  • Need for Power Query (M)
  • Need for DAX & Cloud

Ch 2: Power BI Basic Reports

  • Power BI Desktop Installation
  • Basic Report Design (PBIX)
  • Data View, Data Models
  • Data Points, Aggregations
  • Focus Mode, Spotlight, Exports
  • ToolTip, PBIX and PBIT
  • Visual Interactions & Edits

Ch 3 : Grouping, Hierarchies

  • Creating Groups in Power BI
  • Groups : Creation & Usage
  • Group Edits Options
  • Bins & Bin Size, Bin Count
  • Hierarchies: Creation, Use
  • Drill Down, Drill Up
  • Conditional Drill Down

Ch 4 : Visual Sync, Filters

  • Slicer & Single Select
  • Multi Select Options
  • Integer, Character Slicers
  • Visual Sync with Slicers
  • Filters: Visual, Page, Report
  • Drill Thru Filters & Usage
  • Basic, Top & Advanced
  • Clear Filter Options, Resets

Ch 5 : Bookmarks, Big Data

  • Bookmarks Creation & Usage
  • Visual Interactions, Bookmarks
  • Images : Actions, Bookmarks
  • Big Data Access with Power BI
  • Storage Modes: Direct Query
  • Import & Performance Impact
  • Formatting & Data Refresh
  • Summary, Date Time Formats

Ch 6 : Power BI Visualizations

  • Chart and Bar Visuals
  • Line and Area Charts
  • Maps, TreeMaps, HeatMaps
  • Funnel, Card, Multrow Card
  • PieCharts & Settings
  • Waterfall, Sentiment Colors
  • Scatter Chart, Play Axis
  • Infographics, Classifications

Ch 7 : Power Query Level 1

  • Power Query (Mashup)
  • ETL Transformations in PBI
  • Power Query Expressions
  • Table Combine Options
  • Merge, Union All Options
  • Table Transformations

Ch 8 : POWER QUERY LEVEL 2

  • Any Column Transformations
  • String / Text Transformations
  • Numeric Analytics & Mashup
  • Date Time Transformations
  • Add Column Transformations
  • Expressions and New Columns

Ch 9 : POWER QUERY LEVEL 3

  • Parameters in Power Query
  • Static Parameters, Defaults
  • Dynamic Dropdowns, Lists
  • Linking with Table Queries
  • Column From Examples
  • Step Edits, Type Conversions

Ch 10 : Power BI Cloud – 1

  • Power BI Cloud Concepts
  • Workspace Creation, Usag
  • Report Publish & Edits
  • Semantic Models in Realtime
  • Dashboard Creation, Usage
  • Clone, Share, Subscribe
  • Q&A, Lineage, Settings

Ch 11 : Power BI Cloud – 2

  • Data Gateways, Data Refresh
  • Data Source Configurations
  • Data Refresh & Scheduling
  • Gateway Optimizations
  • Semantic Model Optimizations
  • Report Optimizations
  • Dashboard Optimizations

Ch 12 : Power BI Cloud – 3

  • Power BI Apps, Shares
  • App Sections & Options
  • App Updates, Security
  • Excel Analytics
  • Data Explorer Option
  • Sharing, Subscriptions
  • Alerts, Metrics, Insights

Ch 13 : Report Server & DAX

  • Power BI Report Server
  • Report Database, TempDB
  • Web Service & Server URL
  • Paginated Reports (RDL)
  • Report Builder Tool Usage
  • DAX : Purpose, Realtime Use

Ch 14: DAX Level 2

  • DAX Measures Creation, Use
  • DAX Functions: IIF, ISBLANK
  • SUM, CALCULATE Functions
  • DAX Cheat Sheet : Examples
  • Quick Measures in Power BI
  • Running Totals, Filters

Ch 15 : DAX Level 3

  • Star Rating Calculations
  • Data Models & DAX
  • Star & Snowflake Schemas
  • Dimensions, Fact Tables
  • DAX Expressions & Joins
  • DAX Variables, Usage

Ch 16 : DAX Level 4

  • Dynamic Report with DAX
  • SELECTED MEMEBER
  • Time Intelligence with DAX
  • PARALLELPERIOD, DATE
  • DAX with Big Data
  • Big Data Analytics

Ch 17 : Realtime Project Phase 1

  • Project Requirement Spec
  • Understanding Data, Formats
  • Report Pattern Design
  • Report Design & Modelling
  • Power Query, DAX, Insights
  • Analytical Reports in Cloud

Ch 18 : Realtime Project Phase 2

  • Complete Project Solution
  • Project FAQs, Key Roles
  • Real-world Considerations
  • Power BI Admin Concepts
  • Resume Points, FAQs
  • PL 300 Exam Guidance

SQL SCHOOL

24x7 LIVE Online Server (Lab) with Real-time Databases.
Course includes ONE Real-time Project.

Advanced Excel Training FAQ's

What is MSBI Job Role?

An MSBI (Microsoft Business Intelligence) professional is responsible for designing, developing, and maintaining end-to-end BI solutions using the Microsoft SQL Server Business Intelligence suite, which includes SSIS (Integration Services), SSRS (Reporting Services), and SSAS (Analysis Services). The role involves creating ETL packages, reports, dashboards, cubes, and KPIs to help organizations make data-driven decisions.

What are the Job Roles of an MSBI Developer?

💼 Top Job Roles:

1️⃣ Design and build ETL processes using SSIS to load data from various sources
2️⃣ Create interactive reports and dashboards using SSRS
3️⃣ Develop OLAP cubes and data models using SSAS
4️⃣ Ensure data quality, consistency, and security across BI solutions
5️⃣ Collaborate with business users and analysts to gather reporting requirements
6️⃣ Optimize BI solutions for performance and scalability and more..!

What does our MSBI Training course contains?

The course is carefully curated with below module:
👉🏻Module 1: Microsoft SQL (TSQL)
👉🏻Module 2: MSBI
👉🏻Module 2: Power BI

Who can join this course?

  • Freshers looking to start a career in BI and data analytics

  • SQL developers wanting to expand into the BI stack

  • ETL and report developers seeking to master MSBI tools

  • Data analysts who want to work with cubes, KPIs, and dashboards

  • Anyone interested in building enterprise BI solutions

No prior coding experience is required. All concepts are taught from scratch

What training modes are available?

Option 1:        LIVE Online Training  (100% Interactive, step by step, assignments)

Option 2:        Self Paced Videos (100% practical, step by step with concept wise assignments)

You may choose any one of these options, same curriculum!

I (Trainer) shall be available for doubts and clarifications, assignment check and review.

Why should I choose SQL School for MSBI training?

👉🏻 Every session is Practical, Step by Step with Concept wise FAQs !!

👉🏻 100% results with on-time practice.  Daily Tasks for every session.

👉🏻 Concept wise tasks be submitted before next class for Job Waiters / Starters.

👉🏻 Concept wise tasks due for submission by Weekends for Working Professionals.

Why Choose SQL School

  • 100% Real-Time and Practical
  • ISO 9001:2008 Certified
  • Concept wise FAQs
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews
  • 24/7 LIVE Server Access
  • Realtime Project FAQs
  • Course Completion Certificate
  • Placement Assistance
  • Job Support
  • Realtime Project Solution
  • MS Certification Guidance