Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Power BI Masterclass 7 Learn DAX, R, and Gateways
Rating: 4.4 out of 5(169 ratings)
1,165 students

Microsoft Power BI Masterclass 7 Learn DAX, R, and Gateways

How to become a data analyst fast. Microsoft Power BI online training. How to use R in Power BI Power BI Data Science
Created byDan We
Last updated 3/2025
English

What you'll learn

  • You master advance DAX calculations and build on your prior acquired knowlege from the other Masterclass courses
  • Taking the Power BI Masterclass series on udemy will prepare you to start your data analytics career
  • You can use R in Power BI
  • You learn how to set up you personal data gateway
  • You can generate valuable insights for yourself and your company

Course content

1 section • 22 lectures • 3h 34m total length

  • 1 Introduction what do we learn here1:16

    Explore Power BI masterclass foundations, including Power BI Desktop, DAX, and R, and learn three ways to use R, publish reports, and set up data gateways to keep data fresh.

  • Here you can download the latest course resources to follow along0:03
  • 2 If necessary enable the new format pane preview feature1:32

    Enable the new formatting pane preview feature in Power BI via file, options and settings, and selecting preview features. Restart to apply changes, and follow along regardless of version.

  • 3 DAX Challenge Getting started setting up our datamodel15:20

    Import and set up an Excel data model in Power Query, prepare tables (sales and price), rename as tbl, and build a dates table for time intelligence in Power BI.

  • 4 Power BI DAX Challenge Dealing with Product Price Changes26:56

    Master Power BI DAX to compute regular and adjusted sales using a price change table, lookups, and quarter-based pricing, with proper date hierarchies and a dedicated measures table.

  • 5 Power BI DAX Challenge Age in DAX and Power Query16:22

    Master age calculation in Power BI with DAX and Power Query to derive ages from birth dates, using today's date and functions like selected value and has one value.

  • 6 Power BI DAX Challenge Open Customer Requests15:56

    Learn to build a running total of open cases in Power BI using DAX. Calculate the open minus closed difference and accumulate with all and filter on an index.

  • 7 A new model setup and DAX Timeintelligence practice23:33

    Set up a new Power BI data model by importing Excel data and cleaning gaps. Create a dates table and time-intelligence measures, including running total and year-to-date analytics.

  • 8 Power BI DAX Challenge What is the customers first ordered product13:05
  • 9 Setting up the R Environment for Power BI2:38

    Install and configure the R environment for Power BI by choosing RStudio or other options, setting the R home directory in Power BI, and installing needed packages with install.packages.

  • 10 R Visualizations in Power BI Desktop11:57

    Explore creating and customizing an R script visual in Power BI desktop, enabling scripting, dragging category and sales fields, building a bar chart, and slicer-driven filtering.

  • 11 Using R to import Data in Power BI15:15

    Explore how to import data into Power BI with R, using the R script to load csv files, and transform data with R scripts inside the Power BI editor.

  • 12 Addon How to create awesome R Visualizations in Power BI4:43

    Explore creating awesome R visualizations in Power BI by using the graphic gallery, copying ready-made code, and adapting data and columns with the necessary libraries to visualize your data.

  • 13 Power BI DAX Challenge The customers last Order Sales13:42

    Learn to compute a customer's last product sales and last order date in Power BI using DAX techniques like SumX, summarize, and CALCULATETABLE, with context-aware filters.

  • 14 Power BI DAX Challenge Recurring Customers from prior year12:32

    Create a DAX measure to identify recurring customers across years using variables, calculate table, and intersect, returning sales for current and prior year only for customers present in both years.

  • 15 Motivation Keep going never give up0:56

    Dissect each DAX measure step by step, practice different DAX functions, and keep learning, because mastering DAX is a long journey and you should never give up.

  • 16 Sharing your work in the Power BI Service8:19

    Publish your final Power BI reports to the service by logging in with a work email, selecting a workspace, and uploading the report and dataset for colleagues to view.

  • 19 Excourse - Setting up a data gateway to refresh local files in the Power BI S7:38

    Set up and configure an on-premises data gateway to refresh local data in Power BI. Install the gateway, map your local file to the gateway, and enable scheduled refresh.

  • BONUS - How to create your own BUMP chart in Power BI9:36

    Build a bump chart in Power BI by creating a sum of sales, a ranking with rankX, and plotting a line chart with a categorical year axis and legend.

  • BONUS - PBI Interview Question SUM vs SUMX12:20

    Compare the sum and sumx functions to illustrate row-by-row calculations, showing how sumx iterates over each sales row to multiply quantity by price and produce accurate total sales.

  • Congratulations, thanks a lot and one favor to ask0:21
  • more learning0:50

Requirements

  • This course extends my exclusive Power BI Masterclass on udemy (select my profile for more information)
  • Power BI can be downloaded for free, no additional costs
  • All additional files and material will be provided
  • Your interest and willingness to learn new things and grow and explore new opportunities
  • I highly recommend to check out the first Masterclass "Power BI Masterclass - beginners to advanced" first
  • If you want to master Power BI completely I recommend taking all complementary courses of the masterclass series

Description

Master Microsoft Power BI and create  your succesful business analyst / data analyst career

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.

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.

To help you getting into this highly rewarding and interesting career path the Power BI Masterclass Series has been created.

It's an exclusive series currently consisting of these courses on udemy.


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


 Each Microsoft Power BI Masterclass course will add to your knowledge base and enhance your skills further. After attending the complete series you will have honed your skills to an very advanced level and be able to succesfully dive into your Microsoft Power BI data analytics career.


In this Masterclass you will

  • learn and apply additional advanded DAX expressions and calculations and dive deep into a business dataset

  • getting an introduction on how to use R in Power BI

  • learn how to set up your personal data gateway to refresh your on premise data in the Power BI service

  • apply new custom visuals

  • create your own Sales dashboards

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!

Who this course is for:

  • Students how have already taken courses of my Power BI Masterclass series on udemy
  • Everyone interested in Microsoft Power BI is welcome to join and explore the advantages of this tool for her/himself
  • You want to master self service bi with Microsoft Power BI
  • 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 excel at your job OR explore a new career opportunity in data analytics
  • You want to lay the foundations for a successful future in the era of data with Microsoft Power BI
  • You want to learn a better tool than Qlickview and IBM Cognos
  • You want to take advantage of the data driven opportunity ahead

Report abuse