Power Bi Masterclass Beginners To Advanced

  1. Home
  2. Microsoft-power-bi
  3. Power Bi Masterclass Beginners To Advanced

Tags: Microsoft Power BI

Microsoft Power BI How to learn Power BI fast. The best Power BI Training online for beginners. Best Master Class

Last updated 2022-01-10 | 4.5

- Taking the Power BI Masterclass series on udemy will prepare you to start your data analytics career
- You can quickly create stunning reports in Power BI
- You can transform messy data into the right format

What you'll learn

Taking the Power BI Masterclass series on udemy will prepare you to start your data analytics career
You can quickly create stunning reports in Power BI
You can transform messy data into the right format
You can generate valuable insights for yourself and your company
You can improve strategic decision making and create competitive advantages
You can write powerful advanced Dax calculations in Microsoft Power BI
You can design Power BI Reports
You can create Power BI Dashboards (Reports) in no time
Please note! Mac Users have currently only the option to use Power BI via the Power BI Service in their browser (some limitations ) or with Turbo

* Requirements

* Working with Microsoft products e.g. excel is an advantage
* but not required
* Your willingness to learn and grow
* This is a Microsoft Power BI Training for beginners to advanced
* Power BI can be downloaded for free from the Microsoft page

Description

Microsoft Power BI in 12 hours beginners to advanced

Business Intelligence / Business Analytics is in high demand. Companies are constantly searching for ways to make better and faster decisions. Therefore they rely heavily on data. Data driven decision making is the key to success for any business in the world of tomorrow.

Because of that companies are constantly searching for skilled employees and freelancers with the necessary capabilities to help with analyzing data and creating valuable highly profitable insights. This will be the key advantage to succeed in business.

MS Power BI is an andvanced yet easy to get started self service business analytics / business intelligence solution provided by Microsoft which is currently in very hot demand. From my personal experience I can tell you that companies will actively searching for you if you master Power BI. Diving into data & analytics can not only immensly improve your career opportunities but also your job satisfaction!

Power BI is also a great tool for datascience too. A lot of data scientists like to use it for visualizing and presenting the findings. Therefore learning to use this tool can also be a valuable skill for datascience jobs.


That is why I created this course to help you get started to dive into on of the hottest and best business analytics / business intelligence software currently out there. Starting from scratch we will learn all the relevant PBI basics and also master more advanced concepts step by step. Power BI has a very strong active community and with Microsoft pushing this solution to it's enterprise customers, Power BI has a bright future ahead. And you can be part of this future!

There is no coding required! Power BI allows you to do that but it's not necessary.

In this guided learning course you will start form zero to hero in 6 hours and you will learn:

  • the ETL capabilities of Microsoft Power BI ("get messy data easily into the right format")

  • Master simple and very advanced DAX (Power BI language, similar to like excel formulas) calculations

  • Create outstanding visualisations and reports

  • Derive valuable highly profitalbe insights

What we learn in this course might also help you later with your Power BI certification exam.

You can follow along with the provided learning material in Power BI on your own computer at your own pace. Much better then only reading a book right? Exited? You should be. So how to learn Microsoft Power BI Desktop? Buckle up and meet me in the first lecture starting today!


Update: The complete Power BI Masterclass Series on udemy (I have aggregated some classes together to provide more content value per class for you. I really hope that serves you better!

1. Power BI Masterclass - beginners to advanced

2. Microsoft Power BI Masterclass - Expand Excellence

3.Power BI Masterclass - DAX, Excel And More

4. The Power BI Masterclass - Additional Tips and Tricks

5. Power BI Desktop - Data Prep Challenges

6. Power BI Masterclass - DAX, R and Gateways

7. Power BI Masterclass - Python Finance and Advanced DAX

8. Power BI Masterclass - the next level

9. Power BI DAX Fundamentals Mastering the Key Concepts


 The complete Masterclass Series which covers all relevant features in Power BI consists of 8 courses now. This one is the first.The other  consecutive classes are available here on udemy.  Each course covers additional DAX insights, Power BI features, tips and tricks and best practices in report creation. If you find this course helpful then feel free to check them out as well. You can easily find them by checking out my Instructor profile.

best regards and happy learning.



Who this course is for:

  • You want to become better at your job OR explore a new career opportunity
  • You want to master self service bi
  • You want to get valuable insights from you data
  • You want to be in high demand (as employee or freelancer)
  • You want to succeed in the working world of tomorrow
  • You want to create stunning visualizations to impress management or your coworkers
  • You want to stand out from the crowd
  • You want to learn and to improve

Course content

4 sections • 105 lectures

The Power BI Masterclass - Updated 42 lectures

1 The Power BI Masterclass 2022 lets get started Preview 02:20

About this Update Preview 00:42

Before you start Preview 00:48

Download the latest course files here to follow along Preview 00:03

2 If necessary enable the new format pane preview feature Preview 01:32

3 A complete tour through the Power BI Interface Preview 38:25

4 Our first Power BI Report lets get started Preview 23:25

5 Finishing our first report Preview 22:41

6 Power BI the more advanced way exploring the dataset Preview 03:11

7 Preparing the dataset using Power Query Editor Preview 18:36

8 How to create a proper Datestable in Power BI Preview 09:43

9 Datatransformation and cleaning Lets explore the Power Query Editor Preview 24:47

10 Data enrichment with web data extraction Preview 12:55

11 Datamodel setup Modelview and Relationships Preview 22:27

12 Introduction to calculated columns and measures in Power BI Preview 24:02

13 The measures table trick Preview 03:45

14 Creating DAX measures in Power BI practise round Preview 12:32

15 Flexibility of DAX Measures why they are so great Preview 04:03

16 Dates and Drilldown functionality in Power BI Preview 08:47

17 Additional info to the Auto datetime feature in Power BI Preview 03:30

18 Timeintelligence DAX Calculations in Power BI getting started Preview 09:50

19 Timeintelligence DAX Calculations in Power BI more flexibility Preview 07:53

20 Timeintelligence DAX Calculations Cumulative Sum or Running Totals Preview 13:42

21 DAX Measure Cleanup and Formatting best practise Preview 09:23

22 The final Power BI Report creation Preview 17:55

23 Advanced Training 2 New dataset setup Preview 13:50

24 Practising DAX measures and Bulk Formatting Tricks Preview 15:15

25 DAX Timeintelligence different Functions allow different Insights Preview 12:43

26 Ranking and dynamic Ranking in Power BI Preview 18:48

27 Power BI DAX Expressions Cumulative Sales for the prior year Preview 14:08

28 Introduction to Scenario Analysis in Power BI Preview 12:04

29 Rolling 30 day Sales DAX Expression Preview 10:33

30 DAX Table functions in Power BI lets get into it Preview 10:54

31 Advanced DAX Top 10 Customers Preview 08:12

32 Customer Insights How many customers by weekday Preview 09:35

33 DAX or No DAX that is the question Preview 07:21

34 Advanced DAX Customer Classification Preview 16:18

35 Introducing Variables while calculating Weekday Sales Preview 14:53

36 Lets create our final report Preview 21:38

37 Addon Buttons and Page Navigation in Power BI Preview 24:46

NEW - A free resource for bonus videos tips and tricks Preview 00:04

Congratulations and Motivation Preview 00:41

This is the slightly "older part" of section 1. Will be removed in the future 36 lectures

1 Power BI Masterclass - beginners to advanced Introduction Preview 01:29

Download latest course files Preview 00:10

3 A first tour through the Power BI Interface Preview 28:56

4 Power BI the easy way - lets get started Preview 24:20

5 Power BI the easy way lets finish our first report in Power BI Desktop Preview 18:27

6 Power BI the advanced way - lets dive into our dataset Preview 04:25

7 The Power BI Query Editor - Datapreparation in action Preview 18:26

8 Import the new and advanced date table into our model Preview 07:27

9 Walk through Transformation steps in Powerquery Editor Preview 22:52

10 Data enrichment importing web data into Power BI Preview 16:15

11 Exploring the Model View and setting up Relationships Preview 20:17

12 First Calculations in Power BI Calculated Columns and Measures Preview 16:54

13 The Measures Table Trick - Structuring our report Preview 04:08

14 Power BI DAX - Practise creating further Measures Preview 13:46

15 The Beauty of Flexibility - Power BI Slicing and Dicing Preview 02:51

16 Date drill down functionalities in Power BI Preview 07:12

17 Autodatetime in Power BI - What you need to know about Date hierarchies Preview 05:29

18 Advanced Dax - Intro to Timeintelligence DAX Measures Preview 12:46

19 Advanced Dax - Flexibility in Timeintelligence DAX Functions Preview 08:10

20 Advanced Dax - Cumulative or Running Total Sales Calculation in DAX Preview 11:39

21 Power BI Lets create our final report Preview 22:38

22 Welcome to Part 2 Setting up our new model structure Preview 16:05

23 Power BI DAX - creating our base measures Preview 11:05

24 Advanced TimeIntelligence in DAX - Parallelperiod and potential use cases Preview 09:36

25 Advanced DAX - Dynamic Sales Rankings Preview 15:48

26 Advanced DAX - Running Total Sales and prior year sales Preview 16:03

27 Power BI - visualizing insights from our data Preview 12:36

28 Scenario Analysis in Power BI Preview 11:57

29 Advanced DAX - Running Total X Day Sales Preview 08:34

30 DAX - An Introduction to table functions Preview 08:02

31 Advanced DAX What are the Top 10 Clients Preview 08:22

32 Advanced DAX - How many Customers per Weekday Preview 07:07

33 Power BI DAX or no DAX - that is the question Preview 06:12

34 Advanced DAX - Customer Classification in Power BI Preview 15:19

35 Advanced DAX - Variables and Sales per Weekday and Weekends Preview 11:33

36 Create our final Report in Power BI Preview 28:10

How to use CALCULATE in Power BI Desktop 18 lectures

About this section Preview 00:27

Download latest course files for this section Preview 00:02

1 Introduction to the CALCULATE function starting from scratch Preview 08:02

2 Filter Contexts Row Context and Context Transition in Power BI explained Preview 19:17

3 Combine Calculate with ALL and VALUES Preview 14:15

4 Excourse dynamic selection with CALCULATE Preview 10:36

5 How to apply multiple criteria filter with CALCULATE in Power BI Preview 06:29

6 How to use multiple Filtercriteria with CALCULATE in Power BI OR Preview 07:00

7 CALCULATE with multiple criteria from different columns in Power BI Preview 08:55

8 Salesclassification using CALCULATE Preview 14:01

9 Cleaning up and quickly set up the new model Preview 11:04

10 Applying ALL and ALLSELECTED with CALCULATE in Power BI Preview 14:02

11 CALCULATe with the Keepfilters modifier Preview 08:22

12 Modify model relationships with CALCULATE Preview 09:58

13 Using Context Transition with CALCULATE to evaluate the maximum sales on a da Preview 11:32

14 Visual understanding of the expanded table concept Preview 11:23

15 CALCULATE modifiers remove all filters except one Preview 08:05

16 Using CALCULATE with Timeintelligence Expressions Preview 07:11

Bonus section 9 lectures

Download resources for the bonus videos here Preview 00:02

Bonus 1 How to improve your Reports even further with custom visuals a few examp Preview 18:49

Bonus 2 How to publish and share your power bi Report Preview 03:55

Bonus 3 How to create your own Datestable with DAX explore available Options Preview 10:12

Bonus 4 Power BI Interview question SUM vs SUMX Difference Preview 12:20

Bonus 5 Best and Worst Customer Identification and dynamic Sales Thresholds with Preview 17:42

Power BI Masterclass 2 Expand Excellence Preview What we will learn Preview 02:07

Power BI Bonus Tip Cascading slicers without bidirectional relationships Preview 17:37

You want to become a Power BI Expert? Here are more learning resources Preview 00:48