MS-BI 2008 R2 (SSIS,SSAS,SSRS) Online Training

In customer scenarios with the requirement to integrate data out of SAP BW with some non-SAP data sources people usually recommended to first consolidate and load everything into a single system ( either SAP BW or SQL Server / SSAS ).

MS-BI 2008 R2 (SSIS,SSAS,SSRS) Online Training Course Content
SQI Server 2008 Integration Servers (SSIS)
  • Overview of SSIS
    • Over view of Integration Servers Solutions
    • Integration Services Tools
  • Developing Integration Services Solution
    • Creating an integration services solution
    • Using Variables
    • Building and Running a Solution
  • Implementing Control Flow
    • Control flow Tasks, Containers
  • Implementing Data Flow
    • Data Flow Transformations, Paths and Destinations
  • Implementing Logging Debugging and Error Handling
  • Implementing Checkpoints and Transactions
  • Packages
    • Package Configurations
    • Deploying Packages
    • Managing Packages
    • Securing Packages
SQL Server 2008 Analysis Services (SSAS)
  • Overview of SSIS
    • Overview Of Data Analysis Solutions
    • Overview of SQL server 205 Analysis Services
  • Creating Multidimensional Analysis Solutions
    • Developing Analysis services
    • Data sources and source views
    • Creating a Cube
  • Configuring Dimensions
  • Analytical MDX
    • Analytical MDX Introduction
    • MDX Vs SQL
    • MDX Stored Procedures
  • Customizing Cube Functionality
    • Implementing key Performance Indicator
    • Implementing Actions, Perspectives, Translations
  • Deploying and Securing an Analysis Services Database
  • Maintaining a Multidimensional solution
    • Logging, Monitoring and Optimizing an Analysis Services Solution
    • services Database
SQL Server Reporting Servers(SSRS)
  • Overview of SSRS
    • Overview of SQL Server Reporting Services
    • Reporting Services Tools
  • Authoring Basic Reports
    • creating a basic Table report
    • calculating values
  • Enhancing Basic Reports
  • Using and creating reports models
  • Publishing and executing reports
    • Publishing report
    • Executing report
    • Creating cached instances
  • Using subscriptions to distribute reports
    • Introduction to report subscriptions
    • Creating report subscriptions
  • Administering reporting services
    • Server administration
    • Performance and reliability monitoring
    • Administering reportserver database
    • Security administration
  • Programming reporting services
  • SQL Server

Please Register with us