Resources for the Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI Certification

My other working title: A big ‘ol stash uh links!

If you’re interested in getting certified on Power BI, Microsoft has an exam that will do just that!

The most important link on this whole this is the link to exam objectives. They should be your starting point, and here’s why:

Microsoft starts by writing exam objectives. They have to justify where the answer is for each question they write in the documentation. Then they write the official course, the exam guide, and the exam itself. The people who write the objectives may or may not be part of the group that write any of the other materials- including the exam!

PBI exam diagram

Why you should care: This means that any study material might not cover a detail that is on one of the exam questions. Also! Since the exam is updated more frequently than the the course or exam guide, buying a version that doesn’t correspond with the latest exam version could mean you learn something that has since been changed on the test.

The bottom line here is that you should focus on your ability and knowledge of the exam objectives to be ready for this certification. And read the documentation from Microsoft.

With that said, here are a bunch of links and a possible study plan intended to facilitate your doing that.

**Disclaimer: I don’t vouch for the completeness of covering over all the details included on the exam. (see above for why I think that would be impossible) I also don’t get any kickback from any of these sources. I tried to choose materials that a complete beginner would be able to understand, and that has links where applicable to learn in greater detail. I also tried to choose a variety of sources to expose you to just how many great people are putting content out there for you to follow for future use. Sometimes the most clear answer was to jump into the Microsoft documentation. The context of this list is for the exam version dated July 31, 2017.

Possible Study Plan:

  1. EdX Course – Analyzing and Visualizing Data with Power BI
  2. Read through all the documentation
  3. Click all the buttons and know what they do in PBI Desktop (including power Query), Power BI Service
  4. Learn about the admin portal – here is a tutorial on how to get a trial tenant:
  5. Read through all the objectives, make sure you understand each one, and common mistakes one could make.
  6. Do a deep dive on google for tutorials on subjects that you haven’t had experience with yet, or don’t have access to in your org (like the admin portal!)


And now for the exam objectives themselves!

Consuming and Transforming Data By Using Power BI Desktop

  • Connect to data sources. May include: Connect to databases, files, folders; import from Excel; connect to SQL Azure, Big Data, SQL Server Analysis Services (SSAS)

Modeling and Visualizing Data

Configure Dashboards, Reports, and Apps in the Power BI Service

I’ll be editing this list soon to make it easier to read, I’m just airport hopping at the moment trying to get home. 🙂

Con Mucho Am(ad)or,