Section 1 : Introduction

Lecture 1 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM Pdf
Lecture 2 What is Power BI 7:29
Lecture 3 Join our Online Learning Community Text
Lecture 4 First Project 13 Installing Power BI Desktop & Source File Connection 11:12
Lecture 5 First Project 23 Working in the Query Editor 9:19
Lecture 6 First Project 33 The Data View & Creating our First Visuals 8:11
Lecture 7 Course Outline - What's Inside the Course 5:24
Lecture 8 How to Get the Most out of the Course 3:53
Lecture 9 Useful Resources & Links Text

Section 2 : Introducing Power BI Desktop

Lecture 10 Module Introduction 1:36
Lecture 11 Using the Attached Project Files 4:2
Lecture 12 Understanding the Power BI Desktop Workflow 2:34
Lecture 13 Exploring the Interface of the Data Model 6:6
Lecture 14 Understanding the Query Editor Interface 4:48
Lecture 15 Important! Creating the Project File & Recommended Settings 4:10
Lecture 16 Course Slides 2020 Text
Lecture 17 Useful Resources & Links Text

Section 3 : Working in the Query Editor

Lecture 18 Module Introduction 1:49
Lecture 19 Connecting Power BI Desktop to Source Files 7:9
Lecture 20 Keeping & Removing Rows 6:20
Lecture 21 Working with Filters 4:19
Lecture 22 Removing Empty Rows 5:9
Lecture 23 Saving the Project Draft 3:23
Lecture 24 Appending Queries
Lecture 25 Working with Columns 5:23
Lecture 26 Replacing Values 5:35
Lecture 27 [Please Read] Important Hint for the Next Lecture Text
Lecture 28 Formatting Data & Handling Formatting Errors 8:9
Lecture 29 Pivoting & Unpivoting Data 10:19
Lecture 30 Splitting Columns 8:15
Lecture 31 Creating Groups & Cleaning Up our Project
Lecture 32 What we Achieved & How to Continue 1:4
Lecture 33 Theory Time The Star Schema 5:28
Lecture 34 How we Use the Star Schema in our Project 2:24
Lecture 35 Query Duplicates vs References 7:20
Lecture 36 Creating the DIM-Region Table & Removing Duplicates 9:33
Lecture 37 Creating Tables Manually 4:3
Lecture 38 Theory Time Merging Queries 5:15
Lecture 39 Understanding Join Kind 4:40
Lecture 40 Merging Queries Applied 7:24
Lecture 41 Finishing the DIM-Region Table 10:45
Lecture 42 The Next Steps 1:6
Lecture 43 Creating the DIM-Age Table 6:52
Lecture 44 Understanding Extract 5:38
Lecture 45 Working with Conditional Columns 4:4
Lecture 46 Creating the FACT-Table 4:46
Lecture 47 Understanding Basic Mathematical Operations 2:5
Lecture 48 Performance Optimization 6:51
Lecture 49 Wrap Up 2:53
Lecture 50 Useful Resources & Links Text

Section 4 : Understanding the Data Model Data & Relationship View

Lecture 51 Module Introduction 1:28
Lecture 52 Understanding Relationships 7:55
Lecture 53 Cardinality Many-to-One & One-to-One 4:53
Lecture 54 Cross Filter Direction & Many-to-Many 6:30
Lecture 55 Understanding Active Properties 3:9
Lecture 56 M-Language vs DAX (Data Analysis Expressions) 3:11
Lecture 57 M vs DAX - A Practical Example 11:28
Lecture 58 Understanding the DAX Basics 2:39
Lecture 59 The DAX Syntax 3:31
Lecture 60 Supported DAX Data Types 2:7
Lecture 61 Diving Into Operators 3:51
Lecture 62 DAX Functions - An Overview 3:25
Lecture 63 Understanding the CALENDAR Function 10:14
Lecture 64 Applying the DAX Basics 4:43
Lecture 65 Understanding IF & RELATED 6:53
Lecture 66 Calculated Columns vs Measures 1:49
Lecture 67 Creating our First Measures 5:26
Lecture 68 Understanding CALCULATE & FILTER 3:38
Lecture 69 Applying CALCULATE & FILTER in Measures 8:46
Lecture 70 Creating Measures with Measures 5:0
Lecture 71 Understanding Data Category 2:9
Lecture 72 Wrap Up 3:15
Lecture 73 Useful Resources & Links Text

Section 5 : Creating Visuals in the Report View

Lecture 74 Module Introduction 1:14
Lecture 75 Understanding Basic Visual Concepts 3:13
Lecture 76 Getting Started with Visuals & Reports 7:1
Lecture 77 Creating our First Visuals 5:48
Lecture 78 Understanding Tooltips & Interactions 6:52
Lecture 79 Diving Intro Hierarchies & Drill Mode 6:33
Lecture 80 Data Colors & Conditional Formatting 6:54
Lecture 81 Formatting Report Pages 4:34
Lecture 82 Formatting Visuals 9:4
Lecture 83 Working with Report Themes 10:29
Lecture 84 Using the Slicer 8:4
Lecture 85 Understanding Default Summarization & Sorting 4:5
Lecture 86 Working with Treemaps & Tables 9:30
Lecture 87 Syncing Slicers 3:23
Lecture 88 Understanding Filter Types (Visual, Page & Report) 7:3
Lecture 89 Working with (Multi) Row Cards 4:52
Lecture 90 Creating Combined Visuals & Waterfalls 8:36
Lecture 91 Using Custom Visuals 2:36
Lecture 92 Wrap Up 3:36
Lecture 93 Useful Resources & Links Text

Section 6 : Taking the Project to the Cloud with Power BI Pro (Service)

Lecture 94 Module Introduction 1:3
Lecture 95 Why we Need Power BI Pro (Service) 4:19
Lecture 96 Power BI Service vs Pro vs Premium 3:25
Lecture 97 No Business Email An Alternative Text
Lecture 98 Exploring the Power BI Pro Interface 4:41
Lecture 99 Understanding Workspaces 3:1
Lecture 100 Connecting Power BI Pro & Power BI Desktop 3:58
Lecture 101 Understanding Datasets in Power BI Pro 5:13
Lecture 102 Working with Reports 5:21
Lecture 103 Creating Dashboards 6:38
Lecture 104 Exploring My Workspace 5:10
Lecture 105 Refreshing Data with Gateways 10:24
Lecture 106 Sharing Data From My Workspace 6:54
Lecture 107 Understanding Collaboration Workspaces 8:40
Lecture 108 Workspaces vs Apps vs Content Packs 1:40
Lecture 109 Publishing an App 10:50
Lecture 110 Workspace or App - Which one Should I Choose 2:9
Lecture 111 Working with Power BI Mobile 9:18
Lecture 112 Wrap Up 2:41
Lecture 113 Useful Resources & Links Text

Section 7 : Other Data Sources

Lecture 114 Module Introduction 1:22
Lecture 115 Importing JSON Data 6:28
Lecture 116 Updated Star Wars API URL Text
Lecture 117 Importing Data from REST APIs 5:1
Lecture 118 Preparation Setting up a MySQL Server 8:9
Lecture 119 Importing Data from a MySQL Server (and other SQL Servers) 6:38
Lecture 120 Wrap Up 0:56

Section 8 : How to Stay Up-to-Date in the Power BI World

Lecture 121 Module Introduction 0:43
Lecture 122 Helpful Resources 5:2
Lecture 123 Using Preview Features 1:17

Section 9 : Creating Custom Visuals (Power BI for Developers)

Lecture 124 Module Introduction 0:44
Lecture 125 Why Custom Visuals 5:2
Lecture 126 The Required Tools 3:6
Lecture 127 Setting Up & Installing the Required Tools 11:20
Lecture 128 Creating a New Visual 6:6
Lecture 129 Analyzing the Project & the Code 13:3
Lecture 130 Rendering Content to the Screen 5:43
Lecture 131 Using d3 12:26
Lecture 132 Getting Started with the Bars 10:7
Lecture 133 Rendering a Chart for Dummy Data 11:59
Lecture 134 Binding Real Data 16:24
Lecture 135 Coloring the Bars 4:26
Lecture 136 Adding an Axis 5:37
Lecture 137 Package & Wrap Up 3:15
Lecture 138 Useful Resources & Links Text

Section 10 : Course Round Up

Lecture 139 Congratulations! What you Learned & How to Continue 6:36

Section 11 : Bonus Selected Features by Example & Refresher Project

Lecture 140 About this Module Text
Lecture 141 Understanding Column from Examples 6:35
Lecture 142 Group By, Big Data & DAX Studio 9:43
Lecture 143 Please Read Bonus Project Introduction Text
Lecture 144 Taxi Project - Query Editor 22:12
Lecture 145 Taxi Project - Data Model & Visuals 22:20
Lecture 146 Taxi Project - Power BI Service 15:32

Section 12 : [OLD COURSE MATERIAL] - The old Power BI Interface

Lecture 147 [PLEASE READ About the Following Modules Text

Section 13 : [OLD COURSE] Getting Started

Lecture 148 Welcome to this Course 2:41
Lecture 149 Understanding the Power BI Tools 6:53
Lecture 150 Join our Online Learning Community Text
Lecture 151 Initial Project 13 Installing Power BI Desktop and Connecting to Data 6:54
Lecture 152 Important The Locale Used in This Course Text
Lecture 153 Initial Project 23 Working in the Query Editor 6:51
Lecture 154 Initial Project 33 Working in the Data Model and Creating a Visualization 7:34
Lecture 155 Course Outline 3:2
Lecture 156 How to use the Attached Project Files 3:12

Section 14 : [OLD COURSE] Exploring Power BI Desktop

Lecture 157 An Overview of the Workflow in Power BI Desktop 2:37
Lecture 158 Introducing the Different Views of the Data Model 7:10
Lecture 159 Taking a Closer Look at the Query Editor Interface 4:7
Lecture 160 Important! Before we Dive Deeper Required Power BI Settings 3:17

Section 15 : [OLD COURSE] An Introduction to the Query Editor

Lecture 161 Module Introduction 1:31
Lecture 162 Just to be Sure What is the Query Editor 2:47
Lecture 163 Before we Start - About the Attached Project Files Text
Lecture 164 Connecting Power BI Desktop to our Data Sources 5:10
Lecture 165 Editing Rows 9:55
Lecture 166 Understanding Append Queries 6:7
Lecture 167 Editing Columns 5:21
Lecture 168 Replacing Values 3:14
Lecture 169 Formatting Data
Lecture 170 Pivoting and Unpivoting Columns 4:36
Lecture 171 Splitting Columns 3:30
Lecture 172 Creating a New Group for our Queries 1:30
Lecture 173 What we Achieved until Now and How to Continue 0:49
Lecture 174 Introducing the Star Schema 6:9
Lecture 175 Duplicating and Referencing Queries 3:39
Lecture 176 Creating the DIM Region Table 7:25
Lecture 177 Entering Data Manually 4:4
Lecture 178 Merging Queries 10:45
Lecture 179 Finishing the DIM Region Table 9:21
Lecture 180 Introducing the DIM AgeGroup Table 1:4
Lecture 181 Creating an Index Column 3:57
Lecture 182 Duplicating Columns and Extracting Information 5:49
Lecture 183 Creating Conditional Columns 4:17
Lecture 184 Creating the FACT Population Table 4:38
Lecture 185 Performing Basic Mathematical Operations 1:54
Lecture 186 Improving Performance and Loading Data into the Data Model 10:26
Lecture 187 Wrap Up 0:42
Lecture 188 About Certification Pdf
Lecture 189 Assignment Solution 9:3

Section 16 : [OLD COURSE] Working on our Data Model Data & Relationship View

Lecture 190 Module Introduction 0:47
Lecture 191 Query Editor vs 2:30
Lecture 192 Introducing and Understanding Relationships 7:50
Lecture 193 Editing Relationships 3:6
Lecture 194 Understanding Cardinality 4:37
Lecture 195 Cross Filter Selection and Many-To-Many Relationships 7:21
Lecture 196 Active Properties 2:0
Lecture 197 Understanding the differences between the M-Language and DAX 2:42
Lecture 198 M vs 8:55
Lecture 199 M vs 1:14
Lecture 200 DAX - Basic information 8:11
Lecture 201 DAX and Calculated Columns 8:43
Lecture 202 Calculated Columns vs 1:11
Lecture 203 Introducing DAX-Measures 4:50
Lecture 204 DAX-Measures Continued 6:43
Lecture 205 Categorizing Data 2:8
Lecture 206 Wrap Up 0:53
Lecture 207 Assignment Instructions Text
Lecture 208 [OPTIONAL] Assignment Solution 11:48

Section 17 : [OLD COURSE] Working in the Report View to Visualize our Results

Lecture 209 Module Introduction 1:1
Lecture 210 Understanding the Interface of the Report View 11:21
Lecture 211 Creating our First Visualizations 7:3
Lecture 212 Editing Interactions and Adding Tooltips 6:54
Lecture 213 Adding Data Colors & Understanding Conditional Formatting 6:55
Lecture 214 Understanding Hierarchies and Adding Drill-Down 5:44
Lecture 215 Formatting Charts and Sorting
Lecture 216 About the Slicer Text
Lecture 217 Introducing Slicers 5:52
Lecture 218 Adding Treemaps and Tables
Lecture 219 Applying different Filter Types 6:34
Lecture 220 Creating (Multi-Row) Cards 5:42
Lecture 221 Understanding Combined Visualizations and Waterfalls 4:27
Lecture 222 Wrap Up 0:42
Lecture 223 About Proctor Testing Pdf
Lecture 224 Assignment Solution 10:2

Section 18 : [OLD COURSE] Power BI Service & Power BI Mobile - How to Continue

Lecture 225 Module Introduction 0:35
Lecture 226 Continuing our Work and why we need Power BI Service 4:24
Lecture 227 Comparing Power BI Free, Pro and Premium 2:45
Lecture 228 Logging in to Power BI Service 1:15
Lecture 229 Understanding the Interface 5:18
Lecture 230 Importing our Data from Power BI Desktop to Power BI Service 5:16
Lecture 231 Understanding the Dataset Menu 4:52
Lecture 232 Working on Reports 7:2
Lecture 233 Introducing Dashboards 4:0
Lecture 234 Exploring our Workspace 4:28
Lecture 235 Understanding Gateways 3:11
Lecture 236 Comparing Personal and On-Premise Gateway and Installing a Gateway 4:56
Lecture 237 Working alone or Collaborating with Colleagues 0:55
Lecture 238 Collaborating in App Workspaces 4:25
Lecture 239 Sharing the Results 0:55
Lecture 240 Publishing the App 4:26
Lecture 241 Content Packs from Online Services 6:21
Lecture 242 Power BI Mobile Installing and Understanding the Mobile App 11:28
Lecture 243 One Last Thing Excluding Datasets from Sharing 5:22
Lecture 244 Wrap Up 1:47

Section 19 : [OLD COURSE] Creating Custom Visuals (Power BI for Developers)

Lecture 245 Developer Prerequisites Text
Lecture 246 Module Introduction 1:9
Lecture 247 How do Custom Visuals Work 4:15
Lecture 248 Using Data Driven Documents (D3) 2:39
Lecture 249 Please Read - Creating & Installing a Certificate Text
Lecture 250 Creating and Using a Visual 8:20
Lecture 251 Installing an IDE (Code Editor) 1:35
Lecture 252 Understanding the visuals 4:56
Lecture 253 Understanding the Project Structure 4:11
Lecture 254 Installing d3 5:32
Lecture 255 Adding a First Shape 5:32
Lecture 256 Connecting Shapes to Data 8:14
Lecture 257 Scaling Shapes 9:52
Lecture 258 Managing Visual Capabilities to Allow Data Input 3:23
Lecture 259 Starting the Data Extraction 4:56
Lecture 260 Limiting the Data Input 1:36
Lecture 261 Extracting Data 4:49
Lecture 262 Displaying the User Data 2:35
Lecture 263 mp4 3:44
Lecture 264 Adding Dynamic Coloring 3:54
Lecture 265 Making Bars Selectable (Cross-Visual) 7:36
Lecture 266 Adding X-Axis Labels 8:40
Lecture 267 Adding Custom Visuals Settings 3:9
Lecture 268 Extracting the Visual Configuration 9:47
Lecture 269 Informing Power BI About the Custom Configuration 4:42
Lecture 270 Next Steps 1:21
Lecture 271 Packaging the Custom Visual 1:28
Lecture 272 Wrap Up 1:5
Lecture 273 Further Resources Text

Section 20 : [OLD COURSE] Course Roundup

Lecture 274 Congratulations 1:43