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
Merge Queries in Power Query
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll to Unlock