5 day Power BI Certification Training Course for Exam 70-778

G Com Solutions Limited (in Peterborough) have become the first training company in the United Kingdom to offer a Power BI certification training course.
(Contact G Com Solutions on 0845 129 2872 for further information.)

Passing the Power BI 70-778 exam, on day five of this course, could be your first step towards obtaining Microsoft’s new MCSA: BI Reporting certification. The certification is designed to prove your expertise in analyzing data using Microsoft Power BI and Excel; and requires two exams:

  • 70-778 Analyzing and Visualizing Data with Power BI
  • 70-779 Analyzing and Visualizing Data with Microsoft Excel

The BI Reporting certification does not have a wide range of exam options to choose from, unlike most MCSA qualifications. However, it does provide an opportunity to demonstrate that you are a Microsoft self-service BI specialist.


This instructor-led workshop is aimed at specialists in data analysis, data science, and business intelligence, who wish to validate and demonstrate their knowledge by obtaining the relevant Microsoft certification.

Delegates on this course will need to be familiar with the essentials of data analysis, databases and cloud computing; as well as the key elements of Power BI Desktop and the Power BI service. The topics covered on the course will be mainly at the intermediate and advanced level. Delegates will also need to be native English speakers or speak English fluently.

This five-day certification course provides in-depth coverage of all the topics which you will need to master in order to pass the Microsoft Power BI 70-778 certification: Consume and Transform Data by Using Power BI Desktop; Model and Visualize Data; and Configure Dashboards in the Power BI Service. The training is very much hands-on; and delegates will be given numerous opportunities to complete real-world, practical projects.

Course Outline

DAY ONE: Desktop, service & mobile

Power BI Products & Subscriptions
Reports & Dashboards
Publishing content
Refreshing content


Data connection
Cleaning up & transforming data
Advanced Query Editor Operations
Understanding the M language

DAY THREE: Data  Modelling & DAX

Data modelling
Advanced DAX
Calculated tables


Advanced visualization
Custom Visuals
Power BI Embedded
Power Apps & Flow

DAY five: the exam

There is no training on day 5; this is the day of the exam. (If you prefer not to take the exam immediately after your training, then, for you, the course will finish at the end of day four.)