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
