How I Used Pragmatic Works' Training to Pass the Power BI 70-778 Certification

I recently took and passed the Microsoft certification exam 70-778 for Power BI called Analyzing and Visualizing Data with Microsoft Power BI.  I’ve taken Microsoft certification exams in the past, but for the first time I took the exam using the online proctor method.  I read several reviews by others that had a rough experience with this method of doing exams, but luckily I had a very positive experience.

Now that I’ve taken this exam for myself, I want share how you can use the Power BI training offered by Pragmatic Works to prepare for the 70-778 exam. 

Exam 70-778 Analyzing and Visualizing Data with Microsoft Power BI

The exam is broken down into three sections: Consume and Transform Data By Using Power BI Desktop, Model and Visualize Data, and Configure Dashboards in the Power BI Service. So let’s break down each of these sections of the exam and learn which courses offered by Pragmatic Works would benefit you when studying for these sections.

Consume and Transform Data By Using Power BI Desktop

• Introduction to Power BI:  Module 2 – Data Discover with Power BI Desktop
• Power BI Administration:  Module 5 – On-Premises Data Gateway

• Introduction to Power BI:  Module 3 – Transforming Data
• Advanced Power BI:  Module 1 – R Integration
• Advanced Power BI:  Module 2 – M Query

• Introduction to Power BI:  Module 3 – Transforming Data
• Advanced Power BI:  Module 1 – R Integration

Model and Visualize Data

• Introduction to Power BI:  Module 5 – Creating the Data Model
• Advanced Power BI:  Module 3 – Advanced Data Modeling

• Introduction to Power BI:  Module 6 – Creating Calculated Columns and Tables
• Introduction to Power BI:  Module 7 – Creating Calculated Measures with DAX
• Introduction to DAX:  All Modules!
• Advanced DAX:  All Modules!

• Introduction to Power BI:  Module 7 – Creating Calculated Measures with DAX
• Introduction to DAX:  Module 6 – Creating Calculated Measures
• Introduction to DAX:  Module 7 – Time Intelligence
• Introduction to DAX:  Module 8 – Using X-Functions and A-Functions
• Advanced DAX:  Module 2 – Working with Filter Context
• Advanced DAX:  Module 3 – CALCULATE and Time Intelligence
• Advanced DAX:  Module 4 – Semi-Additive Measures
• Advanced DAX:  Module 5 – Row Context
• Advanced DAX:  Module 6 – Nested Row Context

• Introduction to Power BI:  Module 5 – Creating the Data Model

• Introduction to Power BI:  Module 10 – Creating Interactive Reports
• Advanced Power BI:  Module 1 – R Integration
• Advanced Power BI:  Module 6 – Advanced Visualizations

• Advanced Power BI:  Module 8 – Power BI Embedded

Configure Dashboards in the Power BI Service

• Introduction to Power BI:  Module 11 – Using the Power BI Services

• Introduction to Power BI:  Module 11 – Using the Power BI Services

• Introduction to Power BI:  Module 11 – Using the Power BI Services
• Advanced Power BI:  Module 7 – Power BI Administration
• Power BI Administration:  Module 6 – Power BI Security

• Introduction to Power BI:  Module 11 – Using the Power BI Services
• Power BI Administration:  Module 4 – Sharing and Collaboration

These are some great resources to get you started, but you should always be on the lookout for more!  I’d recommend giving a read to my good friend Dustin Ryan’s blog that covers several other resources that will help you get prepared! To those of you getting ready to take this exam, I wish you luck!

Click here to learn more about our On-Demand Training platform that includes 30+ courses.