Microsoft Certified Solutions Expert: Business Intelligence 2008 training is a globally recognised standard for IT professionals. The course focuses on the techniques and the skills needed to design, build and deploy Analysis Services, Integration Services, Reporting Services solutions that deliver more data to more people across the organisation.
This training is a complete business intelligence solution offering studies on three different courses mentioned as following:
- Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
- Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
- Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
By the end of MCSE: BI 2008 training course, the participants will be able to:
- Use SQL Server Analysis Services to create, query, customize, implement, and maintain multidimensional analysis solutions
- Implement a Data Mining solution
- Use SQL Server Integration Services and its tools to create, debug, manage, and implement Integration Services package
- Implement security in an Integration Services package by providing checkpoints and transactions
- Use SQL Server Reporting Services to create, enhance, and administer reporting Services report
- Configure and implement custom Reporting Services applications
Target audience
- Database Professionals
- Business Intelligence Developers/Professionals
- Data Analysts
- ETL Professionals
- Reporting Engineers
Prerequisites
The candidates have to meet the following prerequisites:
- Basic understanding of OLAP solutions
- Exposure to create reports in MS Access, Crystal Reports, or another third party reporting products
- Hands-on enterprise data import and export scenarios
- Practical knowledge on the Microsoft Windows Server environment, Microsoft SQL Server, and Windows services (starting and stopping)