MICROSOFT BUSINESS INTELLIGENCE ONLINE TRAINING

SQL Server 2008/R2 MSBI (SSRS, SSIS, SSAS) ONLINE TRAINING

SQL Server 2008/R2 MSBI (SSRS, SSIS, SSAS) ONLINE TRAINING 

Course Duration:  35 Hours

FOR FREE DEMO contact us at:

EMail:    info@apex-online-it-training.com
Phone:    +91-868-622-2553

ABOUT THE TRAINER

  • 12 YEARS OF INDUSTRY EXPERIENCE
  • 7 YEARS OF EXPERIENCE IN ONLINE AND CLASSROOM TRAINING

        

 

SQL SERVER 2008/R2 MSBI (SSRS, SSIS, SSAS) ONLINE TRAINING   COURSE CONTENT

 

SQL Server 2008/2008 R2 Integration Services

Module 1: Introduction to SQL Server 2008 Integration Services

·         Overview of SQL Server Integration Services

·         Using Integration Services Tools

·         Using the Import and Export Wizard

·         Running an Integration Services Package

Module 2: Developing Integration Services Solutions

·         Creating an Integration Services Solution

·         Using Variables

·         Building and Running a Solution

Module 3: Implementing Control Flow

·         Control Flow Tasks

·         Control Flow Precedent Constraints

·         Control Flow Containers

Module 4: Implementing Data Flow

·         Data Flow Sources and Destinations

·         Basic Data Flow Transformations

·         Advanced Data Flow Transformations

·         Data Flow Paths

Module 5: Implementing Logging

·         Overview of Integration Services Logging

·         Enabling and Configuring Logging

Module 6: Debugging and Error Handling

·         Debugging a Package

·         Implementing Error Handling

Module 7: Implementing Checkpoints and Transactions

·         Implementing Checkpoints

·         Implementing Transactions

Module 8: Configuring and Deploying Packages

·         Package Configurations

·         Deploying Packages

Module 9: Managing and Securing Packages

·         Managing Packages

·         Securing Packages

 

SQL Server 2008/2008 R2 Analysis Services

Module 1: Introduction to Microsoft SQL Server Analysis Services

·         Overview of Data Analysis Solutions

·         Overview of SQL Server Analysis Services

·         Installing SQL Server Analysis Services

Module 2: Creating Multidimensional Analysis Solutions

·         Developing Analysis Services Solutions

·         Creating Data Sources and Data Source Views

·         Creating a Cube

Module 3: Working with Cubes and Dimensions

·         Configuring Dimensions

·         Defining Attribute Hierarchies

·         Sorting and Grouping Attributes

Module 4: Working with Measures and Measure Groups

·         Working With Measures

·         Working with Measure Groups

Module 5: Querying Multidimensional Analysis Solutions

·         MDX Fundamentals

·         Adding Calculations to a Cube

Module 6: Customizing Cube Functionality

·         Implementing Key Performance Indicators

·         Implementing Actions

·         Implementing Perspectives

·         Implementing Translations

Module 7: Deploying and Securing an Analysis Services Database

·         Deploying an Analysis Services Database

·         Securing an Analysis Services Database

Module 8: Maintaining a Multidimensional Solution

·         Configuring Processing

·         Logging, Monitoring, and Optimizing an Analysis Services Solution

·         Backing Up and Restoring an Analysis Services Database

Module 9: Introduction to Data Mining

·         Overview of Data Mining

·         Creating a Data Mining Solution

·         Validating Data Mining Models

 

 

Microsoft SQL Server 2008/2008 R2 Reporting Service

Module 1: Introduction to Microsoft SQL Server Reporting Services

·         Overview of SQL Server Reporting Services

·         Installing Reporting Services

·         Reporting Services Tools

Module 2: Authoring Basic Reports

·         Creating a Basic Table Report

·         Formatting Report Pages

·         Calculating Values

Module 3: Enhancing Basic Reports

·         Interactive Navigation

·         Displaying Data

Module 4: Manipulating Data Sets

·         Defining Report Data

·         Using Parameters and Filters

·         Using Parameter Lists

Module 5: Using Report Models

·         Creating Report Models

·         Using Report Builder

Module 6: Publishing and Executing Reports

·         Publishing Reports

·         Executing Reports

·         Creating Cached Instances

·         Creating Snapshots and Report History

Module 7: Using Subscriptions to Distribute Reports

·         Introduction to Report Subscriptions

·         Creating Report Subscriptions

·         Managing Report Subscriptions

Module 8: Administering Reporting Services

·         Reporting Server Administration

·         Performance and Reliability Monitoring

·         Administering Report Server Databases

·         Security Administration

·         Upgrading to Reporting Services 2008

Module 9: Programming Reporting Services

·         Querying for Server Information Using a Web Service

·         Automating Report Management

·         Rendering Reports

·         Creating Custom Code