There have been many changes to the Microsoft certification program lately. Among these changes have been brand new MCSA and MCSE certifications, including MANY new exams. Among these changes is the recent addition of the MCSA: BI (Business Intelligence) Reporting certification.

What exams qualify?

The MCSA (Microsoft Certified Solution Associate) certification in BI Reporting requires 2 exams to be passed in order to earn the full MCSA: BI Reporting certification.

Here are the 2 exams required to earn this certification:

  • 70-778: Analyzing and Visualizing Data with Power BI
  • 70-779: Analyzing and Visualizing Data with Microsoft Excel

The MCSA: BI Reporting certification doesn’t have a large list of exams to choose from, however, it is very specialized for professionals who are working with Power BI and SQL data models.

From MCSA to MCSE Certification

MCSA: BI Reporting Certification from Microsoft 1Just like all the other MCSA (Microsoft Certified Solution Associate) certifications, the MCSA: BI Reporting certification also provides a foundational path to earning the bigger MCSE (Microsoft Certified Solution Expert) certification. There are multiple MCSE’s to choose from, each in a different specialization area. The MCSA: BI Reporting certification is a foundation on the path to earning the MCSE: Data Management & Analytics certification.

The way the path from MCSA to MCSE works is that you first earn an MCSA certification by passing the required exams. Then after earning the MCSA of your choice, you need to pick and pass an elective exam from the list of electives that count towards the eligible MCSE for that MCSA certification.

To simplify this, here’s the steps necessary to earn this MCSA and then upgrade to the bigger MCSE certification:

  1. Pass both the above mentioned certification exams to earn the MCSA certification
  2. Choose one of the MCSE: Data Management & Analytics elective exams, and pass it.

As you can see, if you take the MCSA: BI Reporting path to MCSE, you will be required to take and pass a total of 3 Microsoft certification exams. And, there are a number of elective exams for the MCSE: Data Management & Analytics certification.

Happy studying!

Microsoft MVP

Chris Pietschmann is a Microsoft MVP, HashiCorp Ambassador, and Microsoft Certified Trainer (MCT) with 20+ years of experience designing and building Cloud & Enterprise systems. He has worked with companies of all sizes from startups to large enterprises. He has a passion for technology and sharing what he learns with others to help enable them to learn faster and be more productive.
HashiCorp Ambassador Microsoft Certified Trainer (MCT) Microsoft Certified: Azure Solutions Architect