Recently I 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 with you in this post is how you can use the Power BI training offered by Pragmatic Works to prepare to take the 70-778 exam yourself.

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 breakdown 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
  • Introduction to Power BI:  Module 2 – Data Discover with Power BI Desktop
  • Power BI Administration:  Module 5 – On-Premises Data Gateway
• Perform transformations
  • Introduction to Power BI:  Module 3 – Transforming Data
  • Advanced Power BI:  Module 1 – R Integration
  • Advanced Power BI:  Module 2 – M Query
• Cleanse Data
  • Introduction to Power BI:  Module 3 – Transforming Data
  • Advanced Power BI:  Module 1 – R Integration

Model and Visualize Data

• Create and optimize data models
  • Introduction to Power BI:  Module 5 – Creating the Data Model
  • Advanced Power BI:  Module 3 – Advanced Data Modeling
• Create calculated columns, tables and measures
  • 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!
• 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 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
  • Introduction to Power BI:  Module 5 – Creating the Data Model
• 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
  • Advanced Power BI:  Module 8 – Power BI Embedded

Configure Dashboards in the Power BI Service

• Configure a dashboard
  • Introduction to Power BI:  Module 11 – Using the Power BI Services
• Publish dashboards
  • Introduction to Power BI:  Module 11 – Using the Power BI Services
• 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
  • 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 this training platform that includes 30+ courses.