Power BI Intermediate Course: Beyond the Basics
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 70 lectures (6h 36m) | Size: 2.57 GB

Level up your Business Intelligence skills with this intermediate Power BI course from Microsoft Experts, Simon Sez IT!
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

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

Description
**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 intermediate training course is designed to be a continuation of the Power BI Beginner course. It is then recommended to go through that course first to be familiar with the Power BI basics and interface, or you should already have a basic understanding of Power BI before taking this course.

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:

6+ hours of video tutorials

68 individual video lectures

Course Instructor Files to follow along

Certificate of completion

Who this course is for
Advanced Excel users
Users with basic knowledge of Power BI Desktop
Business Intelligence Analysts