Master the Art of Business Intelligence with MSBI!
The MSBI Training Course equips you with the skills to integrate, analyze, and report data using SSIS, SSRS, and SSAS. Learn to design ETL solutions, create dynamic reports, and build OLAP models. By course completion, you’ll be able to develop end-to-end BI solutions that turn raw data into actionable insights.
Key Highlights:
- Comprehensive training on SSIS, SSRS, and SSAS.
- Hands-on projects to apply BI concepts to real-world scenarios.
- Learn to build ETL pipelines, reports, and analytical models.
- Ideal for professionals in business intelligence, data analytics, and reporting roles.
- Gain the expertise to manage large-scale BI implementations.
By the end of this course, you will have the expertise to design beautiful, functional, and user-friendly digital experiences that align with modern industry standards.
SSIS
Training content
Module 1: Introduction to ETL & SSIS architecture
o Introduction to ETL Concept
o ETL concepts&Varioustools available inmarket
o DTS introduction & evolution of SSIS
o SSISArchitecture
o Explain about various versions of SQL Server
o Introduction to SSISPackage and the tabs inside available
o Explain about Control Flow,Data Flow, EventHandler
o Consolidate data from multiple sources and process to load data to Datamart/ Data Warehouse
Module 2: Control Flow
o Control flow and itsusages
o Various Tasks of Controlflow
✓ Execute SQLTask
✓ Data Flow Task
✓ File System Task
✓ Execute PackageTask
✓ Send mailTask
✓ Script Task
o Containers
✓ For Loop Container
✓ For Each Loop Container
✓ Sequence Container
o Other MaintenanceTasks
Module 3: Data Flow
Source:
o OLEDB Source
o Excel Source
o Flat file Source
Transformations:
o Aggregate
o Audit
o Cache Transform
o Character Map
o Conditional Split
o Copy Column
o Data Conversion
o Data MiningQuery
o Derived Column
o Export Column
o Fuzzy Grouping
o Fuzzy Lookup
o ImportColumn
o Lookup
o Merge
o Merge Join
o Multicast
o OLE DB Command
o Percentage Sampling
o Pivot
o Row Count
o Row Sampling
o Script Component
o Slowly ChangingDimension
o Sort
o Term Extraction
o Term Lookup
o Union All
o Unpivot
Destination:
o OLEDB destination
o Excel destination
o Flat file destination
Module 4: Event Handlers
o Introduction to different handlers available
o Settingup ONError event handler
Module 5: Precedence Constraint
o Configuring the Precedence Constraint
Module 5: Variables and Expressions
o System Variables
o UserDefined Variables
o Configuring Variables
Module 5: Error Handling, Logging and Transactions
o EventHandler
o SSIS Logging
o transaction support and check point
Module 5: Execution , debugging and Protection
o Package execution
o Data Viewer /Breakpoints
o Package Protection
Module 5: Deployment
o Switching between projectand package deploymentmodes
o Deploying packagesto the SSISDB
o Running packagesfrom SQL Server
o Leveraging packageparameters
DATA WAREHOUSE
Training content
All Content
o What is Data Warehouse
o Introduction to Dimensions& Facts
o Surrogate Keyand its Usage
o DimensionalModel Introduction
o OLAP vsOLTP
o Star vs Snowflake Schema
o Create and workwith Data Model
o Introduction to Slowly Changing Dimension (SCD)
▪ Full HistoryMaintenance
▪ No History
▪ Partial History
o Types ofDimension
▪ Confirmed Dimension
▪ Role Playing Dimension
▪ Degenerated Dimension
o Types ofFacts
▪ Fact less Fact
o Full Load vs Incremental Load
SSAS
Training content
Introduction to SSAS
o Introduction to SSAS
o Multidimensional vsTabular
o Components of SSAS
Designing a SQL Server Analysis Services Database
o Components of Designing a Analysis Services Database
o Concept of Dimension
o Attributes and Hierarchy
o Concept of Cube
o Measures and Measure Groups
o Dimension Tables
o Fact Tables
o Star Schemaand Snowflake Schema
Design Dimension
o Defining AttributeRelationships
o Special DimensionTypes
o Slowly ChangingDimensions
DAX Queries
o Introduction to VariousDAX queries
o Writing most usefulDAX queries CALCULATE, FILTER, SUM, SUMX, EARLIER, LOOKUP etc.,
o Creating Time / StatisticalMeasures
Security, Partitions & Deployment
o Implementing Security forthe model
o Deployment process
o Performance tuning
SSRS
Training content
Reporting Life Cycle and Reporting architecture
o Introduction to SSAS
o Multidimensional vsTabular
o Components of SSAS
Building basic reports
o What is Reporting
o Reporting Life Cycle
o Reporting architecture and components
o Report Designer- BusinessIntelligence Development Studio
Design Dimension
o Serverreport
o Data source
o Data set
o Data regions – table, matrix, list, charts
o Adding existing report
o Grouping data,summations on groups
o Adjacent groups, textbox, image
o Subreports
o Formatting reports
o Page break
o Documentmap
o Parameters(Prompt)
o Report parameter values
o Datasetfor Report Parameter values
o Query Parameterto Dataset
o Builtin fields
Working with Expressions
o Adding calculations
o Adding calculated fields in dataset
o Text box expression
o Report itemexpression
o Builtin fields
o Aggregate functions
o Scope of argumento Aggregate function in data region
o Conditional formatting
Working with charts
o Creating charts
o Chart elements
o Chart types – Column, line, bar, area,scatter
o Creating Column charts
o Formatting chart
Report model
o Creating model
o Reviewing model
o Deploying report on server
Report Builder-ad hoc report
o Creating ad hoc reports using Report Builder
o Creating a table report
o Creatingmatrix report
o Creating chart reports
o Formatting a report
o Adding formulae
o Filter thereport
o Sorting data
