Microsoft Business Intelligence Training

Microsoft Business Intelligence Training


  • Microsoft Business Intelligence Registration

    Sale Date Ended

    INR 18000
    Sold Out

Invite friends

Contact Us

Page Views : 1173

About The Event

Microsoft Business Intelligence Training 9 Days (Full Time – 8 Hrs per Day)

Microsoft SQL Server 2008 Reporting Services (SSRS)
Microsoft SQL Server 2008 Analysis Services (SSAS)
Microsoft SQL Server 2008 Integration Services (SSIS)

Certification Preparation
Exam 70-448:- TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

+ Placement Assistance and Career Counseling

Pune 9 Days – 22nd August 2011 To 1st September 2011 (8 HOURS PER DAY)
Venue: Aai Bunglow, Bramhachaitanya society, old Warje naka, Pune 411058

Bulk Registrations of 2 and above get a Discount of 20%.

For Booking call or Enquiry Phone: +91 9823221922 or 020-65292176
Email: |

Trainer: Rahul Joshi - Founder and Director at GreenFrog IT Solutions Pvt Ltd - 12 Years of Experience


Course Outline       Duration: 3 Days

Module 1: Introduction to Microsoft SQL Server Reporting Services
The students will be introduced to the role that Reporting Services plays in an organization's reporting life cycle, the key features offered by Reporting Services, and the components that make up the Reporting Services architecture.
• Overview of SQL Server Reporting Services
• Architecture of SQL Server 2008 Reporting Services
• Installing Reporting Services
• Reporting Services Tools

Module 2: Authoring Basic Reports
The students will learn the fundamentals of report authoring, including configuring data sources and data sets, creating tabular reports, summarizing data, and applying basic formatting.
• Creating a Basic Table Report
• Formatting Report Pages
• Calculating Values

Module 3: Enhancing Basic Reports
The students will learn about navigational controls and some additional types of data regions, and how to use them to enhance a basic report.
Lessons and Labs
• Interactive Navigation
• Displaying Data
• Parameterized reports
• Linked reports
• Snapshot reports
• Cached reports
• Ad hoc reports
• Click through reports
• Drilldown reports
• Drill through reports
• Sub reports

Module 4: Manipulating Data Sets
The students will explore data sets to a greater depth, including the use of alternative data sources and interacting with a data set through the use of parameters. Students will learn how to dynamically modify the data set underlying a data region by allowing parameters to be sent to the underlying query, as well as will learn to use best practices to implement static and dynamic parameter lists when interacting with queries and stored procedures.
• Defining Report Data
• Using Parameters and Filters
• Using Parameter Lists
Lab : Manipulating Data Sets
• (Level 200) Using Parameters to Restrict Query Results
• (Level 200) Using Parameters to Filter Report Data
• (Level 200) Creating Dynamic Parameter Lists
• (Level 200) Using Parameters with a Stored Procedure
• (Level 200) Displaying All Categories in a Parameter List

Module 5: Using Report Models and Report Builder 3.0
The students will learn how to create a report model so that business users can create their own reports without using the full Report Designer development environment. Students will also learn how to use Report Builder to create a report from a report model.
• Creating Report Models
• Using Report Builder 3.0
Lab : Using Report Models
• (Level 200) Creating a Report Model
• (Level 200) Using Report Builder to Create a Report

Module 6: Publishing and Executing Reports
The students will learn the various options you can use to publish reports to the report server and execute them.
• Publishing Reports
• Executing Reports
• Creating Cached Instances
• Creating Snapshots and Report History
Lab : Publishing and Executing Reports
• (Level 200) Publishing Reports
• (Level 200) Executing Reports
• (Level 200) Configuring and Viewing a Cached Report
• (Level 200) Configuring and Viewing a Snapshot Report

Module 7: Using Subscriptions to Distribute Reports
The students will learn how to implement subscriptions so that you can distribute reports either automatically by e-mail or by publishing reports to a shared folder.

Introduction to Report Subscriptions
Creating Report Subscriptions
Managing Report Subscriptions

Lab : Using Subscriptions to Distribute Reports
• (Level 200) Creating a Standard Subscription
• (Level 200) Creating a Data-Driven Subscription

Module 8: Administering Reporting Services
The students will learn how to administer the Reporting Services server, how to monitor and optimize the performance of the report server, how to maintain the Reporting Services databases, and how to keep the system secure.
• Reporting Server Administration
• Performance and Reliability Monitoring
• Administering Report Server Databases
• Security Administration
• Upgrading to Reporting Services 2008



Course Outline       Duration: 3  Days

Module 1: Introduction to SQL Server 2008 Integration Services
The students will be introduced to the role that Integration Services plays in extracting, transforming, and loading data. The students will also be introduced to the tools that are used to build and manage Integration Services solutions.
• Overview of SQL Server Integration Services
• Using Integration Services Tools
Lab: Introduction to SQL Server Integration Services
• (Level 200) Using the Import and Export Wizard
• (Level 200) Running an Integration Services Package
Module 2: Developing Integration Services Solutions
The students will be introduced to the development tasks that are involved in creating an Integration Services package.
• Creating an Integration Services Solution
• Using Variables
• Building and Running a Solution
Lab: Developing Integration Services Solutions
• (Level 200) Creating an Integration Services Project
• (Level 200) Implementing a Package
• (Level 200) Building and Running an Integration Services package
Module 3: Implementing Control Flow
The students will be introduced to the tasks and precedence constraints that can be used to implement control flow in an Integration Services package.
• Control Flow Tasks
• Control Flow Precedent Constraints
• Control Flow Containers
Lab: Implementing Control Flow
• (Level 200) Creating a Simple Control Flow
• (Level 200) Configuring Precedence Constraints
• (Level 200) Using Containers
• File Rename and Move
• Looping Files in For Each Loop
• ForeachFileEnumerator
Module 4: Implementing Data Flow
The students will be introduced to the data flow sources, transformations, and destinations that can be used to implement a data flow task in an Integration Services control flow. It also explains how to use data flow paths to direct valid and invalid rows through the data flow.
• Data Flow Sources and Destinations
• Basic Data Flow Transformations
• Advanced Data Flow Transformations
• Data Flow Paths
Lab: Implementing Data Flow
• (Level 200) Transferring Data
• (Level 200) Implementing Transformations
• (Level 200) Using Data Viewers
• (Level 200) Configuring Error Output
Module 5: Implementing Logging
The students will be introduced to how to use logging in an Integration Services package, and explained how to configure and use logging providers to generate information about a package's execution.
• Overview of Integration Services Logging
• Enabling and Configuring Logging
Lab: Implementing Logging
• (Level 200) Configuring Logging
• (Level 200) Implementing Custom Logging
Module 6: Debugging and Error Handling
The students will be introduced to how to debug Integration Services packages by using the debugging tools in Business Intelligence Development Studio. It then explains how to implement error-handling logic in an Integration Services package.
• Debugging a Package
• Implementing Error Handling
Lab: Debugging and Error Handling
• (Level 300) Debugging a Package
• (Level 300) Implementing Error Handling
• (Level 300) Controlling Failure Behavior
Module 7: Implementing Checkpoints and Transactions
The students will be introduced to what checkpoints are and how to implement them. It then discusses transactions, and describes how to implement transactional data access logic in an Integration Services package.
• Implementing Checkpoints
• Implementing Transactions
Lab: Implementing Checkpoints and Transactions
• (Level 200) Implementing Checkpoints in a Package
• (Level 300) Implementing Transactions in a Package
• (Level 300) Implementing a Native Transaction
Module 8: Configuring and Deploying Packages
The students will be introduced to how to create Package Configurations and how to deploy Integration Services packages to production servers.
• Package Configurations
• Deploying Packages
Lab: Configuring and Deploying Packages
• (Level 200) Creating a Package Configuration
• (Level 200) Preparing a Package for Deployment
• (Level 200) Deploying a Package
Module 9: Managing and Securing Packages
The students will be introduced to the management tasks that relate to Integration Services packages and explained how to perform those tasks by using the Integration Services management tools. It also describes how to secure Integration Services packages.
• Managing Packages
• Securing Packages
Lab: Managing and Securing Packages
• (Level 200) Importing a Package
• (Level 200) Configuring and Monitoring a Package
• (Level 200) Scheduling a Package
• (Level 200) Securing a Package
Module 10: WMI Services
• WMI-Services Start-Log in SQL


Additional Advance Examples:
• Data Profiling Task
• Execute SQL Task
• Send Mail Task
• WMI Data Reader and WMI Event Watcher Task in SSIS
• SQL Server Analysis Services Tasks
• The FTP task
• Merge and Merge Join
• Multicast Transformation and Conditional
• Conditional Split
• Aggregate
• Multicast Transformation
• Lookup





Course Topics                                Duration: 3 Days

      Module 1: Creating Advanced Measures and Calculations
• Using Aggregate Functions
• Using MDX to Retrieve Values from a Cube – Sample Script
• Creating Calculated Members
• Calculation Scripting
• Creating and Implementing KPIs
      Module 2: Advanced Dimension Design
• Dimension Usage
• Creating Reference Dimensions
• Creating a Fact Dimension
• Creating a Many-to-Many Dimension
     Module Advanced Design
       Module 3: Working with Cubes and Dimensions
• Configuring Dimensions
• Defining Attribute Hierarchies
• Sorting and Grouping Attributes
• Assignment for grouping, sorting , formatting , Hierarchies

Module 4: Interacting with a Cube
• Implementing Actions
• Implementing Translations
• using Write-back to Modify Analysis Services Data
Module 5: Retrieving Data from Analysis Services
• Creating and Implementing Perspectives
• Creating MDX Queries
• Accessing Analysis Services Using Excel
• Creating Reporting Services Reports
Module 6: Implementing Security
• Understanding Roles
• Securing Administrative Access
• Securing Data Access
Module 7: Designing Aggregations
• Understanding Aggregation Design
• Using the Aggregation Design Wizard
• Using the Usage-Based Optimization Wizard
Module     Production Management
         Module 8: Managing Partitions and Database Processing
• Working with Storage
• Managing Analysis Services Processing
• Working with Partitions
 Module 9: Managing Deployment
• Deployment Overview
• Deployment Mechanics
•  Deployment Using Business Intelligence Development Studio
• Deployment Using the Deployment Wizard
• Understanding Deployment Scripts
• Migrating Databases and Disaster Recovery
Module 10:  Advanced Monitoring and Management Tools
• Monitoring Analysis Services Using Windows Reliability And Performance Monitor
• Monitoring Analysis Services Using SQL Server Profiler
• Analysis Services Dynamic Management Views
Module 11: Introduction to Data Mining
• Overview of Data Mining
• Creating a Data Mining Solution – real life scenarios
• Validating Data Mining Models
• Performance and tuning tips

 Date: 9 Days – 22nd August 2011 To  1st September 2011
 Venue: Aai Bunglow, Bramhachaitanya society, old Warje naka, Pune 411058

 • Includes, Training Charges for 9 Days  (8 hours per day)
• Official Courseware
• Video Training also supplied with Training
• Certification Preparation + Placement Assistance + Career counseling           



Venue Map