Microsoft Power BI Course
at just
$69
Enroll Now
Sign Up
Sign In
Microsoft Power BI Course
Microsoft Power BI Course
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
Preview
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
Preview
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
Preview
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
Preview
Lecture 216
About the Slicer
Text
Lecture 217
Introducing Slicers
5:52
Lecture 218
Adding Treemaps and Tables
Preview
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
$69
Take this course now.
Enroll Now
Lectures
274
Video
22:31:3 Hours
Skill level
intermdiate
level
Languages
English
Includes
Lifetime access
Certificate of Completion
Preview
×