Duration of course is 35 hours for three modules.
Course includes three
sample projects.
Course Details:
Topics |
No Of
Days |
| 1. |
SQL Server Integration Services (SSIS)
- Introduction to SSIS
- Introduction to Control Flow
- Introduction to Data Flows
- Variables and Configurations
- Advanced Control Flow
- Package Deployment
- Package Management
- Introduction to Scripting and Custom Components
- Beyond ETL: Other Scenarios for SSIS
|
|
| 2. |
SQL SERVER ANALYSISSERVICES
- Introduction to Data Warehousing Concepts
- Introduction to Analysis Services
- Designing Analysis Services Projects
- Advanced SSAS Design
- Managing Analysis Services
- Performance Counters
- Comparison with Analysis Services of SQL Server 2000
- Migrating SSAS 2005 Projects to 2008
- Best Practices and Conclusion
|
|
| 3. |
SQL Server Reporting Services
- Introduction to Reporting Services 2005 and 2008
- Authoring Reports
- Managing Reporting Services
- Delivery of Reports
- Security Parameters and Roles
- Best Practices and Conclusion
|
|
|
Total : |
35 Hrs. |
Communication Team has designed ExpertsExchange Program - Business Intelligence
Track to help bring professionals to the next level in their career by learning
to design and develop business intelligence systems that help reduce the
complexity of organizing and distributing information for mid- to large-size
organizations through the use of Microsoft Business Intelligence tools.
During this Business Intelligence training program, you will dive into
Designing an ETL Solution Architecture Using Microsoft SQL Server Integration
Services and Implementing and Maintaining Microsoft SQL Server Integration
Services.
In addition, we will extensively cover how to Design an
Analysis Solution Architecture Using Microsoft SQL Server Analysis Services and
Implement and Maintain Microsoft SQL Server Analysis Services.
You will expand your knowledge on MDX Queries and learn how to
create complex reports employing expressions, global collections, and
conditional formatting using
SQL Server Reporting Services.
Why not CommunicationTeam? Why Not You? Why Not Now?
|
Are you ready to take the next step to further your career?
|
Want more information about our Training and Placement Program?
|
|
|
|