Power BI Beginners to Intermediate Course: Beyond the Basics

Learn to create stunning visualizations in Power BI course from Microsoft Experts, Simon Sez IT!

**This course includes downloadable course instructor files to follow along.**

What you’ll learn

  • How to Import and Transform Data in Power Query.
  • Importing Excel, Text, and CSV files and combining files.
  • How to enable/disable Load and Report Refresh.
  • Resolving Data Import Errors.
  • Data Modelling, Relationship Types, and Troubleshooting Relationship Issues.
  • Measures vs Calculated Columns.
  • Creating a Date Table with DAX.
  • Creating Additional and Conditional Columns.
  • How to use ROUNDUP and SUMX.
  • Creating Quick Measures and a Key Measures Table.
  • The CALCULATE Function in DAX.
  • Tables vs Matrix Tables.
  • Formatting Visualizations and applying Conditional Formatting.
  • Using Column, Line, and Map Charts.
  • Gauge and Card Visualizations.
  • Using Slicers and Filter and applying Design Elements.
  • Creating a Shared Workspace in Power BI Service.
  • Creating Reports and Dashboards.
  • Pinning Visualizations to the Dashboard.
  • How to set up Scheduled Refreshes.

Course Content

  • Introduction –> 4 lectures • 14min.
  • Importing and Transforming Data in Power Query –> 14 lectures • 1hr 7min.
  • Data Modelling –> 3 lectures • 16min.
  • DAX – Essential Skills –> 10 lectures • 50min.
  • DAX – CALCULATE Function –> 3 lectures • 14min.
  • Visualizations –> 11 lectures • 1hr 33min.
  • The Power BI Service –> 5 lectures • 21min.
  • Orders Dashboard Example – Preparation –> 3 lectures • 9min.
  • Orders Dashboard Example – Transformation –> 5 lectures • 35min.
  • Orders Dashboard Example: Report –> 9 lectures • 1hr 5min.
  • Orders Dashboard Example: Dashboard –> 2 lectures • 10min.
  • Course Close –> 1 lecture • 2min.

Power BI Beginners to Intermediate Course: Beyond the Basics

Requirements

  • A basic understanding of Power BI and its interface is essential as this is an intermediate course.
  • Power BI Desktop installed on your machine is required to take the practice exercises.
  • A good knowledge of MS Excel is advised but not necessary.
  • It is recommended to go through the Power BI Beginner course first, but is not required.

**This course includes downloadable course instructor files to follow along.**

 

Power BI is a powerful Business Analytics service from Microsoft. It intends to provide interactive visualizations and business intelligence solutions. Power BI has a simple enough interface for users with limited technical skills to be able to create their own reports and dashboards.

This Power BI training course starts by going over some of the Power BI basics before launching into how to utilize Power BI to visually display data. This course is focused more on some of the intermediate skills in Power BI, however, we are sure to cover off the basics before we launch into the more complex areas of this amazing Business Intelligence tool.

We start off this course by going through the data files to be used and some Power BI Desktop settings to set you up for success in learning Power BI. The latter part of the course is a big exercise where you can have a lot of practice creating reports and dashboards.

This course includes course files to follow along with your instructor and uses the Power BI Desktop version.

 

In this course you will learn:

  • How to Import and Transform Data in Power Query
  • Importing Excel, Text, and CSV files and combining files
  • How to enable/disable Load and Report Refresh
  • Resolving Data Import Errors
  • Data Modelling, Relationship Types, and Troubleshooting Relationship Issues
  • Measures vs Calculated Columns
  • Creating a Date Table with DAX
  • Creating Additional and Conditional Columns
  • How to use ROUNDUP and SUMX
  • Creating Quick Measures and a Key Measures Table
  • The CALCULATE Function in DAX
  • Tables vs Matrix Tables
  • Formatting Visualizations and applying Conditional Formatting
  • Using Column, Line, and Map Charts
  • Gauge and Card Visualizations
  • Using Slicers and Filter and applying Design Elements
  • Creating a Shared Workspace in Power BI Service
  • Creating Reports and Dashboards
  • Pinning Visualizations to the Dashboard
  • How to set up Scheduled Refreshes

 

This course bundle includes:

  1. 6+ hours of video tutorials
  2. 68 individual video lectures
  3. Course Instructor Files to follow along
  4. Certificate of completion