Section 1 : Getting Started

Lecture 1 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM Pdf
Lecture 2 About Certification Pdf
Lecture 3 DOWNLOAD Course Resources Text
Lecture 4 Introducing the Course Project 3:3
Lecture 5 Setting Expectations 2:22

Section 2 : Introducing Microsoft Power BI Desktop

Lecture 6 Introduction 0:26
Lecture 7 Meet Microsoft Power BI Desktop 5:30
Lecture 8 Downloading Power BI & Adjusting Settings 4:6
Lecture 9 IMPORTANT Regional Settings Text
Lecture 10 Exploring the Power BI Desktop Interface & Workflow 2:35
Lecture 11 Helpful Power BI Resources 1:45
Lecture 12 UPDATE New Power BI Ribbon 7:15

Section 3 : Connecting & Shaping Data with Power BI Desktop

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

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

Lecture 35 Introduction 0:20
Lecture 36 What is a Data Model 5:17
Lecture 37 Principles of Database Normalization 4:7
Lecture 38 Understanding Data Tables vs 7:25
Lecture 39 Understanding Table Relationships vs
Lecture 40 Creating Table Relationships in Power BI Desktop 4:35
Lecture 41 Snowflake Schemas in Power BI 3:9
Lecture 42 Managing & Editing Table Relationships in Power BI Desktop 2:44
Lecture 43 Managing Active vs 2:45
Lecture 44 Understanding Relationship Cardinality 5:9
Lecture 45 Connecting Multiple Data Tables in Power BI Desktop 8:27
Lecture 46 Understanding Filter Flow 6:33
Lecture 47 Two-Way Filters in Power BI Desktop (USE WITH CAUTION!) 13:17
Lecture 48 Hiding Fields from the Power BI Report View 4:15
Lecture 49 UPDATE New Power BI Desktop Model View 8:32
Lecture 50 Power BI Data Model Best Practices 1:35
Lecture 51 HOMEWORK Creating Table Relationships & Data Models in Power BI Text
Lecture 52 HOMEWORK SOLUTION Creating Table Relationships & Data Models in Power BI 14:10

Section 5 : Analyzing Data with DAX Calculations in Power BI

Lecture 53 Introduction 0:33
Lecture 54 Meet Data Analysis Expressions (DAX) 1:3
Lecture 55 Intro to DAX Calculated Columns 7:34
Lecture 56 Intro to DAX Measures
Lecture 57 RECAP Calculated Columns vs 1:34
Lecture 58 Adding Columns & DAX Measures in Power BI Desktop 3:13
Lecture 59 Implicit vs 6:27
Lecture 60 Filter Context Examples in Power BI 8:8
Lecture 61 Step-by-Step DAX Measure Calculation 2:39
Lecture 62 Understanding DAX Syntax & Operators 3:49
Lecture 63 Common DAX Function Categories 3:16
Lecture 64 DAX Demo Basic Date & Time Functions 12:24
Lecture 65 DAX Demo Conditional & Logical Functions (IFANDOR) 10:7
Lecture 66 DAX Demo Common Text Functions 9:24
Lecture 67 DAX Demo Joining Data with RELATED 8:54
Lecture 68 DAX Demo Basic Math & Stats Functions 14:2
Lecture 69 DAX Demo COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS) 7:46
Lecture 70 IMPORTANT Order Line Items 6:22
Lecture 71 DAX Demo CALCULATE 13:6
Lecture 72 DAX Demo CALCULATE & ALL 9:25
Lecture 73 DAX Demo CALCULATE & FILTER 9:38
Lecture 74 DAX Demo Iterator Functions (SUMX, RANKX) 12:27
Lecture 75 DAX Demo Time Intelligence Formulas 12:30
Lecture 76 DAX Best Practices in Power BI Desktop 2:58
Lecture 77 HOMEWORK Analyzing Data with DAX Calculations in Power BI Text
Lecture 78 HOMEWORK SOLUTION Analyzing Data with DAX Calculations in Power BI 15:5

Section 6 : Visualizing Data with Power BI Reports

Lecture 79 Introduction 0:29
Lecture 80 Exploring the Report View in Power BI Desktop 5:34
Lecture 81 Adding Simple Objects to the Power BI Report Canvas 3:8
Lecture 82 Inserting Basic Charts & Visuals in Power BI 5:48
Lecture 83 UPDATE Conditional Formatting 2:58
Lecture 84 Power BI Report Formatting Options 9:51
Lecture 85 Power BI Report Filtering Options 11:10
Lecture 86 Power BI Demo Exploring Data with Matrix Visuals
Lecture 87 Power BI Demo Filtering with Date Slicers 7:14
Lecture 88 Power BI Demo Showing Key Metrics with Cards & KPI Visuals 9:24
Lecture 89 Power BI Demo Inserting Text Cards 6:15
Lecture 90 Power BI Demo Visualizing Geospatial Data with Maps 7:16
Lecture 91 Power BI Demo Visualizing Data with Treemaps 3:21
Lecture 92 Power BI Demo Showing Trends with Line & Area Charts 6:23
Lecture 93 Power BI Demo Adding Trend Lines & Forecasts 5:36
Lecture 94 Power BI Demo Goal Pacing with Gauge Charts
Lecture 95 Editing Power BI Report Interactions 6:39
Lecture 96 Power BI Demo Adding Drillthrough Filters 5:8
Lecture 97 Using Power BI Report Bookmarks 5:50
Lecture 98 PRO TIP Testing Scenarios with What-If Parameters 11:47
Lecture 99 Managing & Viewing Roles in Power BI Desktop 5:27
Lecture 100 PREVIEW Custom Power BI Visuals (Log-in Required) 2:5
Lecture 101 PREVIEW Designing for Phone vs 2:54
Lecture 102 PREVIEW Publishing to Power BI Service 2:28
Lecture 103 Power BI Data Visualization Best Practices 1:35
Lecture 104 HOMEWORK Visualizing Data with Power BI Reports Text
Lecture 105 HOMEWORK SOLUTION Visualizing Data with Power BI Reports 7:22

Section 7 : NEW Artificial Intelligence (AI) Visuals

Lecture 106 Power BI Demo Q&A Visual 10:55
Lecture 107 Power BI Demo Key Influencers Visual (Part 1) 12:34
Lecture 108 Power BI Demo Key Influencers Visual (Part 2) 5:11
Lecture 109 IMPORTANT Correlation vs 4:24
Lecture 110 Power BI Demo Decomposition Tree Visual 8:59

Section 8 : Bonus Project Maven Market

Lecture 111 Introduction Text
Lecture 112 PART 1 Connecting & Shaping the Data Text
Lecture 113 PART 2 Creating the Data Model Text
Lecture 114 PART 3 Adding DAX Measures Text
Lecture 115 PART 4 Building the Report Text