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

Contact Us

Tel: +91-8897400222
USA: +1-512-800-7568
EMAIL: info@mentorsinn.com

Testimonials

" The MSBI training was very good, training was conducted by real time expers, thanks for the support. " - Shashi (MSBI)