#50, Kamala Nivas, Sap Street Gayatri Nagar, Behind Mytrivanam, Building,Ameerpet, Kumar Basti, Srinivasa Nagar, Ameerpet, Hyderabad, Telangana 500038

  • Facebook - Grey Circle
  • LinkedIn - Grey Circle
Get a quote: 9885245722

MSBI

PROJECT 4

MSBI Training Content

Mail: info@eclasess.com

Mob:9885245722

Website: www.eclasess.com

Services:    Duration;35 hours

Resume Preparation

Interview Questions and Answers

Real Time Project Explanation

SQL Server Integration Services (SSIS)

  • 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

  • . Package Parameters

  • · Deploying Packages

  • Module 9: Managing and Securing Packages

  • · Managing Packages

  • · Securing Packages

SQL Server Analysis Services (SSAS)

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

SQL Server Reporting Service (SSRS)

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

comming soon....

CONTACT :9885245722