Part 1 Section Overview

Saving Your Work

Entering Data Manually

Loading the Races CSV Data

Removing Rows and Columns

Simple Mathematical Operations

Duplicate, Index and Conditional Columns

Filtering Values

Sorting your Data

Working with Columns

Splitting Extracting Information from Columns

Data Types

Logically Ordering your Applied Steps

Refreshing the Source Data

Duplicate vs Reference

Transpose, Reverse Rows and Count Rows

Replacing Values

Appending Queries

Removing Duplicates

Loading the Circuits JSON File & Assignment

Loading the Constructors CSV File & Assignment

Pivoting and Unpivoting

Group By

Loading the Drivers Text File & Assignment

Download the Part 1 Power BI Report

Loading the Results CSV File & Assignments

Power BI Desktop Installation

Power BI Ecosystem

Course Introduction

Power BI Desktop Interface Overview

Course Project and Dataset Download (IMPORTANT)

Part 2 Section Overview

Many to Many Cardinality

One to One Cardinality

One to Many Cardinality and Cross Filter Direction

Autodetect and Active Relationships

Creating the Relationships for our Data Model (Assignment)

Merging Tables - Join Types

Data Modelling Approaches - STAR and SNOWFLAKE

Linking Tables via Relationships

Merging Tables Demonstration

Part 3 Section Overview

Visualization and Report Basics

Bar and Column Charts

Interactions

Quick Note on Legends

Small Multiples

Drilldowns and Hierarchies

Table and Matrix Visuals

The Filter Pane

Combo Charts and Cross Filter Direction Revisited

Treemaps

Scatter Charts

Cards

Line and Area Charts

Visual Elements

Tooltips

Additional Visualizations

Download the Part 3 Power BI Report

Best Practice Tips and Formula One Report Requirements

Data Categories and Maps

Creating the Formula One Report Part 2

Creating the Formula One Report Part 1

Part 4 Section Overview

Power BI Online Overview

Dashboards

Power BI Pro Interface Tour

Refreshing Data

Collaboration Workspaces

Publishing Reports to Power BI Pro

Part 5 Section Overview - Languages in Power BI

DAX Overview

Filter Functions

Download the Part 5 Power BI Report

Other Functions

Aggregation Functions

Assignment Questions