Power BI Masterclass - Beginners to Advanced

Video description

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.

What You Will Learn

  • 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 may want to become better at your job or explore a new career opportunity. You want to master self-service BI. You might 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.

About The Author

Dan We: Daniel Weikert is a 33-year-old entrepreneur, data enthusiast, consultant, and trainer. He is a master’s degree holder certified in Power BI, Tableau, Alteryx (Core and Advanced), and KNIME (L1–L3).

He is currently working in the business intelligence field and helps companies and individuals obtain vital insights from their data to deliver long-term strategic growth and outpace their competitors.

He has a passion for learning and teaching. He is committed to supporting other people by offering them educational services and helping them accomplish their goals, gain expertise in their profession, or explore new careers.

Publisher resources

Download Example Code

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

Product information

  • Title: Power BI Masterclass - Beginners to Advanced
  • Author(s): Daniel We
  • Release date: June 2018
  • Publisher(s): Packt Publishing
  • ISBN: 9781789533095