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 - DAX, Excel And More
Rating: 4.5 out of 5(143 ratings)
1,079 students

Power BI Masterclass - DAX, Excel And More

Understanding DAX table calculations, Power BI Desktop and Excel. How to master DAX in Power BI. How to learn DAX fast
Created byDan We
Last updated 5/2023
English

What you'll learn

  • You can quickly create stunning reports in Power BI
  • You can generate valuable insights for yourself and your company
  • You understand DAX Logic and Table Calculations
  • You know how to handle many to many relationships in Power BI
  • Taking the Masterclass series on udemy will prepare you to start your data analytics career

Course content

3 sections • 31 lectures • 4h 39m total length

  • Download latest course files0:02
  • 1 Welcome lets set up the datamodel14:07

    Import and structure a Power BI data model by loading Excel data, cleaning and renaming tables, standardizing values, creating a dates table with M code, and establishing relationships.

  • 2 Learning DAX Does the Pareto Rule apply for our dataset14:29

    Build a total sales measure with sumx, then perform a Pareto analysis by ranking customers with rankx on total sales to identify the top 20 percent and test Pareto applicability.

  • 3 Calculate our base measures4:29
  • 4 Learning DAX - Sales Forecast on prior 3 Moth Average6:44

    Explore time intelligence in DAX to forecast current month sales from the prior three months. Create a date table and a sales forecast measure using calculate and dateadd.

  • 5 Learning DAX - Customer Transactions within the last 30 days8:01

    Learn to count customer transactions in the last 30 days using DAX, calculate, and count rows, applying a date table filter with a dynamic max date.

  • 6 Learning DAX - Customer Classification with custom Label calculation10:07

    Create a helper classification table and a DAX measure to label customers as risky, average, or top based on last 30 days transactions with thresholds (0–3, 3–5, 5+).

  • 7 Learning DAX - Dynamic Measure Comparison in Power BI11:42
  • 8 Power BI Tip - how to remove all filters from the report with one click7:41
  • 9 Growth Insights - Profit and Sales Evaluation for Customer base7:21
  • 10 Learning DAX - Modelstructure challenge applying Bridge tables21:59
  • 11 Learning DAX - Calculated Columns for Employee Sales Classification9:03

    Learn to create calculated columns in Power BI to rank employees by total sales with RankX, and classify them as top, average, or bottom for visuals.

  • 12 Learning DAX - Dynamic Calculation of Sales last X Days11:20

    Learn to build a dynamic last X days sales view in Power BI with a what-if parameter and a slicer, filtering dates and calculating total sales per customer.

  • 13 Export Data into csv and Excel2:42

    Export underlying data from a Power BI visual to csv within the current filter context using the visual's three-dots menu, or copy the whole table to Excel from data view.

  • 14 Learning DAX - Advanced Searching in Power BI11:54

    Learn advanced search in Power BI with a DAX measure and slicer to filter trainings by tool, including Excel data import and slicer-driven visuals.

  • 15 Idea - Animate our Power BI Reports7:24

    Import the play axis visual from its source, then animate a report by looping through categories with a defined time interval and category filters for dynamic total profit visuals.

  • 16 QA Feature Introduction in Power BI13:35

    Explore how the Power BI Q&A feature lets users ask questions and generate visuals, and learn to customize visuals with synonyms and Q&A settings.

  • 17 Global Filters in Power BI Syncronize Slicers across report pages9:26
  • 18 Learning DAX - How to replace Calculate with Iterators10:29

    discover how to replace calculate with iterators in DAX to filter data and evaluate total sales in a modified context, using filter to create a subset table.

  • 19 Learning DAX - Customer Ranking on multiple criteria12:33
  • 20 Learning DAX - Fixing total issues in dynamic Visualizations15:07
  • 21 Learing DAX - How to build a Pareto Chart step by step18:01

    Learn to build a burrito chart in power bi by ranking categories with rankx, computing running totals with topn, and adding an 80 percent line and category percentage.

  • 22 Clusteranalysis in Power BI5:46

    Learn cluster analysis in Power BI by building a scatterplot with numeric X and Y, using detail to split the dots, and auto or manual clustering.

  • DAX Motivation Never give up keep going1:02

    Keep your motivation high while mastering DAX in Power BI by starting small and dissecting your code. Persist, practice, and push through challenges as learning DAX remains a continuous journey.

  • More learning together1:00

Requirements

  • Your willingness to learn and grow and explore new opportunities
  • Prior knowledge from "Power BI Masterclass - beginners to advanced" or equivalent skills are recommended
  • This course extends my compelentary courses e.g. "Power BI Masterclass - beginners to advanced"
  • It's the 5th course of the Power BI Masterclass Series to help students to dive into Data Analytics Jobs

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 and offer job opportunities if you manage to master Power BI.

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


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:

  • You want to prepare yourself for the future
  • You have taken the other Power BI Masterclass courses
  • You want are interested in a data analytics career
  • You want to become better at your job OR explore a new career opportunity
  • You want to create value and generate valuable business insights
  • You want to master self service business intelligence
  • You want to create stunning visualizations to impress management or your coworkers
  • You want to take advantage of the data driven opportunity ahead

Report abuse