Installing Power BI Desktop
Connecting Power BI Desktop to Source Files
Creating our First Visuals
Join our Online Learning Community
Comparing Excel & Power BI
The Two Ways (Paths) Of Taking This Course
How to Get the Most Out of This Course
Important: How to Access Course Resources Project Files & Slides
Understanding Data Preparation / Cleaning / Cleansing
Connecting Power BI Desktop to Source Files
How Power BI Queries Data
Understanding Basic Row Operations
Analyzing Columns & Removing Blank Fields
Understanding & Using the Append Feature
Choosing & Removing Columns
Understanding the Transpose Feature
Working with Dates - The Basics
Understanding Data Formats
Handling Data Format Errors
Understanding Pivoting & Unpivoting
Applying Pivoting & Unpivoting
Extracting Data Splitting Columns & Sorting Multiple Columns
Introducing the "Group By" Feature
Improving the Project Structure
Data Warehouse Data Model & Data Schema
Applying the Star Schema to our Project
Comparing References & Duplicates
Importing Country & Region Codes
Using "Enter Data" to Create a Table
Understanding the Merge Feature
Understanding Outer Inner & Anti Joins
Understanding the DIM-age Table
Bringing Back the "age-group" Column
Getting the Maximum Values From Each Age Group
Creating Conditional Columns
Creating a DIM-gender Table
Understanding the FACT Table
Applying Basic Mathematical Operations
Using the Enable Load Feature
Time to Practice - Query Editor
Query Editor vs Data Model
Understanding Relationships
Creating our First Relationship
Understanding Cardinality & Difference Relationship Types
One to Many & Many to One
Fixing the Column Order Bug
Understanding the Cross Filter Direction
Understanding Active Properties
Adding Relationships to the Project
M-Language vs DAX (Data Analysis Expressions)
Creating a Custom Column with the M-Language
Creating a Calculated Column with DAX
M vs DAX - What Should I Choose?
Creating a Table with the CALENDAR Function
Extracting Data with the DOT Notation
Adding & Dividing Columns
Working with IF Functions
Understanding Relationship Functions
Calculated Column vs Measure
Understanding & Creating Measures
Working with FILTER & CALCULATE Functions - Theory
Combining CALCULATED & FILTER Functions
Adding the Filter Condition to CALCULATE
Using Measures in Measures
Changing the Measure's Home Table
Understanding the Data Category
Time to Practice - Data Model & Relationships
The Power BI Workflow & Understanding Basics Visual Elements
Creating & Duplicating Pages
Creating Line & Column Charts
How FILTER Affects the Visual
Understanding Interactions
Formatting the Page Background / Wallpaper
Formatting the Filter Pane & Filter Cards
Formatting Visuals: General Settings
Diving Deeper Into Formatting Visuals
Working with Report Themes
Finishing the Report Theme
Default Summarization & Sorting Order
Creating Treemaps & Working with Multiple Slicers
Filter on Visual Page & Report Level
Creating Single & Multi Row Cards
Adding a Secondary Y-Axis
Combining Column & Line Charts
Time to Practice - Visualizations
Power BI Pro Interface Tour
Publishing & My Workspace - Theory
Publishing / Importing Power BI Desktop Projects to Pro
List View vs Lineage View
Creating Reports & Dashboards
Diving Deeper Into "My Workspace" Understanding Refresh and a Refresh Error
Gateways: Configuring Manual & Scheduled Refreshs
Sharing Data From "My Workspace" via Direct Access
Understanding Collaboration Workspaces - Theory
Creating Colaboration Workspaces
Publishing & Unpublishing Apps
Deleting Collaboration Workspaces
Working with Power BI Mobile
Connecting Power BI Desktop to the Source Files
Removing Blank Rows & Fixing Format Errors
Splitting Columns & Extracting Data
Basic Column Interactions
Creating the "Orders" Table
Loading Data Into the Data Model
Understanding Relationships
Formatting Numbers in Charts
Understanding Interactions
Formatting Visuals & Applying Report Themes
Reports Map Visual & Default Summarization
Applying Filters to Visuals
Working with DAX ("Data Analytics Expressions")
Sorting Weekdays with Calculated Columns
Fixing the Revenue Calculation
Working with Quick Measures
Understanding Column from Examples
Group By Big Data & DAX Studio
Please Read: Bonus Project Introduction
Taxi Project - Query Editor
Taxi Project - Data Model & Visuals
Taxi Project - Power BI Service