MSBI Training

MSBI ONLINE TRAINING

MSBI COURSE CONTENT

  • Introduction to¬†Microsoft Business Intelligence
  • Installing and using BI tools
  • Configuring BI tools

SSIS

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

SSRS

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

SSAS

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