How to Become MCSE Business Intelligence Certified?

mcse data platform road map

As an IT pro interested in business intelligence, you may want to know, "How do I become MCSE Business Intelligence certified?" This credential is part of Microsoft's Microsoft Certified Solutions Expert (MCSE) program. As such, getting certified on MCSE Business Intelligence can set your skills apart thanks to the validation that this certification provides. This is a prestigious credential that requires extensive knowledge and skills focused on both SQL Server 2012 and business intelligence topics. For best results, consider enrolling in MS SQL Server 2012 training focused on the required certification exams. For example, you will need to first acquire an MCSA SQL Server 2012 credential and then pass two certification exams. If you are upgrading from MCITP Business Intelligence 2008, you'll need MCSE certification training focused on transitioning your skills to the 2012 version of SQL Server and Business Intelligence.

Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012
The first required exam, 70-466: Developing Microsoft SQL Server 2012 Databases, is available to those who have previously passed 70-461, 70-462, and 70-463 and earned their MCSA SQL Server 2012 credentials. You can prepare for this exam by enrolling in the Implementing Data Models and Reports with Microsoft SQL Server 2012 course. In general, you will need to master the following topics:

  • Building analysis services databases
  • Managing, maintaining, and troubleshooting SSAS databases
  • Building tabular data models
  • Using SSRS for report building

Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012
The next required certification exam is 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012. This certification exam covers a variety of technical tasks including:

  • Business intelligence infrastructure planning
  • Business intelligence infrastructure design
  • Reporting solution design
  • BI data model design
  • ETL solution design

mcse sql bi 2012 upgrade 70-460

Exam 70-457: Transition your MCTS on SQL Server 2008 to MCSA SQL 2012 Part 1
If you have already earned the MCITP: Business Intelligence 2008 certification, you are eligible to take the upgrade path to MCSE Business Intelligence. In order to earn your MCSE BI certification by following the upgrade path, you will need to pass three upgrade exams. The first two involve upgrading your skills to MCSA SQL Server 2012 while the third is specific to transferring your 2008 business intelligence skills to the 2012 version.

Exam 70-457: Upgrading your Skills to MCSA SQL Server 2012 Part 1 covers the following technical topics:

  • Database object creation
  • Working with data
  • Data modifications
  • Query troubleshooting and optimization
  • SQL Server 2012 installation and configuration
  • Database and instances maintenance
  • SQL Server 2012 troubleshooting and optimization

Exam 70-458: Transition your MCTS on SQL Server 2008 to MCSA SQL 2012 Part 2
Part 2 of the upgrade involves mastering the skills and knowledge measured by the next upgrade exam, Upgrading your Skills to MCSA SQL Server 2012 Part 2 (70-458). This upgrade exam focuses on your skills related to

  • Data management
  • Security implementation
  • High availability implementation
  • Data warehousing (design and implementation)
  • Data extraction and transformation
  • Data load tasks
  • SSIS configuration and deployment
  • The creation of data quality solutions

Exam 70-460: Transition your MCITP BI Developer 2008 to MCSE BI 2012
Finally, you will need to pass one more certification upgrade exam in order to upgrade your MCITP Business Intelligence 2008 certification to MCSE Business Intelligence. This exam, 70-460: Upgrading your Skills to MCSE Business Intelligence, covers:

  • Building analysis services databases
  • Managing, maintaining, and troubleshooting SSAS databases
  • Building tabular data models
  • Using SSRS for report building
  • Planning business intelligence infrastructures
  • Designing business intelligence infrastructures
  • Designing business intelligence data models
  • Planning to deploy SSIS solutions