Microsoft Power Bi - The Complete Masterclass [2022 Edition]

Master Power BI Desktop, Cloud & Mobile and advanced analytics with DAX (also Data Science)!

What you'll learn
Learn the complete workflow in Power BI from A to Z
Advanced analytics with DAX - calculated columns & measures
All-in-One: Power BI Desktop, Power BI Cloud & Power BI Mobile!
Learn how to design and implement professional reports
Learn storytelling with data to visualize your data effectively
Advanced features such as working with parameters, using R scripts, optimizing performance and
Row-Level Security
Performance optimizing
Storytelling with data
Python & R in Power BI
Forecasting & advanced analytics
Time intelligence
Requirements
A computer with Windows operating system
Power BI Desktop (free download)
For some modules with Power BI Service (Cloud) account a school or work email adress is required to sign up (free 60 day trial)
Description
Do you want to learn the skills to professionally analyze data?Do you want to learn all the steps to create impressive reports?Then Microsoft Power BI is the right tool for you!In this course you will learn – step by step – everything that is important in Power BI to become an advanced Power BI report creator.That’s what you’ll learn:Power BI Desktop, Power BI Cloud & Power BI Mobile!✓ Understand everything from scratch – step by step, very structured and practice-oriented✓ Learn all the important tools – know when and how to use them properly✓ Connect different data sources – from basics to advanced✓ Create your data model – and understand it✓ Master DAX – to do more advanced analysis on your data✓ Get to know all the different visualizations – and how to use them✓ Storytelling with data – learn how to visualize your data effectively✓ Create interactive visualizations – with drill throughs and drill downs✓ Advanced analysis – learn how to use R Script in Power BI (Data Science)✓ Forecasting – Advanced analytics which can be helpful in Data Science✓ Row-Level Security – Implement the security concept to control access to the dataThis course is right for you if…… you have never worked with Power BI and want to learn everything hands-on in one course…. OR you have already some basic knowledge and want to dive deeper and become more advanced in the whole universe of Power BI.This is the course that covers everything in Power BI to become an advanced report devolopper! Enroll now to get life long access!

Overview

Section 1: Introduction

Lecture 1 Welcome!

Lecture 2 What is Power BI?

Lecture 3 Download & Installing Power BI Desktop

Lecture 4 Quick Interface Tour

Lecture 5 Mini Project: Transform Data

Lecture 6 Mini Project: Visualize Data

Lecture 7 Mini Project: Creating a Data Model

Lecture 8 Course Outline: What will you learn in this course?

Lecture 9 How to lean best with this course?

Lecture 10 All source files & course slides

Section 2: Preparing our Project

Lecture 11 Creating our initial project file

Lecture 12 Working with the attached project files

Section 3: Data Transformation - The Query Editor

Lecture 13 Exploring the Query Editor

Lecture 14 Connecting to our data source

Lecture 15 Editing rows

Lecture 16 Changing data types

Lecture 17 Replacing values

Lecture 18 Close & Apply

Lecture 19 Connecting to a csv file

Lecture 20 Connecting to a web page

Lecture 21 Extracing characters

Lecture 22 Splitting & merging columns

Lecture 23 Creating conditional columns

Lecture 24 A little note regarding the next lecture

Lecture 25 Creating columns from examples

Lecture 26 Merging Queries

Lecture 27 Pivoting & Unpivoting

Lecture 28 Appending Queries

Lecture 29 Practise & Solution: Population table

Lecture 30 The Fact-Dimension-Model

Lecture 31 Practise: Load the dimension table

Lecture 32 Organizing our queries in groups

Lecture 33 Text to be used in the next lecture

Lecture 34 Entering data manually

Lecture 35 Creating an index column

Lecture 36 Workflow & more transformations

Lecture 37 Module summary

Section 4: Data Transformation - Advanced

Lecture 38 Advanced Editor - Best practises

Lecture 39 Performance: References vs. Duplicating

Lecture 40 Performance: Enable / Disable Load & Report Refresh

Lecture 41 Group by

Lecture 42 Mathematical Operations

Lecture 43 Run R Script

Lecture 44 Using Parameters to dynamically transform data

Lecture 45 M formula language: Basics

Lecture 46 M formula language: Values, Lists & Tables

Lecture 47 M formula language: Functions

Lecture 48 M formula language: More functions & steps

Section 5: Creating a Data Model

Lecture 49 Why a data model?

Lecture 50 Create & edit relationships

Lecture 51 One-to-many & one-to-one relationship

Lecture 52 Many-to-many (m:n) relationship

Lecture 53 Cross filter direction

Lecture 54 Activate & deactivate relationships

Lecture 55 Module summary

Section 6: Data Visualization

Lecture 56 Our first visual

Lecture 57 The format tab

Lecture 58 Understanding tables

Lecture 59 Conditional formatting

Lecture 60 The Pie Chart

Lecture 61 All about the filter visual

Lecture 62 The filter pane for developers

Lecture 63 Cross filtering & edit interactions

Lecture 64 Syncing slicers across pages

Lecture 65 Creating drill downs

Lecture 66 Creating drill throughs

Lecture 67 The tree map visual

Lecture 68 The decomposition tree

Lecture 69 Understanding the matrix visual

Lecture 70 Editing pages

Lecture 71 Buttons & Actions

Lecture 72 Bookmarks to customize your report

Lecture 73 Analytics and Forecasts with line charts

Lecture 74 Working with custom visuals

Lecture 75 R Script to use

Lecture 76 Get data using R Script & R Script visual

Lecture 77 Asking questions - Q&A visual

Lecture 78 Wrap up - data visualization

Section 7: Power BI & Python

Lecture 79 Python in Power BI - Plan of attack

Lecture 80 Setting up Python for Power BI

Lecture 81 Transforming data using Python

Lecture 82 Python script I used in the next lecture

Lecture 83 Creating visualizations using Python

Lecture 84 Python script II used in the next lecture

Lecture 85 Violin plots, pair plots & ridge plots using Python

Lecture 86 Python script III used in the next lecture

Lecture 87 Machine learning (BayesTextAnalyzer) using Python

Lecture 88 Performance & Troubleshooting

Section 8: DAX - The Essentials

Lecture 89 Intro

Lecture 90 The project data

Lecture 91 DAX cheat sheet

Lecture 92 All files for the DAX part

Lecture 93 Measures vs. Calculated Columns

Lecture 94 Automatically creating a date table in DAX

Lecture 95 CALENDAR

Lecture 96 Creating a complete date table with features

Lecture 97 Script to be used in your future projects

Lecture 98 Creating key measure table

Lecture 99 Aggregation functions

Lecture 100 The different versions of COUNT

Lecture 101 SUMX - Row based calculations

Lecture 102 DAX Exercise 1

Lecture 103 DAX Solution 1

Section 9: DAX - The CALCULATE function

Lecture 104 CALCULATE - The basics

Lecture 105 Changing the context with FILTER

Lecture 106 ALL

Lecture 107 ALLSELECTED

Lecture 108 ALLEXCEPT

Lecture 109 DAX Exercise 2

Lecture 110 DAX Solution 2

Section 10: DAX - Time Intelligence

Lecture 111 Time Intelligence intro & DATEADD

Lecture 112 Year-to-Date & Month-to-Date

Lecture 113 TOTALYTD vs. DATESYTD

Lecture 114 DATESBETWEEN

Section 11: DAX - Advanced topics

Lecture 115 Logical operators

Lecture 116 Formatting & Commenting

Lecture 117 Using Variables

Lecture 118 Using quick measures in a smart way

Section 12: Tell a story with your data - learn to visualize effectively

Lecture 119 Intro - Best practises

Lecture 120 Show empathy & indentify the requirements

Lecture 121 Find the most suitable KPIs

Lecture 122 Choose an effective visual

Lecture 123 Make use of natural reading pattern

Lecture 124 Tell a story using visual cues

Lecture 125 Avoid chaos & group information

Lecture 126 Wrap up - storytelling with data

Section 13: Power BI Service - Power BI Cloud

Lecture 127 How to go on now?

Lecture 128 Power BI Pro vs Premium & Signing up

Lecture 129 An alternative if you don't have a business email

Lecture 130 Exploring the interface

Lecture 131 Discovering your workspace

Lecture 132 Little note on the next lecture - Uploading your report

Lecture 133 Connecting Power BI Desktop & Cloud

Lecture 134 Understanding datasets & reports

Lecture 135 Working on reports

Lecture 136 Updating reports from Power BI Desktop

Lecture 137 Creating and working with workspaces

Lecture 138 Installing & using a data gateway

Lecture 139 Get Quick Insights

Lecture 140 Creating dashboards

Lecture 141 Sharing our results through Apps

Lecture 142 Power BI Mobile App

Lecture 143 Creating the layout for the Mobile App

Lecture 144 Wrap up - Power BI Cloud

Section 14: Row-Level Security

Lecture 145 Intro

Lecture 146 Creating a Row-Level Security

Lecture 147 Row-Level Security in the Cloud

Lecture 148 Row-Level Security & Data Model

Lecture 149 Dynamic Row-Level Security

Lecture 150 Dynamic Many-to-Many RLS

Lecture 151 Hierarchical Row-Level Security

Section 15: More data sources

Lecture 152 JSON & REST API

Lecture 153 Setting up a local MySQL database

Lecture 154 Connecting to a MySQL database in Power BI

Lecture 155 Connecting to a SQL database (PostgreSQL)

Section 16: Next steps to improve & stay up to date

Lecture 156 Congratulations & next steps

Lecture 157 More data to practise

Section 17: Bonus

Lecture 158 Bonus lecture

Anyone that is looking for a complete and comprehensive intro to Power BI,Everyone that wants to also learn more advanced Power BI skills such as DAX for calculated columns and measures,Anyone that wants to pursue a career as a data analyst, data scientist or BI consultant,Anyone that has never used Power BI before and is looking for a hands-on approach to learn it