MCSA BI Reporting

Earn a Microsoft certification and build your professional career in BI Reporting

This certification demonstrates your expertise in analyzing data with both Power BI and Excel.

Earning an MCSA: BI Reporting demonstrates knowledge relevant to data analysis, data visualization, modeling, dashboards, and direct connectivity to data sources in Excel and Power BI. It is the first step on your path to becoming a Data Management and Analytics Microsoft Certified Solutions Expert (MCSE).

What is involved

STEP 1 - SKILLS

Experience consuming and transforming data, modeling and visualizing data, and configuring dashboards using Excel and Power BI.

STEP 2 - EXAMS

Pass 2 required exams. Be sure to explore the exam prep resources.

Exam 70-778/Course 20778A

Analyzing and Visualizing Data with Power BI

Candidates for this exam should have a good understanding of how to use Power BI to perform data analysis. Candidates should be proficient in connecting to data sources and performing data transformations, modeling and visualizing data by using Microsoft Power BI Desktop, and configuring dashboards by using the Power BI service. Candidates should also be proficient in implementing direct connectivity to Microsoft SQL Azure and SQL Server Analysis Services (SSAS), and implementing data analysis in Microsoft Excel. Candidates may include BI professionals, data analysts, and other roles responsible for creating reports by using Power BI.

Exam 70-779/Course 20779A

Analyzing and Visualizing Data with Microsoft Excel

Candidates for this exam should have a strong understanding of how to use Microsoft Excel to perform data analysis. Candidates should be able to consume, transform, model, and visualize data in Excel. Candidates should also be able to configure and manipulate data in PowerPivot, PivotTables, and PivotCharts. Candidates may include BI professionals, data analysts, and other roles responsible for analyzing data with Excel.

STEP 3 - CERTIFICATION

Complete an MCSA BI Reporting certification by passing the required exams in Step 2.

STEP 4 - CONTINUING EDUCATION

  • Earn an MCSE to broaden and advance skills.

MCSE Data Management and Analytics

Demonstrate your broad skill sets in SQL administration, building enterprise-scale data solutions, and leveraging business intelligence data both on-premises and in cloud environments.