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.
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
Connect to Data Sources
Perform Transformations
Cleanse Data
Model and Visualize Data
Create and optimize data models
Create calculated columns, tables and measures
Create performance KPIs
-
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
Create hierarchies
Create and format interactive visualizations
-
Introduction to Power BI: Module 10 – Creating Interactive Reports
-
Advanced Power BI: Module 1 – R Integration
-
Advanced Power BI: Module 6 – Advanced Visualizations
Manage custom reporting solutions
Configure Dashboards in the Power BI Service
Configure a dashboard
Publish dashboards
Configure security for dashboards
-
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
Configure organizational content packs and apps
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 50+ courses.