BUSINESS INTELLIGENCE

Microsoft Business Intelligence (MSBI)

Course Duration: Around 30-40 hours Training + Assignments + Real-time Scenarios - 4-8 weeks 

Training Materials: All attendees will receive,

  • Video recording of every session
  • Notes and study material for examples covered.

Pre-Requisites:

  • Entry-level who is aspiring on MSBI or experienced in MS SQL

Training Format:

This course is delivered as a highly interactive session, with extensive live examples. This course is Live Instructor led Online training delivered using Cisco WebEx Meeting center Web and Audio Conferencing tool.

Training Highlights:

  • Focus on Hands on training with lot of assignments, practice exercises and quizzes based on Actual Projects
  • Assignments after each session. Video Recording after every session.

·         Live Sessions and mock interviews and help on resume preparation

Course Content

Introduction to Reporting (SSRS)

SSRS 2008 Features

Reporting Life Cycle

SSRS Components

Reporting Platform

Overview of SSRS

Architecture of SSRS

How to create new report using BIDS

How to create data source

How to create data set

How to create Parameters

Drill through report

Drill down report

Properties of Report

Properties of Textbox in a report

Rendering the report into different extension

Deploying the report

Subscriptions and types of subscription

Parameterized report

Different types of report and its concepts

Report built in functions

SSIS

Topics Covered

Introduction to SSIS) 

SSIS Architecture 

SSIS Package Architecture 

SSIS Components 

SSIS Using SSMS 

Import and Export wizard 

Importing and Exporting Data 

Working with packages 

SQL Server Data tools 

Introduction to control Flow 

Introduction to Data flow 

SSIS Variables 

SSIS Package configurations 

Debugging, Error handling and Logging 

Advanced Data flow transformation 

SSIS Custom code Enhancements and Examples 

SSIS Deployment 

SSIS Package Management

 

 

 

^ Back To Top