SQL School, one of the best places for SQL Server PRACTICAL training provides Microsoft Business Intelligence [MS BI] course with one REALTIME PROJECT.

Course Duration is for minimum of 60 hours, completely practical and covering SQL Server Integration Services [SSIS], SQL Server Analysis Services [SSAS] and SQL Server Reporting Services [SSRS].

Please find the Course Highlights:

SQL Server Integration Services

• Need for MSBI Process

• Limitations of OLTP systems

• Introduction to Control Flow

• Introduction to Data Flows

• ETL with non-SQL Server sources

• Variables and Configurations

• Advanced Control Flow

• Error Handling and Event Handling

• Package Deployment & Management

• MSDB Security Enforcement

• Package and Task Scripting

• Custom Components and Profiling

• Beyond ETL: Other Scenarios for SSIS

For complete SSIS course content - http://sqlbitraining.com/SSIS_Online_Training.html

SQL Server Analysis Services

• Data Warehousing Principles

• Analysis Services Architecture

• Identification Techniques

• Dimension Design

• Cube Design and Hierarchy Design

• Advanced SSAS Design

• Advanced MDX Functions and limitations

• KPI Identification and Calculations

• Managing Data warehouses

• Performance Counters and Optimizations

• Comparison with Analysis Services of SQL Server 2005

• Migrating SSAS 2005 Projects to 2008

• Generation of Reports from SSAS Cubes

For complete SSAS course content - http://sqlbitraining.com/SSAS_Online_Training.html

SQL Server Reporting Services

• Need for Enterprise Reporting

• SSRS Architecture

• Reporting life Cycle

• Report Filters

• Dynamic Parameterized Reports

• Chart Based reports

• Gauges and Multidimensional Reports

• Cube Reports and Gauge Reports

• Need for Web Services

• Managing Reporting Services

• Report Delivery and Report Builder

• Data Driven Subscriptions

• Report builder Applications

• Security Management

• Custom Application Integration

For complete SSRS course content - http://sqlbitraining.com/SSRS_Online_Training.html

For more details, please visit http://sqlschool.com