Microsoft Certified IT Professional (MCITP): Business Intelligence Developer certification demonstrates that you can design analysis solutions, data transformations, and reports. Business intelligence developers design and implement multi-dimensional database models (logical and physical), data marts, data warehousing, data transforms, data analytics, and reporting solutions. This includes programming and customizing servers that use Multidimensional Expressions (MDX), customer transforms, and custom reporting solutions. Business intelligence developers are typically employed by medium-sized to large organizations.
To achieve this certification, you must pass two exams: one Microsoft Certified Technology Specialist (MCTS) prerequisite exam and one Professional Series exam.
| Course Code | Course Name | Duration |
| 70 – 445 | TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance | 9 Days |
| 70 –446 | PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005 | 7 Days |
Course Outline:-
70-445
- Managing SQL Server Analysis Services
- Developing SQL Server Analysis Services Solutions(SSAS) by Using Business Intelligence Development Studio(BIDS)
- Implementing Data Mining by Using Business Intelligence Development Studio
- Managing SQL Server Reporting Services(SSRS)
- Developing Reporting Solutions by Using SQL Server Reporting Services
- Developing Business Intelligence Solutions by Using SQL Server Integration Services
- Administering SQL Server Integration Services Packages
70-446
- Configuring IP Addressing and Services
- Configuring Name Resolution
- Configuring Network Access
- Configuring File and Print Services
- Monitoring and Managing a Network Infrastructure
