US $19.97

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
4 mins
Course Introduction
free preview
9 mins
Setting Up for Success
free preview
Importing and Transforming Data in Power Query
5 mins
Importing Excel Data Files from a Folder
5 mins
Combining Files and Removing Columns
5 mins
Splitting and Merging Columns
4 mins
Applying Data Types
8 mins
Importing Text and CSV Files
7 mins
Relationships and Lookup Tables
8 mins
Duplicate vs Reference
4 mins
Creating a Lookup Table
4 mins
Creating Index Columns
6 mins
Merging Queries
4 mins
Enable/Disable Load and Report Refresh
View more lessons +

About the instructor

Simon Sez IT
Simon Sez IT
  • 34 courses

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 …

Read more
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?
  • Checkout