MSBI Online Training Institute in India

MSBI Online Training Institute +91 - 903 299 4888.

course content for msbi online training and offline 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
•