Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Power BI for Beginners
Introduction
Welcome and Overview (2:51)
What is Power BI? (4:22)
Install Power BI Desktop (2:08)
A Tour of BI Desktop (5:22)
Explore Commonly Used Power BI Options (6:54)
Course Exercise Files
Course Instructor Files
Getting and Transforming Data
Import Files from a Folder into Power BI Desktop (12:29)
Get Data from Excel and Text Files (7:08)
Changing Query Source (4:14)
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)
Data Modelling
Create Relationships Between tables (6:49)
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)
Introduction to DAX Measures
Calculate the Total Revenue (6:39)
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)
Adding Visualizations to your Report
Show Summary Information with Cards (6:48)
Columns Charts to Compare Values (7:33)
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:37)
Report Design
Adding Text Boxes and Shapes (9:55)
Use Themes (7:41)
Conditional Formatting (7:59)
Practise Exercise (0:34)
Editing Interactions and Filters
Edit the Interactions between your Visualisations (9:45)
The Filter Pane to Filter at Any Level (7:03)
Drill Through to More Detail (8:16)
Practise Exercise (0:35)
Power BI Service
Publish Your Report to the Power BI Service (6:29)
Different Ways to Share your Power BI Report (5:25)
Practise Exercise (0:48)
Closing
Wrap Up (1:07)
Course Quiz and Certificate of Completion
Install Power BI Desktop
Complete and Continue