O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Power BI Masterclass - Beginners to Advanced

Video Description

Power BI - master self-service business intelligence in no time

About This Video

In this course, you will go from 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 visualizations and reports
  • Derive valuable highly profitable insights

In Detail

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 advanced yet easy to get started self-service business analytics/business intelligence solution provided by Microsoft and it's currently in very hot demand. Daniel can confirm that companies will actively be searching for you if you master Power BI. 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.

Table of Contents

  1. Chapter 1 : Let's get into it! Together we make it happen!
    1. 0 Introduction - Why are you here and what we will accomplish here 00:03:16
    2. 0.5 Think with the end in mind 00:01:28
    3. 1 The Power BI interface -what you need to know 00:23:14
    4. 2 Power BI Masterclass - the easy way 1 00:05:29
    5. 3 Power BI Masterclass - the easy way 2 00:25:19
    6. 4 The Query Editor - clean up messy data 00:03:18
    7. 5 Start exploring the Editor 00:12:00
    8. 6 Time intelligence - How to create datetables in Power BI 00:07:25
    9. 7 Query Editor Transformations 00:13:20
    10. 8 Advanced transformation techniques 00:09:51
    11. 9 Special bonus lecture in advanced transformation techniques 00:07:48
    12. 10 Views in Power BI - the relationship view 00:10:40
    13. 11 Introduction to calculations in Power BI Desktop 00:18:12
    14. 12 The measure table trick 00:04:03
    15. 13 DAX calculations continuation 00:12:13
    16. 14 The power of Power BI - Context and Dimensions 00:01:36
    17. 15 Advanced Dax - Time Intelligence 00:21:53
    18. 16 Visualizing your findings 00:24:00
    19. 17 A view on the generated report 00:06:01
    20. 18 Custom visualizations - let's try something new 00:17:21
  2. Chapter 2 : Advanced Dax Section
    1. 19 Advanced Dax - Data preparation 00:08:03
    2. 20 Advanced Dax - Time intelligence continuation 00:16:02
    3. 21 Advanced Dax - Time intelligence the third 00:08:30
    4. 22 Advanced Dax - What are my Top Customers by Product? 00:12:43
    5. 23 Advanced Dax - A year over year comparison 00:07:31
    6. 24 - Which countries contributed most to our sales 00:10:21
    7. 25 Advanced Dax - Scenario Analysis Price and Volume changes 00:10:30
    8. 26 Advanced Dax - Running Total Sales last 30 days 00:07:13
    9. 27 Advanced Dax - How to get the Top 10 clients 00:11:48
    10. 28 Advanced Dax - At which weekday did most Customer buy 00:03:15
    11. 29 Advanced Dax or not Advanced Dax - that is the question 00:04:38
    12. 30 Advanced Dax - What percentage did my top 5 customers contribute 00:13:02
    13. 31 Advanced Dax - How much did we sell on working days / weekends 00:08:29
    14. The final report creation 00:12:35
  3. Chapter 3 : Student questions and Teaser for Power BI Masterclass 2 Expand Excellence
    1. How to get rid of blanks in Slicers 00:07:59
    2. Power BI Masterclass - Expand Excellence Preview 00:01:52
    3. How to publish your Power BI Report 00:05:06
    4. Logout - important final words 00:00:45