Your cart is empty.
Keep shoppingPower BI Intermediate Course: Beyond the Basics
577 students
Power BI Intermediate Course: Beyond the Basics
Learn how to create stunning visualizations with this intermediate Power BI course from Microsoft Experts, Simon Sez IT!
Created bySimon Sez IT
Last updated 3/2023
English
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
Explore related topics
Course content
13 sections • 75 lectures • 8h 38m total length
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
Description
**This course includes downloadable course instructor files to follow along.**
Power BI is a powerful business analytics service from Microsoft. It provides interactive visualizations and business intelligence solutions. Power BI has an intuitive interface, enabling users at all skill levels to create their own reports and dashboards.
This intermediate training course is designed to be a continuation of the introductory Power BI course. If you have no experience with the software, we recommend starting with that course, which will familiarize you with the Power BI basics and interface, basic knowledge that is a prerequisite for the intermediate level.
We start the intermediate course by discussing the data files to be used and some Power BI desktop settings that will set you up for success. The latter part of the course is an intensive exercise to give you practice creating reports and dashboards.
This course includes course files to follow along with your instructor and uses the Power BI Desktop version.
This course will cover:
Importing and transforming data in Power Query
Importing Excel, text, and CSV files and combining files
Enabling/disabling load and report refresh
Resolving data import errors
Data modeling, relationship types, and troubleshooting relationship issues
Measures vs. calculated columns
Creating a date table with DAX
Creating additional and conditional columns
Using the ROUNDUP and SUMX functions
Creating quick measures and key measures tables
The DAX - CALCULATE function
Tables vs. matrix tables
Formatting visualizations and applying conditional formatting
Using column, line, and map charts
Gauge and card visualizations
Using slicers and filters and applying design elements
Creating a shared workspace in Power BI service
Building reports and dashboards
Pinning visualizations to the dashboard
Setting up scheduled refreshes
This course includes:
6+ hours of video tutorials
68 individual video lectures
Course instructor files so you can follow along
Certificate of completion
Here's what our students are saying...
★★★★★ "I like everything! Everything is clear and understandable. Perfect courses!" -Jovita Svilainiena
Who this course is for:
- Advanced Excel users
- Users with basic knowledge of Power BI Desktop
- Business Intelligence Analysts