Book Online Tickets for Demo On MSBI -  MicroSoft Business Intel, Hyderabad. Build Expertise is a Global leader in training,development,and consulting services that helps participants learn new technology and keep themselves updated with the new developments. Build Expertise is formed by and of certified professionals with mo

Demo On MSBI - MicroSoft Business Intelligence Training @ BUILD EXPERTISE


Invite friends

Contact Us

Page Views : 30

About The Event

Build Expertise is a Global leader in training,development,and consulting services that helps participants learn new technology and keep themselves updated with the new developments. Build Expertise is formed by and of certified professionals with more than decade of industry experience.


MSBI stands for Microsoft Business Intelligence. MSBI is a powerful suite and is composed of tools which helps in providing best solutions for Business Intelligence and Data Mining Queries. MSBI empower users to gain access to accurate and up-to-date information for better decision making in an organization. This tool uses Visual studio along with SQL server and offers different tools for different processes which are required in Business Intelligence (BI) solutions.



SQL Server Integration Service- SSIS

Chapter-1 Introduction to BI and other BI tools

Introduction to BI

Difference between BI, DWH, Data Mining and Data Mart

Future for BI

MSBI and its Modules

Chapter -2 – Introduction to SSIS

SSIS Framework/Architecture

SSIS Overview of Components

Blocked VS Non-Blocked Transformations

Synchronous and Asynchronous Transformations



Chapter -3-Control Flow Elements

Precedence Constraints


For Loop Container

For Each Loop Container

Sequence Container


The Execute SQL Task

The Bulk Insert Task

The File System Task

The FTP Task

The Send Mail Task

Bulk Insert Task

Data Flow Task

Execute Package Task

Execute Process Task


Chapter -4-Data Flow Transformations

Sort Transformation

Aggregate Transformation

Audit Transformation

Character Map Transformation

Conditional Split Transformation

Copy Column Transformation

Derived Column Transformation

Data Conversion Transformation

Multicast Transformation

OLE DB Command Transformation

Percentage Sampling Transformation

Row Count Transformation

Union All Transformation


Advanced Transformations

Lookup Transformation

Merge Transformation

Merge Join Transformation

Slowly Changing Dimension Transformation

Export and Import Transformation

Pivot and Unpivot Transformation

Chapter-5- Debugging, Error Handling and Logging

SSIS debugging overview

Configuring Package Logging

Breakpoints in SSIS

Event handler in SSIS

Configure Error output in Data Flow

Data Viewers

Configure Check Points

Transactions in SSIS

SSIS Security

Chapter-6- Data Profiling and Data Cleansing

Fuzzy Lookup Transformation

Fuzzy Grouping Transformation

Chapter-7-SSIS Deployment

Create Configuration Files

Implement Logging

Different Deployment Options

Executing packages using utilities – DTExec and DTExecUI

Schedule SSIS Packages with SQL Server Agent Jobs

Monitoring Jobs in SQL Server

Call SSIS Packages in Stored Procedures

Call SSIS Packages in cmd prompt




SQL Server Analysis Service- SSAS

Chapter-1- Introduction to SSAS

Brief Introduction to SSAS and ITS Components

BIDS Environment for SSAS

Creating Project SSAS

Chapter-2-Dimensional Modeling

Introduction to Dimensions and Fact Tables

Snowflake and Star Schema Methodology

Building Data Warehouse

Loading Data using OLTP to OLAP using SSIS Packages

Full and Incremental Loading of Data

Understand Dimensions and Facts

Types of Dimension and Facts

Fact less Fact Table

SSAS Architecture

Chapter-3-Data Source and DSV

Introduction and Creation of DS, DSV

Named Queries

Options in DSV

Chapter-4-Cube Designing and development

Different Ways to Create CUBE

Measures and Measure Groups

Diff between BUILD, DEPLOY and PROCESS

Calculated Columns


Creating and Managing Hierarchies


Chapetr-6-Intro to MDX

Syntax of MDX

Understanding MDX

About Members, Tuple and Sets

Common MDX Functions

New or Updated MDX Functions or Keywords

Understanding the Calculations

Adding Calculated Members

Chapter-7-Processing Options

Understanding Processing

Different Processing Options

Chapter-8- Relationships

Different Types of Relationships

Creating Relationship between Fact and Dimensions

Chapter-9-Storage Modes

Different Storage Modes

How to select different Storage Modes


What are Partitions and How to create Partitions?

On what basis a Partition are created?

Chapter-11-Actions, Calculations, Perspectives and KPIs

What are Actions and How to create IT?

Understand KPIs and Create KPIs

Understand Calculations and Create Calculations

Creating Perspectives

Chapter-12-Deploying the Cube

Generate XMLA and Deploy a Cube in SQL Server

Create Jobs to process the cube in SQL Server

Different Approaches to Deployment

Client Interactions with Excel


SQL Server Reporting Services – SSRS

Chapter-1-Introduction to SSRS

Architecture of SSRS

Components in SSRS

Phases of Report Development Life Cycle

What is a Report?

Chapter-2-Creating Basic Report in SSRS

Wizard to develop SSRS Report

Shared Vs. Embedded Data Sources & Data Sets

Chapter -3-Report Authoring

Table Reports and Matrix Reports

Report Designer Paging Options

Drill-down Reports

Chart Reports, Indicator, Gauge Control Reports

List Reports

Use Page Header and Page Footer

Drill-Through or Linked Reports

Sub Reports

Create Report Template and use it in new Reports

Parameter Reports

Single Parameter

Multiple Parameters

Cascading Parameter

Create Calendar in Parameters

Default Values and Drop Down list options

Expressions in SSRS

Understand conditional formatting

Adding images

Grouping and Sorting

Page Header and Page Footer

Aggregate Functions

Sub Totals and Grand Totals

Document Map Reports

Create Reports with Stored Procedures

Create Reports with SSAS Cube

Chapter-4- Deploying Reports

Report Server Configuration

Configure Report Server details in SSRS Project

Report Deployment to Report Server

Chapter-5-Report Manager and Delivery

Report Builder to create ad-hoc Reports

Create Linked Reports

Create Subions

Standard Subions

Data Driven Subions

Cache a Report

Snapshot a Report

Report Logging


CONTACT ORGANISERS @ 9703347567 / 040-4851 3939 (Build Expertise Training Institute).


More Events From Same Organizer

Similar Category Events