Power BI DAX Masterclass - Measures & Calculated Columns
What you'll learn
- Create your own Measures & Calculated Columns in DAX
- Use DAX in Power BI for advanced data analysis
- Gain advanced insights into your data with DAX
- Understand the concepts behind Measures & Calculated Columns in DAX
- Learn how to use the most important DAX functions
- Create better reports with Measures & Calculated Columns
Requirements
- Some basic knowledge in Power BI is required
Description
From beginner to profesional in DAX – Master advanced analysis in Power BI with Measures & Calculated Columns
DAX is a really powerful language if you want to get all the advanced insights from your data. Wether you want to create custom columns or use more advanced calculations with Measures and realize the full potential of Power BI - DAX is the key to that.
Yet I know that many people feel discourage because they don't know where to start and without help it can be a bit frustrating and difficult.
That's why I have created this course!
In this course you will finally be able to learn DAX for your advance analysis in Power BI - and that in an easy and well structured way.
Get a fundamental understanding right from the beginning
In this course I will teach you everything clearly by looking at actual examples. Therefore we will be looking together at some sales data that you will also be able to download - so you can work and practise as much as you want.
Step by step you will then learn everything you need to know regarding DAX, Measures and Calculated Columns in Power BI.
At the end of this course you will be able to do your own analysis in DAX. At this point it will be easy for you to do and learn more in DAX because you have gained a fundamental understanding in DAX, Measures and Calculated Columns.
What you will learn in this course?
· DAX fundamentals:
· fundamental understanding of Measures & Calculated Columns
· Measures vs. Calculated Columns
· Filter context vs. row context
· DAX in the data model
· Aggregation functions
· Logical Operators and IF-Statements
· Automatically create comprehensive data tables with date features
· Advanced topics:
· Row based functions such as SUMX & AVERAGEX
· Running Totals, Moving Average
· Variables
· RANKX
· Custom Top-N-filtering
· CALCULATE
· All you need to know about CALCULATE
· Filter functions
· ALL, ALLSELECTED, ALLEXCEPT
· FILTER, VALUES
· How to use them the right way
· Quick Measures
· All you need to know about Quick Measures & how to use them properly
· Time Intelligence
· Year-to-Date, Date-To-Month etc.
· The most important time intelligence functions and the right way to work with them
· And much more!
Who this course is for:
- Everyone that wants to know more about Power BI and wants to use DAX for Calculated Columns and Measures
Featured review
![Alina Kapshyk](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
Course content
- Preview02:33
- Preview04:09
- 00:11DAX Cheat Sheet
- 00:12All the files for download
Instructor
- 4.7 Instructor Rating
- 1,085 Reviews
- 6,010 Students
- 7 Courses
In my work as a data scientist and BI consultant in a big company located in Germany. I see that there a lot of new tools that bring a lot of benefits. Yet I also see that it is not always easy to learn working with these tool beside the daily other tasks we have to do.
Also I found it hard to find courses that are high quality as well as easy to understand and well structured.
For that reason I decided to create these courses that are high quality on the one hand and easy to learn with on the other hand.
As I am a data specialist on the one hand but also introducing ordinary users to Power BI and other tools on the other hand, I understand the common hurdels most people have.
Data and teaching are my passions and therefore I am really looking forward to level up your IT skills as well!
In meiner Arbeit als Data Scientist in einem großen Konzern sehe ich, dass neue Tools riesen Vorteile in der heutigen Zeit bringen und sie nicht mehr wegzudenken sind. Allerdings sehe ich auch, dass es nicht immer leicht ist sich neben der täglichen Arbeit in diese neuen Tools einzuarbeiten.
Mir selbst ist es auch schwer gefallen Kurse zu finden, die einerseits qualitativ hochwertig und andererseits verständlich und gut strukturiert sind.
Aus diesem Grund habe ich mich dazu entschlossen selbst strukturierte und praxisorientierte Kurse zu erstellen.
Da ich sowohl für einfache Anwender als auch für Datenspezialisten Einweisungen in Power BI und anderen Tools gebe, bin ich einerseits technischer Spezialist, habe aber andererseits auch ein gutes Gefühl für die, die nicht die reinen Datenspezialisten sind.
Mir zu überlegen wie man das Wissen wirklich sinnvoll und verständlich rüberbringen kann, ist das was mir dabei Freude macht.