MSBI

INTRODUCTION TO SQL SERVER 2008 INTEGRATION SERVICES

  • Over view of integration services solutions
  • Integration Services Tools

DEVELOPING INTEGRATION SERVICES SOLUTIONS

  • Creating an Integration Services Solution
  • Using Variables
  • Building And Running a Solution

IMPLEMENTING CONTROL FLOW

  • Control Flow Tasks
  • Control Flow Precedence Constraints
  • Control Flow Containers

IMPLEMENTING DATA FLOW

  • Data Flow Sources and Destinations
  • Data Flow Transformations
  • Data Flow Pipeline

IMPLEMENTING LOGGING

  • Overview of Integration Services Logging
  • Implementing Logging

DEBUGGING AND ERROR HANDLING

  • Debugging a Package
  • Implementing handling

IMPLEMENTING CHECKPOINTS AND TRANSACTIONS

  • Implementing Checkpoints
  • Implementing Transactions

SSIS ADMINISTRATION

  • Deploying Packages
  • Managing Packages
  • Securing Packages
  • Scheduling a Package

INTRODUCTION TO MICROSOFT SQL SERVER REPORTING SERVICES

Over View of SQL Server Reporting Services
Installing Reporting Services Reporting Services Tools

AUTHORING REPORTS

Creating a Basic Table Report
Formatting Report Pages
Calculating Values
Interactive Navigation
Displaying Data

MANIPULATING DATA SETS

Defining Report Data
Using parameters and Filters
Using Parameter Lists

PUBLISHING AND EXECUTING REPORTS

Publishing reports
Executing reports
Creating Cached instances
Creating Snapshots and Report History

USING SUBSCRIPTIONS TO DISTRIBUTE REPORTS

Introduction to Report Subscriptions
Creating Report Subscriptions
Managing Report Subscriptions

SSRS ADMINISTRATION

Server Administration
Performance and Reliability monitoring
Administering Report Server Databases
Security Administration

INTRODUCTION TO ANALYSIS SERVICES

  • OLTP,DWH
  • OLAP TYPES
  • SSAS Architecture
  • Dimension Tables
  • Fact tables
  • Cubes
  • Analysis Services Tools

CUBE DESIGN PROCESS AND CONCEPTS

  • Dimensions
  • Measure groups
  • Creating Simple Calculations
  • Aggregations and Hierarchies
  • Dimensions Relationships
  • Transactions
  • Perspectives

ADVANCED CUBE DESIGN PROCESS

  • MDX introduction and Queries
  • Implementing KPI
  • Implementing Actions
  • Using Write back

SSAS ADMINISTRATION

  • Apply Security Roles
  • Levels of Security
  • VLDB with partitioning
  • OLAP Processing
  • Monitoring Cube activity
  • Deployment and Scheduling
  • Planning for Disaster Recovery
  • Performance Tuning SSAS