3-Day (BI-ASTUN08-301-EN)
During this 3-day course, you will learn to deploy, operate and tune an Analysis Services solution. You begin by learning how to prepare for the successful deployment of an Analysis Services solution. You will then learn to update data in a production environment while minimizing its impact on performance. Finally, you will learn to collect and analyze data to improve processing and querying performance.
This course is intended for IT Professionals responsible for deploying, operating and tuning an Analysis Services solution. The target audience for this course is IT professionals and business intelligence developers who want to successfully deploy and operate well-performing Analysis Services solutions.
Before attending this course, it is recommended that students have the following skills:
- Experience using Business Intelligence Development Studio to develop Analysis Services projects
- Experience using SQL Server Management Studio to manage an Analysis Services database
- Experience writing T-SQL and MDX queries
- Experience collecting performance monitor counters
- Experience collecting SQL Server Profiler traces
- SQL Server 2008 Analysis Services
- Network Load Balancing
- SQL Server Profiler
- SQL Server Management Data Warehouse
Upon completion of this course, the student will be able to:
- Deploy an Analysis Services project from development to test and production
- Synchronize changes over time between development, test and production
- Determine appropriate hardware resources and software versions for your production environment
- Plan for security and availability requirements
- Update dimension and partition data while minimizing the impact on availability and performance
- Troubleshoot deployment and processing errors
- Utilize a scale-out architecture for availability and performance
- Monitor an Analysis Services solution for availability, performance and usage
- Diagnose and resolve query performance issues
- Diagnose and resolve processing performance issues