Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power BI Masterclass Business Intelligence in action
Rating: 4.4 out of 5(85 ratings)
733 students
Created byDan We
Last updated 9/2022
English

What you'll learn

  • You can quickly create stunning reports in Power BI
  • You can create Pagination with the "Pagination trick"
  • You have improved your understanding of DAX Calculations in Microsoft Power BI
  • You can generate valuable insights for yourself and your company
  • Taking the Power BI Masterclass series on udemy will prepare you to start your data analytics career
  • You can design Power BI Reports

Course content

2 sections • 23 lectures • 2h 39m total length

  • Introduction1:50
  • Dowload new resources for updated videos0:02
  • One important thing before you start0:24
  • 3 DAX - Classify categories with custom labels14:01

    Power BI masterclass: import Excel data, clean and transform fields, create a total sales measure with sumx, and classify categories using a DAX switch with custom labels.

  • 4 Calendar options in Power BI with DAX and M13:56

    Learn to build and relate a dates table in Power BI, enabling time intelligence with a robust calendar using DAX and M code, including calendar 1 and calendar auto options.

  • 5 Custom Sorting for visuals in Power BI Desktop8:47

    Create a custom sorting in Power BI Desktop by making a sorting table with category and sort index, relate it to orders, and sort visuals by that index.

  • 6 How to create a star raking in DAX in Power BI11:57

    Demonstrates creating a star rating visualization in Power BI by ranking countries via rankX and all, then displaying stars using a unique char and wrap.

  • 7 DAX Count the customer transactions within last 30 days7:49

    Use DAX to count a customer's transactions in the last 30 days by creating a measure with calculate and countrows, filtering the dates table by the maximum order date.

  • 8 custom customer classification with DAX in Power BI7:48

    Classify every customer in Power BI using a DAX measure and a manual classification table, based on transactions in the last 30 days, with top, okay, and bad categories.

  • 9 Measure Comparison - Setting up the calculations5:35
  • 10 Measure Comparison - Setting up the tables and selections10:15

    Set up two tables in Power BI to compare measures, create selection measures, and use slicers to display total sales and total cost across different selections.

  • 11 Measure Comparison - lets visualize our work10:08

    Create dynamic measure comparisons in Power BI using switch-based measures to visualize total sales and total cost across selections with sensible defaults.

  • 12 Power BI - Creating a button to remove all filters from our report12:04

    Learn to create a Power BI button that removes all filters by using a bookmark, instantly resetting visuals and slicers in a report.

  • 13 Cleaning up - creating the measures table3:55

    Create an all measures table in Power BI, move measures from the orders table using drag and drop in the model view, then clean up by deleting the dummy column.

  • 14 Comparing Average Orders per Customer for different timeframes with DAX13:01
  • 15 DAX - Visualizing healthy growth rates7:49

    Visualize healthy growth by comparing last year's sales growth and profit growth, using the divide function to avoid zero divisions, with a country view and trend line.

  • 16 Lets create our final report7:33

    Create a final Power BI report by adding visuals, including a marketplace custom visual for country insights, and sync filters to compare sales, costs, and profits across countries.

  • DAX Motivation Never give up keep going1:02
  • BONUS - How to create your own BUMP chart in Power BI9:36

    Build a bump chart in Power BI using a sum of sales measure, rankX-based ranking, and a line chart with a categorical x-axis to show category rankings by year.

  • NEW - A free resource for bonus videos tips and tricks0:04
  • You want to learn more and bring your skills to the next level?0:54

Requirements

  • First and foremost - Your willingness to learn and grow and explore new opportunities
  • I recommend to first take my other Power BI course "Power BI Masterclass - beginners to advanced" if you have never worked with Power BI
  • This is the 3rd course of the complementary Power BI Masterclass Series to help students to dive into Data Analytics Jobs
  • Working with Microsoft products e.g. excel is an advantage, but not required

Description

Business Intelligence with Microsoft Power BI - How to?

Why Power BI? In a world of data Business Intelligence / Business Analytics is in high demand. We are living in a data driven society. This trend will continue to accelerate. Companies are constantly searching for ways to make better and faster and smarter decisions. This heavily involves getting insights from their data. Small company or multinational -  data driven decision making is the key to success for ANY business in the world of tomorrow.

Because of that companies are drastically looking out for skilled employees and freelancers with the necessary capabilities to help them analyze and understand their data, 

Since there is way more demand than supply it is a "War for talent". And the competition will increase further. This environment is a bless for anyone who acquires the necessary capabilities and positions herself/himself

So back to the question. Why Power BI? Well, because...

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.

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


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

10. Power BI Masterclass Calculation Groups with Tabular Editor

11. The Power BI Service Masterclass

12. How to build a profit and loss statement in Power BI Desktop


 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.

All this is accomplished with a provided dataset but you can of course use your own dataset and explore it in detail. Additional course materials can be downloaded at no extra costs.


The introduction video contains a preview of a report you will built during the course so check it out.

Exited? You should be! So let's answer the question on how to master Power BI Desktop. Buckle up and meet me in the first lecture starting today!

Let's get into it.




Who this course is for:

  • You have already taken one of my other Power BI courses
  • 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 succeed in the working world of tomorrow
  • You want to learn and to improve
  • You want to create stunning visualizations to impress management or your coworkers

Report abuse