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 further details, please visit our website or call us. We also provide T-SQL Online Trainings, SQL DBA Online Trainings and Real Time Projects.
SQL School
contact@sqlbitraining.com
Mob:+91-(0)-9666440801
Office: 040-6457 7244
US: (001) 214-628-5666
http://sqlbitraining.com
