Power BI Beyond the Basics

——   Created by Simon Sez IT

Learn how to create stunning visualizations and level up your Power BI skills with this intermediate Power BI course

Share this course:

NEW
Course
68
Lessons
6h 34m
Lesson time
intermediate
Skill level

More about this course

Power BI is a powerful, self-service Business Intelligence (BI)solution from Microsoft. It aims to provide interactive visualizations and is used to import, transform, and analyze data. Power BI has a user-friendly interface ideal for people with a limited technical background to create their own reports and dashboards.

This intermediate Power BI course is designed to be a follow-on from the Power BI Beginner course, so it is ideally recommended to go through that course first to get a handle of the basics and be familiar with the Power BI interface. Otherwise, you are expected to at least have a basic understanding of Power BI as this course covers a quick recap of the basics but not in as much detail.

In this course, we start off by going through the data files to be used and checking some PowerBI settings to set you up for success in learning Power BI. The last part of the course is one big exercise where you will have plenty of practice building reports and dashboards.

This course also includes course files to follow along with the instructor and uses the PowerBIDesktop version.

In this course, you will learn

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

68 Lessons

Introduction
0:03:11
Course Introduction
free preview
0:08:18
Setting Up for Success
free preview
Importing and Transforming Data in Power Query
0:04:21
Importing Excel Data Files from a Folder
0:04:33
Combining Files and Removing Columns
0:04:55
Splitting and Merging Columns
0:03:47
Applying Data Types
0:07:11
Importing Text and CSV Files
0:06:41
Relationships and Lookup Tables
0:07:07
Duplicate vs Reference
0:03:28
Creating a Lookup Table
0:03:43
Creating Index Columns
0:05:19
Merging Queries
0:03:22
Enable/Disable Load and Report Refresh
View more lessons +
This course is included in Arbington Premium
$15/month gets you access to every course. Start your 14 day trial today. ☝️

Class benefits

  • Certificate of Completion
  • 30 day satisfaction guarantee
  • 24/7 streaming access
  • Direct teacher access
  • 6h 34m of on-demand video
  • 6 downloadable files
  • Have a coupon?

About the instructor

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no …

View full profile

For super learners, get unlimited access for $15 per month

Start your 14 day free trial. Cancel at any time.

Join Today Learn More