MSBI Training

Microsoft BI Training explains how to create real world integration, Analytical and Reporting applications with MSBI. Microsoft BI tools cover a wide range of functionalities and they hold up to the competition very well.

MSBI Training Curriculum

Introduction & Installation – Microsoft Business Intelligence

Get started with the Installation of MSBI and how to configure BI tools..

Installation
using BI tools
Configuring BI tools

Microsoft SQL Server Integration Services (SSIS)

Overview of Integration Services, Different Integration tools present and get yourself introduce to SQL Server..

Introduction to SQL Server 2008
Overview of integration services solutions
Integration Services Tools

Developing Integration Services Solutions

Learn, How to create an Integration Services using variables and also how to run the services after building it..

Creating an Integration Services Solution
Using Variables
Building And Running a Solution

Implement Control Flow

The focus in this module will train you to learn different types of Control flow elements..

Control Flow Tasks
Control Flow Precedence Constraints
Control Flow Containers

Implement Data Flow

SQL Server Integration Services provide three different types of data flow components: Sources, Transformations, and Destinations.

Data Flow Sources and Destinations
Data Flow Transformations
Data Flow Pipeline

Implement Logging in SSIS

SSIS includes log providers that you can use to implement logging in packages, containers, and tasks. With logging, you can capture run-time information about a package, helping you audit and troubleshoot a package every time it is run.

Overview of Integration Services Logging
Implementing Logging

Explore Debugging and Error Handling

While a package is running in the debug environment you are able to see the status of both control flow and data flow components.

Debugging a Package
Implement error handling

Implement Checkpoints AND Transactions

In this module, you’ll learn, How to implement Checkpoints and Transactions..

Implement Checkpoints
Implement Transactions

SSIS Administration

When you install SQL Server, all users in the Users group have access to the Integration Services so that they can grant permissions at Deploying, Managing, Securing and Scheduling a package level..

Deploying Packages
Managing Packages
Securing Packages
Scheduling a Package

Microsoft SQL Server Reporting Services (SSRS)

Get a complete overview on SQL Server Reporting Services and also how to install the Services tool..

Overview of SQL Server Reporting Services
Installing Reporting Services Tools

Authoring Reports

This section briefly defines, How to Create a Basic Table report, Formatting a Report pages, Calculating its value and also interactive navigation..

Creating a Basic Table Report
Formatting Report Pages
Calculating Values
Interactive Navigation
Displaying Data

Manipulating DataSets

In this module, you’ll learn, how to define a report data using parameter lists, filters and parameters..

Defining Report Data
Using parameters and Filters
Using Parameter Lists

Publishing and Executing Reports

Understand how to publish, execute reports and also learn how to create Cached instances, Create Snapshots and Report History..

Publishing reports
Executing reports
Creating Cached instances
Creating Snapshots and Report History

Using Subscriptions to Distribute Reports

A Reporting Services subscription is a configuration that delivers a report at a specific time or in response to an event, and in a file format that you specify.

Creating Report Subscriptions
Managing Report Subscriptions

SSRS Administration

Administering a Reporting Services installation requires that you know how to perform routine maintenance tasks for server components, Security administration and how to manage the content and ongoing operations of the report server.

Server Administration
Performance and Reliability monitoring
Administering Report Server Databases
Security Administration

Microsoft SQL Server Analysis Services (SSAS)

In this tutorial, we will learn about the differences between Data Warehouse database and OLTP database and the different types of OLTP..

Introduction To Analysis Services
OLTP
DWH and OLTP Types

SSAS Architecture

The focus in this module trains you on, SSAS Architecture that includes Analysis Services tools and Different types of tables..

Dimension Tables
Fact tables
Cubes
Analysis Services Tools

Cube Design Process and Concepts

Learn about, how to create simple calculations, Aggregations, Hierarchy and measuring groups..

Dimensions
Measure groups
Creating Simple Calculations
Aggregations and Hierarchies
Dimension Relationships
Transactions
Perspectives

Advanced Cube Design Process

By the end of this module, you’ll learn about, How to implement Actions, KPI and also about the Queries and MDX introduction..

MDX introduction and Queries
Implementing KPI
Implementing Actions
Using Write back

SSAS Administration

Members of the Server administrator role within an instance of Analysis Services have unrestricted access to all Analysis Services objects. In this module, you’ll get a detail description about OLAP Processing, Assigning security roles, How to monitor cube activity, and also about Performance tuning of SSAS..

Apply Security Roles
Levels of Security
VLDB with partitioning
OLAP Processing
Monitoring Cube activity
Deployment and Scheduling
Planning for Disaster Recovery
Performance Tuning SSAS.