Microsoft BI

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.

MCSA BI Reporting

Key technologies

  • Power BI
  • Microsoft Excel

What is involved

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).

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.

STEP 3 - CERTIFICATION

Earn your MCSA: BI Reporting.

STEP 4 - CONTINUING EDUCATION

Earn an MCSE by passing 1 related exam.

Certification Exams and prep resources

70-778

Exam 70-778/Course 20778

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.

View exam details

Optional training

70-779

Exam 70-779/Course 20779

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.

View exam details

Optional training

MCSA BI ReportingMCSA: BI Reporting

Analyze data with Power Bi and Microsoft Excel

Completed this certification?

Visit Your dashboard

MCSE Data Management and AnalyticsMCSE: 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.

Explore this certification