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.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.html
SQL Server Reporting Services
• SQL Server Reporting Services
• 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.html
The Real Time Project that will be provided after the training contains the lifecycle of entire MSBI modules. We provide complete documentation along with secured solution.
For further details, you can 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
Mobile: +91 0 9666440801
Office: +91 40 64577244
http://sqlbitraining.com
