Microsoft Certified IT Professional: Business Intelligence

MCITP: Business Intelligence Developer

Microsoft Certified IT Professional: Business Intelligence Developer (MCITP: Business Intelligence Developer) is the premier certification for business intelligence system designers and developers.

This 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 mid-sized to large-sized organizations.

Microsoft Certification Courses

There are 7 courses in total designed to help individuals pass the exams necessary for this credential.

• 2791: Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services
• 2792: Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
• 2793: Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
• 2794: Designing a Business Intelligence Solution Architecture for the Enterprise Using SQL Server 2005
• 2795: Designing an ETL Solution Architecture using SQL Server 2005 Integration Services
• 2796: Designing a Multi Dimensional Solution Architecture Using SQL Server 2005 Analysis Services
• 2797: Designing a Reporting Solution Architecture using SQL Server 2005 Reporting Services

Microsoft Certification Exams

There are 2 exams in total, necessary to pass in order to attain this credential. MCPIT:BID candidates must first complete the requirements for the MCTS: SQL Server 2005 Business Intelligence certification (one exam). After achieving this Technology Specialist certification, candidates earn their MCITP: Business Intelligence Developer by passing one required exam.

• Exam 70-445: TS: Microsoft SQL Server 2005 Business Intelligence - Implementation and Maintenance
• Exam 70-446: PRO: Designing a Business Intelligence Solution by Using Microsoft SQL Server 2005