MCITP Development


Business Intelligence Developer

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.

How to earn your MCITP: Business Intelligence Developer certification

To achieve this certification, you must pass two exams: one Microsoft Certified Technology Specialist (MCTS) prerequisite exam and one Professional Series exam.

This certification will retire when Microsoft discontinues mainstream support for the related technology.

Prerequisite MCTS exam

 

Exam 70-445

Review the preparation guide for Exam 70-445: TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance

 

Professional Series exam

 

Exam 70-446

Review the preparation guide for Exam 70-446: PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005

Business Intelligence Developer 2008

See the following table for related training resources.

Required certifications

Required exams

Exam 70-448

Course 6236A: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services (three Days)

or

Course 6235A: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services (three Days)

or

Course 6234A: Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services (three Days)

 

Exam 70-452

Course LP452A: Learning Plan for SQL Server 2008 Business Intelligence Development and Maintenance (one Forms)