The Power BI data analyst delivers actionable insights by leveraging available data and applying domain expertise. The Power BI data analyst collaborates with key stakeholders across verticals to identify business requirements, cleans and transforms the data, and then designs and builds data models by using Power BI. The Power BI data analyst provides meaningful business value through easy-to-comprehend data visualizations, enables others to perform self-service analytics, and deploys and configures solutions for consumption. Candidates for this exam should be proficient using Power Query and writing expressions by using DAX.
The English language version of this exam will be updated on January 31, 2023. Please download the study guide in the “Tip” box for details on upcoming changes. If a localized version of this exam is available, it will be updated approximately eight weeks after this date.
Passing score: 700. Learn more about exam scores.
Part of the requirements for: Microsoft Certified: Power BI Data Analyst Associate
Related exams: noneGo to Learn Profile
- The English language version of this exam will be updated on January 31, 2023. Download the study guide in the preceding “Tip” box for more details about the skills measured and upcoming changes.
- Prepare the data (15-20%)
- Model the data (30-35%)
- Visualize and analyze the data (30-35%)
- Deploy and maintain assets (10-15%)
Two ways to prepare
Power BI data analysts design and build scalable data models, clean and transform data, and enable advanced analytic capabilities that provide meaningful business value.
Check out an overview of fundamentals, role-based and specialty certifications.
Explore all certifications in a concise training and certifications guide.
Recommended training resources to help you prepare for required exams and earn your certification.
See two great offers to help boost your odds of success.
Get help through Microsoft Certification support forums. A forum moderator will respond in one business day, Monday-Friday.
Review and manage your scheduled appointments, certificates, and transcripts.
Learn more about requesting an accommodation for your exam.
Review the exam policies and frequently asked questions.