Section 1 : Getting Started

Lecture 1 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM
Lecture 2 About Certification
Lecture 3 DOWNLOAD Course Resources
Lecture 4 Introducing the Course Project 00:03:03 Duration
Lecture 5 Setting Expectations 00:02:22 Duration

Section 2 : Introducing Microsoft Power BI Desktop

Lecture 1 Introduction 00:00:26 Duration
Lecture 2 Meet Microsoft Power BI Desktop 00:05:30 Duration
Lecture 3 Downloading Power BI & Adjusting Settings 00:04:06 Duration
Lecture 4 IMPORTANT Regional Settings
Lecture 5 Exploring the Power BI Desktop Interface & Workflow 00:02:35 Duration
Lecture 6 Helpful Power BI Resources 00:01:45 Duration
Lecture 7 UPDATE New Power BI Ribbon 00:07:15 Duration

Section 3 : Connecting & Shaping Data with Power BI Desktop

Lecture 1 Introduction 00:00:30 Duration
Lecture 2 Types of Data Connectors in Power BI Desktop 00:03:53 Duration
Lecture 3 The Power BI Query Editor (aka Power Query) 00:04:28 Duration
Lecture 4 Demo Basic Table Transformations in Power BI 00:10:04 Duration
Lecture 5 Power BI Demo Working with Text Tools 00:14:54 Duration
Lecture 6 Power BI Demo Working with Numerical Values
Lecture 7 Power BI Demo Working with Date & Time Tools 00:08:53 Duration
Lecture 8 PRO TIP Creating a Rolling Calendar in Power BI Desktop 00:07:08 Duration
Lecture 9 Power BI Demo Generating Index & Conditional Columns 00:08:30 Duration
Lecture 10 Power BI Demo Grouping & Aggregating Records 00:07:33 Duration
Lecture 11 Power BI Demo Pivoting & Unpivoting Data 00:08:04 Duration
Lecture 12 Merging Queries in Power BI Desktop 00:06:41 Duration
Lecture 13 Appending Queries in Power BI Desktop 00:06:30 Duration
Lecture 14 PRO TIP Appending Files from a Folder 00:07:38 Duration
Lecture 15 Configuring Power BI Data Source Settings 00:05:06 Duration
Lecture 16 Configuring Power BI Query Refresh Settings 00:03:07 Duration
Lecture 17 Additional Data Types & Categories in Power BI 00:07:19 Duration
Lecture 18 Defining Hierarchies in Power BI Desktop 00:04:36 Duration
Lecture 19 PRO TIP Importing Models from Excel to Power BI 00:05:40 Duration
Lecture 20 Power BI Data Connection Best Practices 00:02:09 Duration
Lecture 21 HOMEWORK Connecting & Shaping Data with Power BI Desktop
Lecture 22 HOMEWORK SOLUTION Connecting & Shaping Data with Power BI Desktop 00:12:37 Duration

Section 4 : Creating Table Relationships & Data Models in Power BI

Lecture 1 Introduction 00:00:20 Duration
Lecture 2 What is a Data Model 00:05:17 Duration
Lecture 3 Principles of Database Normalization 00:04:07 Duration
Lecture 4 Understanding Data Tables vs 00:07:25 Duration
Lecture 5 Understanding Table Relationships vs
Lecture 6 Creating Table Relationships in Power BI Desktop 00:04:35 Duration
Lecture 7 Snowflake Schemas in Power BI 00:03:09 Duration
Lecture 8 Managing & Editing Table Relationships in Power BI Desktop 00:02:44 Duration
Lecture 9 Managing Active vs 00:02:45 Duration
Lecture 10 Understanding Relationship Cardinality 00:05:09 Duration
Lecture 11 Connecting Multiple Data Tables in Power BI Desktop 00:08:27 Duration
Lecture 12 Understanding Filter Flow 00:06:33 Duration
Lecture 13 Two-Way Filters in Power BI Desktop (USE WITH CAUTION!) 00:13:17 Duration
Lecture 14 Hiding Fields from the Power BI Report View 00:04:15 Duration
Lecture 15 UPDATE New Power BI Desktop Model View 00:08:32 Duration
Lecture 16 Power BI Data Model Best Practices 00:01:35 Duration
Lecture 17 HOMEWORK Creating Table Relationships & Data Models in Power BI
Lecture 18 HOMEWORK SOLUTION Creating Table Relationships & Data Models in Power BI 00:14:10 Duration

Section 5 : Analyzing Data with DAX Calculations in Power BI

Lecture 1 Introduction 00:00:33 Duration
Lecture 2 Meet Data Analysis Expressions (DAX) 00:01:03 Duration
Lecture 3 Intro to DAX Calculated Columns 00:07:34 Duration
Lecture 4 Intro to DAX Measures
Lecture 5 RECAP Calculated Columns vs 00:01:34 Duration
Lecture 6 Adding Columns & DAX Measures in Power BI Desktop 00:03:13 Duration
Lecture 7 Implicit vs 00:06:27 Duration
Lecture 8 Filter Context Examples in Power BI 00:08:08 Duration
Lecture 9 Step-by-Step DAX Measure Calculation 00:02:39 Duration
Lecture 10 Understanding DAX Syntax & Operators 00:03:49 Duration
Lecture 11 Common DAX Function Categories 00:03:16 Duration
Lecture 12 DAX Demo Basic Date & Time Functions 00:12:24 Duration
Lecture 13 DAX Demo Conditional & Logical Functions (IFANDOR) 00:10:07 Duration
Lecture 14 DAX Demo Common Text Functions 00:09:24 Duration
Lecture 15 DAX Demo Joining Data with RELATED 00:08:54 Duration
Lecture 16 DAX Demo Basic Math & Stats Functions 00:14:02 Duration
Lecture 17 DAX Demo COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS) 00:07:46 Duration
Lecture 18 IMPORTANT Order Line Items 00:06:22 Duration
Lecture 19 DAX Demo CALCULATE 00:13:06 Duration
Lecture 20 DAX Demo CALCULATE & ALL 00:09:25 Duration
Lecture 21 DAX Demo CALCULATE & FILTER 00:09:38 Duration
Lecture 22 DAX Demo Iterator Functions (SUMX, RANKX) 00:12:27 Duration
Lecture 23 DAX Demo Time Intelligence Formulas 00:12:30 Duration
Lecture 24 DAX Best Practices in Power BI Desktop 00:02:58 Duration
Lecture 25 HOMEWORK Analyzing Data with DAX Calculations in Power BI
Lecture 26 HOMEWORK SOLUTION Analyzing Data with DAX Calculations in Power BI 00:15:05 Duration

Section 6 : Visualizing Data with Power BI Reports

Lecture 1 Introduction 00:00:29 Duration
Lecture 2 Exploring the Report View in Power BI Desktop 00:05:34 Duration
Lecture 3 Adding Simple Objects to the Power BI Report Canvas 00:03:08 Duration
Lecture 4 Inserting Basic Charts & Visuals in Power BI 00:05:48 Duration
Lecture 5 UPDATE Conditional Formatting 00:02:58 Duration
Lecture 6 Power BI Report Formatting Options 00:09:51 Duration
Lecture 7 Power BI Report Filtering Options 00:11:10 Duration
Lecture 8 Power BI Demo Exploring Data with Matrix Visuals
Lecture 9 Power BI Demo Filtering with Date Slicers 00:07:14 Duration
Lecture 10 Power BI Demo Showing Key Metrics with Cards & KPI Visuals 00:09:24 Duration
Lecture 11 Power BI Demo Inserting Text Cards 00:06:15 Duration
Lecture 12 Power BI Demo Visualizing Geospatial Data with Maps 00:07:16 Duration
Lecture 13 Power BI Demo Visualizing Data with Treemaps 00:03:21 Duration
Lecture 14 Power BI Demo Showing Trends with Line & Area Charts 00:06:23 Duration
Lecture 15 Power BI Demo Adding Trend Lines & Forecasts 00:05:36 Duration
Lecture 16 Power BI Demo Goal Pacing with Gauge Charts
Lecture 17 Editing Power BI Report Interactions 00:06:39 Duration
Lecture 18 Power BI Demo Adding Drillthrough Filters 00:05:08 Duration
Lecture 19 Using Power BI Report Bookmarks 00:05:50 Duration
Lecture 20 PRO TIP Testing Scenarios with What-If Parameters 00:11:47 Duration
Lecture 21 Managing & Viewing Roles in Power BI Desktop 00:05:27 Duration
Lecture 22 PREVIEW Custom Power BI Visuals (Log-in Required) 00:02:05 Duration
Lecture 23 PREVIEW Designing for Phone vs 00:02:54 Duration
Lecture 24 PREVIEW Publishing to Power BI Service 00:02:28 Duration
Lecture 25 Power BI Data Visualization Best Practices 00:01:35 Duration
Lecture 26 HOMEWORK Visualizing Data with Power BI Reports
Lecture 27 HOMEWORK SOLUTION Visualizing Data with Power BI Reports 00:07:22 Duration

Section 7 : NEW Artificial Intelligence (AI) Visuals

Lecture 1 Power BI Demo Q&A Visual 00:10:55 Duration
Lecture 2 Power BI Demo Key Influencers Visual (Part 1) 00:12:34 Duration
Lecture 3 Power BI Demo Key Influencers Visual (Part 2) 00:05:11 Duration
Lecture 4 IMPORTANT Correlation vs 00:04:24 Duration
Lecture 5 Power BI Demo Decomposition Tree Visual 00:08:59 Duration

Section 8 : Bonus Project Maven Market

Lecture 1 Introduction
Lecture 2 PART 1 Connecting & Shaping the Data
Lecture 3 PART 2 Creating the Data Model
Lecture 4 PART 3 Adding DAX Measures
Lecture 5 PART 4 Building the Report