A Tour of BI Desktop | Master of Project Academy

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Power BI Bundle: Exclusive Two-Course Bundle!

Section 1: Introduction

Welcome to Master of Project Academy (1:19)
How to Utilize Power BI Training?
Welcome and Overview (2:51)
What is Power BI? (4:22)
Install Power BI Desktop (2:08)
A Tour of BI Desktop (6:54)
Explore Commonly Used Power BI Options (5:23)
Quiz
Course Files

Section 2: Getting and Transforming Data

Get Data from Excel and Text Files (11:22)
Reference Queries to Create Additional Lookup Tables (6:36)
Merge Queries in Power Query (6:57)
Prevent Queries from Loading into Power BI Desktop (3:05)
Practise Exercise (0:37)
Quiz
Import Files from a Folder into Power BI Desktop (12:29)

Section 3: Data Modelling

Create a Dynamic List of Dates (8:53)
Create Additional Date Columns for Analysis (9:13)
Sort the Month and Weekday Names Correctly (2:47)
Mark the Table as a Date Table (1:03)
Hide Unnecessary Fields from Report View (4:59)
Practise Exercise (0:32)
Quiz
Create Relationships Between tables (6:49)

Section 4: Introduction to DAX Measures

Count the Total Rows of a Table (1:56)
Use the CALCULATE Function (5:33)
Calculate the Total Revenue Last Year (3:38)
Difference Compared to Last Year (5:23)
Practise Exercise (0:36)
Quiz
Calculate the Total Revenue (6:39)

Section 5: Adding Visualizations to your Report

Show Summary Information with Cards (6:48)
Map Visual to Plot Georgraphic Data (4:46)
Slicers to Filter your Reports (8:05)
KPI Card to Measure Performance Against a Goal (7:16)
Line Graps to Visualise Trend (5:59)
Show Detail with the Matrix (9:45)
Top N Lists with the Table Visualisation (7:48)
Practise Exercise (0:38)
Quiz
Columns Charts to Compare Values (7:33)

Section 6: Report Design

Adding Text Boxes and Shapes (9:55)
Conditional Formatting (7:59)
Practise Exercise (0:34)
Quiz
Use Themes (7:41)

Section 7: Editing Interactions and Filters

Edit the Interactions Between your Visualisations (9:45)
Drill Through to More Detail (8:17)
Practise Exercise (0:35)
Quiz
The Filter Pane to Filter at Any Level (7:03)

Section 8: Power BI Service

Publish Your Report to the Power BI Service (6:30)
Different Ways to Share your Power BI Report (5:25)
Practise Exercise (0:48)
Quiz

Section 9: Closing

Wrap Up (1:07)

Tip #1 - Join LinkedIn Community

Join LinkedIn Community & Follow Latest Updates

How to Submit a PDU Claim (For Retaining PMP Certificate)

How to Submit PDUs

Bonus Lecture - Discount for our paid courses

Bonus Lecture - Discount for our paid courses

Important Notice About Certificate of Completion

Important Notice About Certificate of Completion

Teach online with

A Tour of BI Desktop

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll to Unlock