Welcome to ONLC Training Centers

Microsoft BI Tools On-Demand: Analyzing Data with Power BI (20778) Course Outline

 (3 days)
Special Note to New Hampshire Residents
This course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.

- Exam 70-778 is scheduled to retire January 31, 2021 -

*** Note: This is an On-Demand (self-study) course, 3-days of content, 6-months unlimited access, $995***
(Applicable State and Local taxes may be added for On-Demand purchases, depending on your location.)
This On-Demand, self-study course is a great fit for experienced IT professionals who don't need a traditional 5-day class to upgrade their existing skills or for highly-motivated individuals who are new to the technology and need to space their learning over a period of weeks or months. Note: The 6-month access period will begin at time of purchase.

Audience profile
The primary audience for this course is BI professionals who need to analyze data utilizing Power BI. The secondary audiences for this course are technically proficient business users.

About This Course
This online On-Demand (self-study) training solution includes hours of expert lectures, demonstrations, lab exercises and digital courseware. You may take this class at any time; there are no set dates. You may pick and choose topics to make the most effective use of your time and can repeat sections as needed until you master the new concepts.

This On-Demand (self-study) course provides students with the knowledge and skills to analyze data with Power BI.
After completing this course, students will be able to:
Describe self-service BI.
Describe the Power BI suite of products.
Connect to data sources and optimize data models.
Shape and combine data from different sources.
Model data.
Create reports and manage solutions.
Describe the Power BI developer API.
Describe the Power BI mobile app.

In addition to their professional experience, students should have the following technical knowledge:
Basic knowledge of the Microsoft Windows operating system and its core functionality.
Basic knowledge of data warehouse schema topology (including star and snowflake schemas).
Some exposure to basic programming concepts (such as looping and branching).
An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
Familiarity with Microsoft Office applications particularly Excel.

ONLC Extras & Add-ons

24/7 Online Support - Included at no additional cost
You will be able to chat online with a content matter expert while you are taking your On-Demand course. (3-month access).

Certification Pak, $150
Interested in obtaining certification? Purchase a practice exam and a Microsoft exam voucher at a reduced price of $150.00.

ILT Listener, $250
Want to listen in and follow along with a live Instructor-Led Training (ILT) class? We offer this option for individuals on a limited budget who have time during the day to hear a live class in progress. ILT Listeners have access to their online support chat expert during the class but they do not have direct access to the live instructor.

LT Participant, $ Varies
You've purchased the On-Demand, have gone through the training and decided that you still want a live class. Just pay difference between the On-Demand course and and the Instructor-Led Training (ILT) class and you can have a seat in our live class. Get both self-study and live, instructor-led training for the retail price of the instructor-led class alone!

Do You Still Prefer a Live, Instructor-led Class?
Already know On-Demand is not right for you? We also offer this same course content in a live, instructor-led format. For more details, click on the link below:
20778 Instructor-led Training Class

Course Outline

Module 1: Introduction to Self-Service BI Solutions
Introduction to Business Intelligence
Introduction to Data Analysis
Introduction to Data Visualization
Overview of Self-Service BI
Considerations for Self-Service BI
Microsoft Tools for Self-Service BI
Lab : Exploring an Enterprise BI Solution
Viewing Reports
Creating a Power BI Report
Creating a Power BI Dashboard

Module 2: Introducing Power BI
Using Excel as a Data Source for Power BI
The Power BI Data Model
Using Databases as a Data Source for Power BI
The Power BI Service
Lab : Importing Data into Power BI
Importing Excel files into Power BI
Viewing Reports from Excel Files

Module 3: Power BI Data
Using Excel as a Data Source for Power BI
The Power BI Data Model
Using Databases as a Data Source for Power BI
The Power BI Service
Lab : Importing Data into Power BI
Importing Excel files into Power BI
Viewing Reports from Excel Files

Module 4: Shaping and Combining Data
Power BI Desktop Queries
Shaping Data
Combining Data
Lab : Shaping and Combining Data
Shape Power BI Data
Combine Power BI Data

Module 5: Modeling Data
DAX Queries
Calculations and Measures
Lab : Modeling Data
Create Relationships

Module 6: Interactive Data Visualizations
Creating Power BI Reports
Managing a Power BI Solution
Lab : Creating a Power BI Report
Connecting to Power BI Data
Building Power BI Reports
Creating a Power BI Dashboard

Module 7: Direct Connectivity
Cloud Data
Connecting to Analysis Services
Lab : Direct Connectivity
Direct Connections to Power BI

Module 8: Development with Power BI
The Power BI API
Custom Visuals
Lab : Using Marketplace Visualizations
Using a Custom Visualization

Module 9: Power BI Mobile
Power BI Mobile Apps
Using the Power BI Mobile App
View outline in Word


Attend hands-on, instructor-led Microsoft BI Tools On-Demand: Analyzing Data with Power BI (20778) training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.

Microsoft Gold Partner


Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Attend computer classes from ONLC Training Centers Request a copy via mail


Class Format
Class Policies
Student Reviews

Bookmark and Share

First Name

Last Name