Applying Data Types

Power BI - Beyond the Basics

Section 1: Introduction

Section 2: Importing and Transforming Data in Power Query

Importing Excel Data Files from a Folder (4:21)
Combining Files and Removing Columns (4:33)
Splitting and Merging Columns (4:55)
Applying Data Types (3:47)
Importing Text and CSV Files (7:11)
Relationships and Lookup Tables (6:41)
Duplicate vs Reference (7:07)
Creating a Lookup Table (3:28)
Creating Index Columns (3:43)
Merging Queries (5:19)
Enable/Disable Load and Report Refresh (3:22)
Advanced Editor (4:49)
Resolving Data Import Errors (5:07)
Organizing Queries into Groups (3:00)

Section 3: Data Modelling

Section 4: DAX - Essential Skills

Measures vs Calculated Columns (10:56)
Creating a Date Table with DAX (6:45)
Creating Additional Columns (5:16)
Creating Conditional Columns (2:21)
Marking Table as a Date Table (2:48)
Using ROUNDUP to Extract Quarters (2:06)
Creating Quick Measures (5:41)
Creating a Key Measures Table (3:27)
Aggregation Methods (5:12)
Using SUMX (5:47)

Section 5: DAX - CALCULATE Function

Section 6: Visualizations

Visualizations (8:37)
Tables vs Matrix Tables (6:24)
Formatting Visualizations - Part 1 (6:46)
Formatting Visualizations - Part 2 (3:07)
Conditional Formatting (12:41)
Column and Line Charts (13:55)
Card Visualizations (5:51)
Map Charts (9:41)
The Gauge Visualization (9:38)
Slicers and Filter (8:28)
Applying Design Elements (7:54)

Section 7: The Power BI Service

Creating a Shared Workspace in Power BI Service (4:51)
Inviting Others to a Shared Workspace (1:53)
Reports vs Dashboards (1:59)
Pinning Visualizations to the Dashboard (7:09)
Setting up Scheduled Refreshes (5:14)

Section 8: Orders Dashboard Example - Preparation

Section 9: Orders Dashboard Example - Transformation

Transforming Order Data in Power Query (1:54)
Creating Lookup Tables (5:38)
Merging Queries (5:36)
Creating a Dates Table (11:10)
Creating DAX Measures (10:57)

Section 10: Orders Dashboard Example: Report

Adding a Report Title (9:50)
Report Navigation with Buttons and Bookmarks (10:23)
Card Visualizations and Filtering (12:39)
Line Chart: Count of Male vs Female Customers (7:13)
Stacked Column Chart: Total Revenue by Region (6:00)
Treemap Chart: Count of Orders by Year/Month (5:59)
Funnel Chart: Age Distribution (6:17)
Matrix Table: Count of Customers by Type and Status (4:31)
Adding Conditional Formatting (2:16)

Section 11: Orders Dashboard Example: Dashboard

Section 12: Course Close

Your session expired. Please sign in again to continue.

Login