Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power BI Masterclass - your future in data analytics
Rating: 4.5 out of 5(72 ratings)
528 students

Power BI Masterclass - your future in data analytics

Microsoft Power BI - data analytics beginner to professional special extended. Power BI Training
Created byDan We
Last updated 5/2023
English
English [Auto],

What you'll learn

  • You can quickly create stunning reports in Power BI
  • You can generate valuable insights for yourself and your company
  • You can improve strategic decision making and create competitive advantages
  • Taking the Power BI Masterclass series on udemy will prepare you to start your data analytics career
  • You can write powerful advanced Dax calculations in Microsoft Power BI
  • You know the latest tips and tricks in Power BI

Course content

1 section • 22 lectures • 2h 39m total length

  • 1 Power BI Masterclass Future DA Intro1:22

    Master advanced Power BI techniques for data analytics, including DAX expressions, custom visuals, tooltips, Q&A, and step-by-step calculations, with burrito charts and map visualizations.

  • One important thing before you start0:24
  • Download latest course files0:05
  • 4 Power BI How to do visual tooltips in your reports18:46

    Learn to create and customize visual tool tips in Power BI reports, including building tooltip pages, enabling tool tips on visuals, and embedding fields for richer insights.

  • 5 Power BI the QandA feature explained what can we do with it11:48

    Power BI masterclass explains how to use the Q and A feature to generate visuals from questions, convert results to standard visuals, and customize Q&A pages and buttons for reports.

  • 6 Power BI how to syncronize Slicers on selected Report pages8:43

    Master syncing slicers across Power BI report pages by configuring a category slicer and enabling synchronization between pages, including visibility on multiple pages.

  • 7 Timeintelligence with running totals and how to display Total Sales15:41

    Create and load a dates table in Power BI to enable time intelligence, then build running total and monthly running total measures to display total sales accurately across periods.

  • 8 Power BI DAX - ALL vs ALLSELECTED Visually explained whats the difference9:22

    Explore the difference between all and all selected in Power BI dax, using calculate to compute total sales while ignoring or preserving filters via a country slicer and year filter.

  • 9 Power BI Iterator Functions in DAX practical use case example5:33

    Explore how DAX iterator functions like the sumx function operate on a table, applying filters such as sales above 500 and amount less than 30 to compute total sales.

  • 10 Power BI Use DAX to create a Ranking on two customer KPIs13:21

    Master the use of DAX in Power BI to rank two customer KPIs by total sales and profit margin with RankX and ALL, then combine into a final ranking.

  • 11 Power BI DAX - How to classify our Employees based on their sales numbers7:52

    Apply DAX to classify employees by total sales using a helper table of min and max thresholds and a measure that returns top seller, average seller, or bad seller.

  • 12 Advanced DAX Dynamically show sales of TOP N countries with correct Totals12:16

    Learn to create a dynamic top N ranking in Power BI with DAX: add a parameter, use rankx, and sum the visible top countries with TOPN.

  • 13 ParetoCharts in Power BI with DAX - Step by Step12:51

    Learn to build a step-by-step Pareto chart in Power BI with DAX, ranking categories, adding an 80 percent line, and plotting running totals and category percentage.

  • 14 Power BI DAX - Additional TimeIntelligence and MeasuresTable Trick12:37

    Master time intelligence in Power BI by comparing sales with same period last year and parallel period, using the date at function and a measures table for a cleaner model.

  • 15 Clusteranalysis easy in Power BI3:44

    Create a scatter plot in Power BI to perform cluster analysis, using total sales and amount as axes, with automatically detected clusters and adjustable cluster counts for meaningful customer segmentation.

  • 16 Custom Visuals Countdown Timer3:38

    Learn to use the countdown timer custom visual in Power BI: import from marketplace, insert into a report, and customize days, hours, minutes, seconds, and styling.

  • 17 Custom Visuals for Stock prices - animations5:41

    Import the KPI ticker from marketplace, load stock data from Excel, and configure a Power BI KPI visual to show current, last, and delta values with animated, customizable styles.

  • 18 Waffle chart for visualizing Survey results in Power BI4:18

    Learn to create and customize a waffle chart in Power BI to visualize survey results, using data from Excel and marketplace visuals, with inverted logic to show percentage shares.

  • 19 Visualizing Maps with your own customized style in Power BI9:08

    Learn to visualize maps in Power BI with a customized Mapbox visual, using latitude and longitude data, an access token, and style options like heat maps and vintage styles.

  • DAX Motivation Never give up keep going1:02

    Stay motivated while learning DAX in Power BI by starting small, dissecting your code, and embracing repetition; never give up as you progress on this continuous journey.

  • What have you achieved0:42

    Celebrate completing the course and leverage newly learned Power BI features to unlock future data analytics career opportunities; explore my other courses on machine learning, networks, and artificial intelligence.

  • More learning together1:00

Requirements

  • Power BI Desktop can be downloaded for free
  • Your willingness to learn and grow
  • I highly recommend to check out the first Masterclass "Power BI Masterclass - beginners to advanced" first
  • To get an indepth understanding of Power BI and it's unlimited possibilities check out the other five Power BI Masterclass courses as well
  • However everybody is free to join this course

Description

Microsoft Power BI Masterclass  - Your future in data analytics

Why Power BI? In a world of data Business Intelligence / Business Analytics is in high demand. 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 worldwide with the necessary capabilities to help them analyze and understand their data, 

It is a "War for talent". This offers tremendous job opportunities for all who are interested in the topic and want to dive into it.  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.  Gartner has labeled Power BI as a leader in their BI quadrant - and considers Power BI visionary. Already today we can see that companies will more and more replace old Powerpoint and standard Excel with Power BI. We are already in the process towards this data driven future.

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 new Power BI Masterclass - Your future in data analytics course 

The main goal is to help you to further increase your skills from my other Power BI Masterclass Series courses on udemy and become even better I collected additional techniques and tricks to get you to the next level. 

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. 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!


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


 All we do here 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! Buckle up and meet me in the first lecture starting today!

Let's get into it and master Power BI in no time!

Who this course is for:

  • This course extends my complementary Power BI Masterclass Series on udemy
  • Everyone is welcome to join and explore the advantages of this tool for her/himself
  • Students who are interested in data analytics
  • You want to master self service bi
  • Students who want to invest in themselves and explore new job opportunities
  • You want get valuable insights from your data
  • Students who know that legacy tools like Powerpoint and Excel will be replaced and want to acquire knowlege about the new tools
  • You want to lay the foundations for a successful future in the era of data
  • You want to take advantage of the data driven opportunity ahead

Report abuse