Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Power BI Essentials
Introduction
Important: An overview of Power BI (3:42)
What you learn in this course (2:36)
About your instructor (1:44)
How to achieve your Power BI dreams with this course (2:59)
Your IT setup (2:21)
Getting started
Module introduction (0:23)
When to use Power BI - and when not to (3:23)
Quick tour: How to use Power BI (3:34)
Getting started with Power BI (4:50)
Navigating Power BI (2:21)
Your first report, step by step (3:48)
Quiz
Get data
Module introduction (1:31)
Get data from Excel (3:59)
Arranging Excel data before import (4:07)
Get data from CSV file (1:30)
Get data from a database (1:49)
Connecting with other services (2:26)
For advanced users: Power BI Data Gateway (6:37)
Quiz
Assignment
Data analysis
What is data analysis? (2:07)
Data analysis in reporting (5:30)
Using the 25-5 rule to make better reports (2:33)
Quiz
Visualize data with 'reports'
Module introduction (1:13)
How to set up a report (9:02)
Personal reporting with Drilldown/Drillthrough (4:10)
Formatting your visualizations (5:46)
Best practice (8:13)
Quiz
Assignment
Visualize data with 'dashboards'
Module introduction (0:50)
Difference between dashboards and reports (2:12)
Setting up a dashboard (3:14)
Pin elements to your dashboard (3:46)
Quick insights (4:07)
Choose featured and favorite dashboards (1:58)
Ask questions about your data (3:26)
Quiz
Assignment
Using what you've learned so far
Module introduction (0:36)
Recap of everything so far (4:49)
Big Assignment - Reports and Dashboards (2:33)
Big Assignment - Solution Walkthrough, part 1 (12:14)
Big Assignment - Solution Walkthrough, part 2 (11:16)
Filtering reports
Module introduction (1:10)
Filtering a report (6:12)
Controlling filters (5:16)
Default filter (1:24)
Using slicers (4:37)
Quiz
Assignment
Sharing reports, dashboards, and data
Module introduction (1:00)
Share reports (2:54)
Subscribing to reports (3:57)
How to use comments (3:36)
Share dashboards (1:52)
Getting alerts (3:25)
Share workspaces (5:27)
Bookmarks (5:24)
Printing and other ways of sharing in Power BI (5:14)
Quiz
Assignment
Editing data before visualization with Power Query
Module introduction (1:50)
Power BI Desktop (3:33)
Get data (2:40)
Edit data in Power Query (5:09)
Filters in Power Query (4:21)
Change data types (3:48)
Split columns (2:41)
Remove duplicates and blanks (4:14)
Join Excel files (5:17)
Data tables and their relationships (9:52)
Quiz
Assignment
Writing formulas with DAX
Module introduction (2:34)
DAX measures (3:46)
SUM and COUNT (6:11)
Division and other mathematical operations (2:18)
Evaluating DAX formulas (+AVERAGEX) (9:17)
WEEKDAY and DATEDIFF (5:50)
Quick measures (2:34)
Quiz
Assignment
Applying DAX and Power Query to make better reports
Module introduction (0:46)
Getting your work from Power BI Desktop to Power BI online (4:20)
Big assignment - Power Query and DAX (2:50)
Big assignment - Solution walkthrough (11:29)
Conclusion
Module introduction (0:24)
Recap of everything (7:04)
Quiz
Your next steps (1:49)
How to achieve your Power BI dreams with this course
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock