MICROSOFT BUSINESS INTELLIGENCE LIVE ONLINE TRAINING
ReadHide full description

York

Sorry, this ad is no longer available.

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 70 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:
SSIS
• 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


SSAS
• 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


SSRS
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

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.