Microsoft Power BI – The Complete Masterclass [2022 EDITION]

Introduction
1 Welcome
2 What is Power BI
3 Download & Installing Power BI Desktop
4 Quick Interface Tour
5 Mini Project Transform Data
6 Mini Project Visualize Data
7 Mini Project Creating a Data Model
8 Course Outline What will you learn in this course
9 How to lean best with this course
10 All source files & course slides

Preparing our Project
11 Creating our initial project file
12 Working with the attached project files

Data Transformation The Query Editor
13 Exploring the Query Editor
14 Connecting to our data source
15 Editing rows
16 Changing data types
17 Replacing values
18 Close & Apply
19 Connecting to a csv file
20 Connecting to a web page
21 Extracing characters
22 Splitting & merging columns
23 Creating conditional columns
24 A little note regarding the next lecture
25 Creating columns from examples
26 Merging Queries
27 Pivoting & Unpivoting
28 Appending Queries
29 Practise & Solution Population table
30 The FactDimensionModel
31 Practise Load the dimension table
32 Organizing our queries in groups
33 Text to be used in the next lecture
34 Entering data manually
35 Creating an index column
36 Workflow & more transformations
37 Module summary

Data Transformation Advanced
38 Advanced Editor Best practises
39 Performance References vs Duplicating
40 Performance Enable Disable Load & Report Refresh
41 Group by
42 Mathematical Operations
43 Run R Script
44 Using Parameters to dynamically transform data
45 M formula language Basics
46 M formula language Values Lists & Tables
47 M formula language Functions
48 M formula language More functions & steps

Creating a Data Model
49 Why a data model
50 Create & edit relationships
51 Onetomany & onetoone relationship
52 Manytomany mn relationship
53 Cross filter direction
54 Activate & deactivate relationships
55 Module summary

Data Visualization
56 Our first visual
57 The format tab
58 Understanding tables
59 Conditional formatting
60 The Pie Chart
61 All about the filter visual
62 The filter pane for developers
63 Cross filtering & edit interactions
64 Syncing slicers across pages
65 Creating drill downs
66 Creating drill throughs
67 The tree map visual
68 The decomposition tree
69 Understanding the matrix visual
70 Editing pages
71 Buttons & Actions
72 Bookmarks to customize your report
73 Analytics and Forecasts with line charts
74 Working with custom visuals
75 R Script to use
76 Get data using R Script & R Script visual
77 Asking questions Q&A visual
78 Wrap up data visualization

Power BI & Python
79 Python in Power BI Plan of attack
80 Setting up Python for Power BI
81 Transforming data using Python
82 Python script I used in the next lecture
83 Creating visualizations using Python
84 Python script II used in the next lecture
85 Violin plots pair plots & ridge plots using Python
86 Python script III used in the next lecture
87 Machine learning BayesTextAnalyzer using Python
88 Performance & Troubleshooting

DAX The Essentials
89 The different versions of COUNT
90 SUMX Row based calculations
91 DAX Exercise 1
92 DAX Solution 1
93 Intro
94 The project data
95 DAX cheat sheet
96 All files for the DAX part
97 Measures vs Calculated Columns
98 Automatically creating a date table in DAX
99 CALENDAR
100 Creating a complete date table with features
101 Script to be used in your future projects
102 Creating key measure table
103 Aggregation functions

DAX The CALCULATE function
104 CALCULATE The basics
105 Changing the context with FILTER
106 ALL
107 ALLSELECTED
108 ALLEXCEPT
109 DAX Exercise 2
110 DAX Solution 2

DAX Time Intelligence
111 Time Intelligence intro & DATEADD
112 YeartoDate & MonthtoDate
113 TOTALYTD vs DATESYTD
114 DATESBETWEEN

DAX Advanced topics
115 Logical operators
116 Formatting & Commenting
117 Using Variables
118 Using quick measures in a smart way

Tell a story with your data learn to visualize effectively
119 Intro Best practises
120 Show empathy & indentify the requirements
121 Find the most suitable KPIs
122 Choose an effective visual
123 Make use of natural reading pattern
124 Tell a story using visual cues
125 Avoid chaos & group information
126 Wrap up storytelling with data

Power BI Service Power BI Cloud
127 How to go on now
128 Power BI Pro vs Premium & Signing up
129 An alternative if you dont have a business email
130 Exploring the interface
131 Discovering your workspace
132 Little note on the next lecture Uploading your report
133 Connecting Power BI Desktop & Cloud
134 Understanding datasets & reports
135 Working on reports
136 Updating reports from Power BI Desktop
137 Creating and working with workspaces
138 Installing & using a data gateway
139 Get Quick Insights
140 Creating dashboards
141 Sharing our results through Apps
142 Power BI Mobile App
143 Creating the layout for the Mobile App
144 Wrap up Power BI Cloud

RowLevel Security
145 Intro
146 Creating a RowLevel Security
147 RowLevel Security in the Cloud
148 RowLevel Security & Data Model
149 Dynamic RowLevel Security
150 Dynamic ManytoMany RLS
151 Hierarchical RowLevel Security

More data sources
152 JSON & REST API
153 Setting up a local MySQL database
154 Connecting to a MySQL database in Power BI
155 Connecting to a SQL database PostgreSQL

Next steps to improve & stay up to date
156 Congratulations & next steps
157 More data to practise

Bonus
158 Bonus lecture