Power BI Beyond the Basics: Power BI Intermediate Online Course

Power BI is an incredibly powerful, self-service Business Intelligence (BI) solution from Microsoft. Learn the data files to be used and some Power BI settings to set you up for success in learning.

Your 100% online, self-paced Power BI Intermediate Course includes:

-7+ hours of Power BI Training Course designed by industry experts
–Learn at your own pace whenever and wherever you want, even if you work full-time
-In this course, we discuss the data files to be used and some Power BI settings to set you up for success in learning.
-Plus, one big exercise, giving you plenty of practice building reports and dashboards
-This course also includes course files to follow along with the instructor and uses the Power BI Desktop version.

"Master of Project Academy allows professionals to advance their training at a schedule that fits their busy life. No set dates, no set number of hours. No need to take time off to accommodate a course schedule in a physical classroom. And with 24 hour assistance, professionals have access to help whenever they need it."

Power BI Intermediate Training Course is ideal for you if you’re looking to create beautiful looking charts and graphs that generate business insight and fuels decision making.

See Pricing

68+ Lectures

7+ Hours

Lifetime Access option

30 day money back guarantee!

100% Online & Self-Paced

Course Completion Certificate

Enroll in a Microsoft Appreciated Training
Learn about the data files to be used and some Power BI settings to set you up for success in learning
One big exercise, giving you plenty of practice building reports and dashboardss
Downloadable course files to follow along with the instructor and uses the Power BI Desktop version
Get prompt answers & support from the instructor within 24 hours!
Test yourself with quizzes at the end of the sections
Earn 10 PDUs if you are a PMP already

Microsoft Power BI is used by hundreds of millions of people around the world. Students, Accountants, Engineers, Managers, Architects, Doctors and many other professions are using Power BI as a self-service Business Intelligence (BI) solution from Microsoft. Power BI is user friendly and perfect for people with a limited technical or programming background.

This training is most suited for:

Data Analysts
Students
Engineers
Project Managers
Accountants
Anyone using Microsoft Power BI
Anyone who wants to learn how to use Power BI

What is Microsoft Power BI?

Power BI is an incredibly powerful, self-service Business Intelligence (BI) solution from Microsoft. It imports data from multiple sources, which you can then transform and analyze with a range of visual tools. Power BI has a user-friendly interface ideal for people with a limited technical background, allowing them to create their own reports and dashboards.

What is in this Intermediate Microsoft Power BI Training Program?

Microsoft Power BI Intermediate course program includes 12 different sections.

More

This intermediate Power BI course is designed to build on the material covered in our Power BI beginner-level course, so it is ideally recommended to go through that course first, which will give you a good handle on the basics and familiarity with the interface. If you already have a preliminary understanding of Power BI’s functionality, this intermediate course is right for you. In this course, we discuss the data files to be used and some Power BI settings to set you up for success in learning. The last part of the course is one big exercise, giving you plenty of practice building reports and dashboards.This course uses the Power BI Desktop version. It also includes course files to follow along with the instructor.

In this Microsoft Power BI Intermediate Online Training Course course you will learn...

Importing and transforming data in Power Query.

Importing Excel, text, and CSV files and combining files.

Enabling/disabling load and report refresh.

Resolving data import errors.

Getting started with data modeling and relationship types.

Learning measures vs. calculated columns.

Creating a date table with DAX.

Creating additional and conditional columns.

Using the ROUNDUP and SUMX functions.

Creating quick measures and key measures tables.

Using the DAX – CALCULATE function.

Using tables vs. matrix tables.

Formatting visualizations and applying conditional formatting.

Building column, line, and map charts.

Adding gauge and card visualizations.

Using slicers and filters and apply design elements.

Creating a shared workspace in the Power BI service.

Building reports and dashboards.

Pinning visualizations to the dashboard.

Setting up scheduled refreshes.

Do I need Microsoft Power BI Program?

Our Microsoft Power BI Training is 100% online and self-paced. Lectures do not require you to have a MS Power BI on your PC. However, we recommend you to practice what you learned during the Microsoft Power BI Training course. Therefore, we advise you to obtain a MS Power BI license and try to apply what you learn throughout the Power BI course.

Curriculum

Section 1: Introduction

Available in days

days after you enroll

Preview
Welcome to Master of Project Academy (1:19)
Preview
How to Utilize Power BI Training?
Start
Course Introduction (3:11)
Start
Setting Up for Success (8:18)
Start
Course Files
Start
Quiz

Section 2: Importing and Transforming Data in Power Query

Available in days

days after you enroll

Start
Combining Files and Removing Columns (4:33)
Start
Importing Excel Data Files from a Folder (4:21)
Start
Splitting and Merging Columns (4:55)
Start
Applying Data Types (3:47)
Start
Importing Text and CSV Files (7:11)
Start
Relationships and Lookup Tables (6:41)
Start
Duplicate vs Reference (7:07)
Start
Creating a Lookup Table (3:28)
Start
Creating Index Columns (3:43)
Start
Merging Queries (5:19)
Start
Enable/Disable Load and Report Refresh (3:22)
Start
Advanced Editor (4:49)
Start
Resolving Data Import Errors (5:07)
Start
Organizing Queries into Groups (3:00)
Start
Quiz

Section 3: Data Modelling

Available in days

days after you enroll

Start
Troubleshooting Relationship Issues (6:21)
Start
Relationship Types (5:28)
Start
Cross Filter Direction (4:36)
Start
Quiz

Section 4: DAX - Essential Skills

Available in days

days after you enroll

Start
Measures vs Calculated Columns (10:56)
Start
Creating a Date Table with DAX (6:45)
Start
Creating Additional Columns (5:16)
Start
Creating Conditional Columns (2:21)
Start
Marking Table as a Date Table (2:48)
Start
Using ROUNDUP to Extract Quarters (2:06)
Start
Creating Quick Measures (5:41)
Start
Creating a Key Measures Table (3:27)
Start
Aggregation Methods (5:12)
Start
Using SUMX (5:47)
Start
Quiz

Section 5: DAX - CALCULATE Function

Available in days

days after you enroll

Start
Changing Context with FILTER (3:37)
Start
The CALCULATE Function (4:33)
Start
Using ALL with CALCULATE (5:26)
Start
Quiz

Section 6: Visualizations

Available in days

days after you enroll

Start
Tables vs Matrix Tables (6:24)
Start
Visualizations (8:37)
Start
Formatting Visualizations - Part 1 (6:46)
Start
Formatting Visualizations - Part 2 (3:07)
Start
Conditional Formatting (12:42)
Start
Column and Line Charts (13:55)
Start
Card Visualizations (5:51)
Start
Map Charts (9:41)
Start
The Gauge Visualization (9:38)
Start
Slicers and Filter (8:28)
Start
Applying Design Elements (7:54)
Start
Quiz

Section 7: The Power BI Service

Available in days

days after you enroll

Start
Inviting Others to a Shared Workspace (1:53)
Start
Creating a Shared Workspace in Power BI Service (4:51)
Start
Reports vs Dashboards (1:59)
Start
Pinning Visualizations to the Dashboard (7:10)
Start
Setting up Scheduled Refreshes (5:14)
Start
Quiz

Section 8: Orders Dashboard Example - Preparation

Available in days

days after you enroll

Start
Report Requirements (3:59)
Start
Orders Dashboard Example (3:30)
Start
Importing Order Data (1:25)
Start
Quiz

Section 9: Orders Dashboard Example - Transformation

Available in days

days after you enroll

Start
Creating Lookup Tables (5:38)
Start
Transforming Order Data in Power Query (1:55)
Start
Merging Queries (5:36)
Start
Creating a Dates Table (11:10)
Start
Creating DAX Measures (10:57)
Start
Quiz

Section 10: Orders Dashboard Example: Report

Available in days

days after you enroll

Start
Adding a Report Title (9:50)
Start
Report Navigation with Buttons and Bookmarks (10:23)
Start
Card Visualizations and Filtering (12:39)
Start
Line Chart: Count of Male vs Female Customers (7:13)
Start
Stacked Column Chart: Total Revenue by Region (6:00)
Start
Treemap Chart: Count of Orders by Year/Month (5:59)
Start
Funnel Chart: Age Distribution (6:18)
Start
Matrix Table: Count of Customers by Type and Status (4:32)
Start
Adding Conditional Formatting (2:16)
Start
Quiz

Section 11: Orders Dashboard Example: Dashboard

Available in days

days after you enroll

Start
Publishing the Report to the Power BI Service (3:15)
Start
Pinning Media Tiles to Dashboard (6:32)
Start
Quiz

Section 12: Course Close

Available in days

days after you enroll

Start
Course Close (1:50)

Tip #1 - Join LinkedIn Community

Available in days

days after you enroll

Start
Join LinkedIn Community & Follow Latest Updates

How to Submit a PDU Claim (For Retaining PMP Certificate)

Available in days

days after you enroll

Start
How to Submit PDUs

Bonus Lecture - Discount for our paid courses

Available in days

days after you enroll

Start
Bonus Lecture - Discount for our paid courses

Important Notice About Certificate of Completion

Available in days

days after you enroll

Start
Important Notice About Certificate of Completion

What Our Community Is Saying

300,000+ professionals enrolled from 100+ organizations including these reputable organizations

Master of Project Academy Clients

Master of Project Academy is an Accredited Business by Better Business Bureau®

What does this mean? This means all figures, claims, and reviews of Master of Project Academy are audited and backed up. BBB® reviews the pass rate, student reviews, and all claims of our website, and make sure that they are genuine, authentic and made by real students enrolled in our courses.

You can see several authentic and genuine reviews on our BBB, Google, and TrustPilot Pages.

Microsoft Power BI Intermediate Training is brought to you by Master of Project Academy.
So far we’ve helped over 300,000 professionals from 180 countries to advance their career.

Will you be our next success story?

Enroll Now

Everything you need to train for Microsoft Power BI

Ready to get serious about learning MS Power BI? Your new data analyst and BI professional career opportunities depend on it.
Enroll today and give yourself the best chance to create the best in Power BI…
100% online training, learn at your own pace from wherever you want

In-person, virtual, and hybrid group training formats are available for this program.

For group and corporate training solutions, please

Request a Quote

Monthly

$47

per month

Benefits of a monthly subscription:

The faster you complete the course, the less you pay

Get continuous access to the course - auto-billing means no manual payment hassles.
Cancel anytime

Enroll

Annual

$97

1-year duration

Benefits of an annual subscription:

Learn at your own pace - take your time to complete the training and fully prepare for the certification exam

Revisit key lectures and highlights to give yourself the best chance of passing

Enroll

Lifetime

$147

lifetime access

Benefits of lifetime course access:

Pay once, get forever access to course materials and all future updates at no additional cost

Revisit key lectures and highlights to give yourself the best chance of passing

Enroll

30 Day Money Back Guarantee - Our Overall Full Refund Rate is < 1%

Master of Project Academy Featured In The Media

Forbes

Wall Street Journal

Capterra

Project-Management.com

ThoughtCo.

Yahoo Finance

"Master of Project Academy’s free PMP training course is 100% online and self-paced, containing three sections of learning material. The course includes over 25 lectures, plus an assortment of resources for those wanting more information."

"Master of Project Academy offers the best solution, with flexible online courses at a fraction of the cost of other certification training courses. Courses can be taken from anywhere, anytime, with just an Internet connection."

"Master of Project Academy courses cover everything you need in a direct, accessible manner. All the reviews of Master of Project Academy are overwhelmingly positive. Students call out their favorite teachers and rave about how easy passing the exam is following Master of Project Academy’s instruction."

"Master of Project Academy delivers 100% online, self-paced and 30-day money back guaranteed on certification courses. High quality premium certification courses are offered at low prices in comparison to other certification institutions."

"Master of Project Academy has a surprising pass rate of 99.6 percent; more than 125,000 of its students have passed the certification. But if that figure still doesn’t inspire total confidence in you, rest easy knowing that the program offers all of its students a money-back guarantee."

"Courses are offered to students and professionals worldwide who seek to expand their knowledge base or need help preparing for a variety of professional certification exams. Courses are self-paced and conducted entirely online, with access to 24 hour support."

Frequently Asked Questions

When does the course start and finish?

Master of Project Academy courses are designed to be flexible and affordable, so you can learn how you choose.

You can begin the course from the moment you enroll. Get instant access to all the lectures, videos and materials and train for certification at your own pace.

There’s no deadline to complete the course – you can watch and re‐watch as many times as you like, giving yourself the best chance at passing your certification exam at the first attempt.

What if I am unhappy with the course?

All our courses come with a full 30-day guarantee for your protection. Our overall refund rate is less than 1% from 300,000+ students who have used our course to train for Microsoft Power BI.

But if for any reason you decide to cancel, just email [email protected] within 30 days of enrollment, and we’ll refund your payment in full.

Any further questions?

We’re happy to answer them! Please visit our FAQ page for more details or email [email protected].

How long can I access the course for?

For however long you need it. You can choose from monthly access, one‐year access or lifetime access below. If you select monthly access you will be auto-billed on the same day each month, and can access the full course at any time until you cancel.

If you want to take longer to study the course, you can select annual or lifetime access to give yourself more time to watch and re-‐ watch the lectures. Lifetime access is exactly that – you will never lose access and will receive free course content updates forever.

Who teaches the course?

Master of Project Academy instructors has several years of experience in their fields and each has major industry experience including but not limited to IT, banking, telecommunications, consultancy, non-profit organizations, military, energy, and more.

Read more about Master of Project Academy Instructors.