Courses Offered :
Testing Tools      PeopleSoft      Oracle Technologies      SQL DBA / MSBI      DBA/App’s      Data Warehousing      Android / iPhone      OBIEE, Data Stage      SOA Testing      Main Frames      DBA Technologies      SAS      Database / ETL Testing      SAP All Modules      SOA Testing      Micro Soft Technologies      JAVA      

Microsoft – BI(SSIS, SSAS, SSRS)

  • Planning for ETL:
    • Source Identify Data Sources and Destinations
    • Evaluating Data
    • Identify Staging Requirements

    Lab: Planning an ETL Solutions

  • Planning SSIS Solutions:
    • Planning Packages
    • Planning Package development
    • Designing Package Control Flow

    Lab: Implementing SSIS Packages

  • Designing Data Flow:
    • Understanding Data Flow
    • Designing Data Flow Operations
    • Handling Data Changes

    Lab: Implementing Data Flow

  • Logging Error Handling and Reliability:
    • Logging ETL Operations
    • Handling Errors in SSIS
    • Implementing Reliable ETL Process with SSIS

    Lab: Implementing Reliable Packages

  • Optimizing an SSIS Solution:
    • Monitoring SSIS Performance
    • Optimizing SSIS Packages
    • Scaling out SSIS Packages

    Lab: Optimizing Packages

  • Deploying and Operating an SSIS Solution
    • Deploying SSIS Packages
    • Operating an SSIS Solution

    Lab: Optimizing Packages

  • Introduction to Microsoft SQL Server 2008 Analysis Services
    • Overview of Data Analysis Solutions.
    • Over of SQL Server 2005 Analysis Services.
    • Installing SQL Server 2005 Analysis Services.
  • Creating Multidimensional Analysis Solution
    • Developing Analysis Service Solutions.
    • Data Sources and Data Sources Views.
    • Creating a Cube.

    Lab: Creating a multidimensional Analysis Solution

  • Working with Dimensions
    • Configuring Dimensions.
    • Defining Hierarchies.
    • Sorting and Grouping Attributes.

    Lab: Defining Dimensions

  • Working with Measure and Measure Groups
    • Working with Measure.
    • Working with Measure Groups.

    Lab: Configuring Measure and Measure Groups

  • Querying Multidimensional Analysis Solutions
    • MDX Fundamentals.
    • Adding Calculations to a Cube.

    Lab: Querying a Cube

  • Customizing Cube Functionality
    • Implementing Key Performance Indicators.
    • Implementing Actions.
    • Implementing Perspectives.
    • Implementing Translations.

    Lab: Customizing a Cube

  • Deploying and Securing an Analysis Services Database
    • Deploying an Analysis Services Database.
    • Securing an Analysis Services Database.

    Lab: Deploying and Securing an Analysis Services Database

  • Maintaining a Multidimensional Solution
    • Configuring Processing Settings.
    • Logging, Monitoring and Optimizing an Analysis Services Solution.
    • Backing Up and Restoring an Analysis Service Database.

    Lab: Maintaining an Analysis Services Database

  • Introduction to Data Mining
    • Overview of Data Mining.
    • Creating a Data Mining Solution.
    • Validating Data Mining Models

    Lab: Implementing Data Mining

  • SSRS – Objectives:  
    • Describe SQL Server Reporting Services and its Components.
    • Create a Reporting Services report.
    • Enhance a Reporting Service report.
    • Create and manipulate data sets.
    • Use report models to implement reporting for business users.
    • Configure report publishing and execution settings.
    • Implementing subscription for reports.
    • Implement custom Reporting Services applications.
Copyright © 2012, Jampani Technologies. All rights reserved.