Power BI – Intermediate

March 2, 2020
|By Parker Stevens

Level up your Power BI skills with this amazing course! These lessons will take you from an intermediate to an advanced user of Power BI. Take a look at all of the lessons on the right side of the page! Here are some of my favorite topics that we cover:

  • Creating a custom date table
  • KPIs
  • Drill-through
  • Report-page tooltips
  • Bookmarks
  • What-if Parameters
  • Data alerts
  • Live connections to Power BI datasets
  • And many, many more!

At the end of this course, you will be in the top tier of Power BI developers as you will understand so much of the Power BI framework. You will confidently navigate both Power BI Desktop and Power BI Service and can easily build dynamic and beautiful Power BI reports loaded with functionality!

Course Information

Difficulty: Intermediate

Categories:

Course Instructor

Parker Stevens Parker Stevens Author

Parker is the creator of the BI Elite YouTube channel, a community of over 30,000 students learning Power BI, DAX, and Power Query. He is a Microsoft Data Platform MVP for his work with Power BI and continues to provide elite Power Platform training courses to help data analysts, BI developers, and citizen dashboard creators reach their goals. Parker is committed to producing high-quality training content that is also extremely cost-effective, to ensure that the largest amount of users can benefit from the content. Training courses located at https://training.bielite.com/

Introduction

Course Outline
Level up your Power BI skills with this amazing course! These lessons will take you from an intermediate to an [...]
Downloadable Materials
For each lesson of this course, you will find a .zip file containing useful files for your Power BI journey. [...]

Intermediate Data Connections

Import vs DirectQuery
In this lesson, we will learn the differences between the Import and DirectQuery methods of connecting to data in Power [...]
Custom Date Table
Learn why you should use a date table in your data model. Lesson Downloads 2bDownload
Duplicating vs Referencing Queries
Why would you duplicate a query? When should you reference a query instead? Learn all of the answers in this [...]

Data Modelling

Fact & Dimension Tables
Learn how to utilize fact and dimension tables in Power BI. This is key to understanding how to set up [...]
Bi-Directional Relationships
In this lesson, we will learn what bi-directional relationships are and why we would (and wouldn't) use them. Lesson Downloads [...]
Inactive Relationships (USERELATIONSHIP)
Learn how to use inactive relationships in Power BI to compliment the active relationships of your data model. This lesson [...]

Visualizations You Should Know

KPIs
In this lesson, we will learn how to use the powerful KPI visual. A KPI is like a card that [...]
Bar Charts
One of the most common visuals in Power BI is the bar chart. Learn the different kinds of bar charts [...]
Combo Charts
Combo charts combine both bar charts and line charts in a single visual. This allows you to have two y-axes [...]
Tables               
Tables are one of the most common visuals and are very useful to show a large amount of information in [...]
Matrix
A matrix is like a table on steroids. Learn why and how to use one in this lesson. Lesson Downloads [...]
Slicers (All Kinds)
Slicers allow you to filter your data quickly and easily. There are a large number of slicer modes to choose [...]
Custom Visuals
Power BI comes with a lot of built-in visuals, but sometimes you may find yourself wanting something different. Luckily, there [...]

Expression-Based Formatting

Icons (Traffic-Light KPI)
In this lesson, you will learn how to conditionally format a table using icons! Icons work like traffic-light KPIs and [...]
Formatting By Field Value
In this lesson, we will learn the advanced topic of conditionally formatting an object based on a field value. This [...]
Conditional Titles
In this lesson, we will learn how to make a title change based on slicer selections! This is a form [...]

Key Power BI Functionalities

Drill-Through
Drill-through actions are an incredibly powerful way to navigate a user from a summary view to a detailed view. Power [...]
Hierarchies
Hierarchies allow you to drill down from one level to another to another. You may have seen date hierarchies in [...]
Selection Pane
Although the selection pane isn't a game-changing feature by itself, it is extremely useful in conjunction with bookmarks. Let's quickly [...]
Bookmarks & Buttons
Bookmarks are perhaps the most important functionality within Power BI. Bookmarks allow you to save the state of the Power [...]
Filter Pane
In this lesson, we learn how to use the filter pane to apply filters to individual visuals, an entire tab, [...]
What-If Parameters
What-if parameters provide a seamless way to give the end-user the ability to change scenarios on the report. In our [...]
Report Page Tooltips
Rounding off our Key Power BI Functionalities section, we have one of my favorite tricks. Report page tooltips allow you [...]

Intermediate Power BI Service

Data Alerts
Stay up to date with what's happening with your data! Set up alerts on Power BI Service to be informed [...]
Personalized Bookmarks
Bookmarks are great, but it's difficult to account for every scenario that your users might want to see. Personalized bookmarks [...]
Adding Comments to a Report
Learn how to add comments to your Power BI report to let your co-workers know your thoughts! Instantly share interesting [...]
Live Connections to Power BI Datasets
In this lesson, you will learn how to connect to a Power BI dataset using a live connection! This is [...]

Putting It All Together

Using Your New Skills
Let's use all of our newly-learned skills to create a truly impressive Power BI report! By the end of this [...]

Final Words

Power BI Intermediate Course Feedback
By submitting a review, you give BI Elite permission to use your rating and feedback for promotional purposes. We only [...]
Congratulations and Next Steps
Congratulations on completing the entire Intermediate course! You now know so much of the Power BI framework. Take it to [...]