MCSA: BI Reporting

Important

This certification has been retired. For currently available options, please refer to the Browse Certifications and Exams page. Any certifications you earn prior to their retirement dates will continue to appear on your transcript in the Certification Dashboard.

 

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

Job role: Data Analyst

Required exams: 70-778 70-779

Important: See details

Go to Certification Dashboard

Certification details

Skills measured

  • Consuming and Transforming Data By Using Power BI Desktop
  • Modeling and Visualizing Data
  • Configure Dashboards, Reports and Apps in the Power BI Service
  • Consume and Transform Data by Using Microsoft Excel
  • Model Data
  • Visualize Data

Download certification skills outline

Two ways to prepare

Items in this collection

    Learning paths or modules are not yet available for this certification

Certification exams

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

    Languages: en

    Retirement date: **

    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.

    Price based on the country or region in which the exam is proctored.

    for Analyzing and Visualizing Data with Microsoft Power BI

    All objectives of the exam are covered in depth so you'll be ready for any question on the exam.

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

    Languages: en

    Retirement date: **

    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.

    Price based on the country or region in which the exam is proctored.

    for Analyzing and Visualizing Data with Microsoft Excel

    All objectives of the exam are covered in depth so you'll be ready for any question on the exam.

Certification resources

Training and certification guide

Explore all certifications in a concise training and certifications guide.

Certification poster

Check out an overview of fundamentals, role-based and specialty certifications.

Exam Replay

See two great offers to help boost your odds of success.

Support for certifications

Get help through Microsoft Certification support forums. A forum moderator will respond in one business day, Monday-Friday.

Certification dashboard

Review and manage your scheduled appointments, certificates, and transcripts.

Share your certification badges

Celebrate your accomplishment with your network. Claim your Microsoft Certification badge, and add it to LinkedIn, your résumé, and more.

* Pricing does not reflect any promotional offers or reduced pricing for Microsoft Imagine Academy program members, Microsoft Certified Trainers, and Microsoft Partner Network program members. Pricing is subject to change without notice. Pricing does not include applicable taxes. Please confirm exact pricing with the exam provider before registering to take an exam.

** Complete this exam before the retirement date to ensure it is applied toward your certification. After the retirement date, please refer to the related certification for exam requirements.