MSBI online training by experienced trainers @MINDMAJIX - New York, NY

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