Power BI DAX Masterclass – Measures & Calculated Columns
Power BI DAX Masterclass – Measures & Calculated Columns, available at $89.99, has an average rating of 4.58, with 57 lectures, based on 2589 reviews, and has 14695 subscribers.
You will learn about 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 This course is ideal for individuals who are Everyone that wants to know more about Power BI and wants to use DAX for Calculated Columns and Measures It is particularly useful for Everyone that wants to know more about Power BI and wants to use DAX for Calculated Columns and Measures.
Enroll now: Power BI DAX Masterclass – Measures & Calculated Columns
Summary
Title: Power BI DAX Masterclass – Measures & Calculated Columns
Price: $89.99
Average Rating: 4.58
Number of Lectures: 57
Number of Published Lectures: 57
Number of Curriculum Items: 58
Number of Published Curriculum Objects: 58
Original Price: $174.99
Quality Status: approved
Status: Live
What You Will 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
Who Should Attend
- Everyone that wants to know more about Power BI and wants to use DAX for Calculated Columns and Measures
Target Audiences
- Everyone that wants to know more about Power BI and wants to use DAX for Calculated Columns and Measures
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!
Course Curriculum
Chapter 1: Introduction
Lecture 1: Welcome!
Lecture 2: Our Data & Our Project
Lecture 3: DAX Cheat Sheet
Lecture 4: All the files for download
Chapter 2: DAX Basics
Lecture 1: Measures vs. Calculated Columns
Lecture 2: Automatically create a date table with CALENDARAUTO
Lecture 3: CALENDAR
Lecture 4: Script to reuse in your project for date tables
Lecture 5: How to create a complete date table
Lecture 6: Key Measures table
Lecture 7: Aggregation functions
Lecture 8: COUNT, COUNTA, COUNTBLANK,DISTINCTCOUNT & COUNTROWS
Lecture 9: SUMX – How does it work?
Chapter 3: Practical Exercises No. 1
Lecture 1: Exercises
Lecture 2: Solutions
Chapter 4: Filter context vs. Row context
Lecture 1: Power BI vs. Excel
Lecture 2: Filter context
Lecture 3: Row context
Lecture 4: Data model and DAX
Chapter 5: CALCULATE & Table filters
Lecture 1: CALCULATE Basics
Lecture 2: FILTER
Lecture 3: ALL
Lecture 4: ALLSELECTED
Lecture 5: ALLEXCEPT
Chapter 6: Practical Exercises No. 2
Lecture 1: Exercises
Lecture 2: Solutions
Chapter 7: Advanced possibilities with DAX
Lecture 1: Logical operators
Lecture 2: Commenting and Formatting
Lecture 3: VALUES & AVERAGEX
Lecture 4: RANKX
Lecture 5: IF & Top-N-Filter
Lecture 6: Variables
Chapter 8: Practical Exercises No. 3
Lecture 1: Exercises
Lecture 2: Solutions
Chapter 9: Time Intelligence
Lecture 1: Time Intelligence & DATEADD
Lecture 2: Year-to-Date & Month-to-Date
Lecture 3: TOTALYTD vs. DATESYTD
Lecture 4: DATESBETWEEN
Chapter 10: Formatting your Data with DAX
Lecture 1: ROUNDING (Numbers, Currency & Time)
Lecture 2: FORMAT (Predefined Numbers)
Lecture 3: Custom Formatting (Numbers)
Lecture 4: Custom Formatting (Time)
Lecture 5: Formatting Dates
Chapter 11: Quick Measures
Lecture 1: Quick Measures – How to use them?
Lecture 2: Quick Measures – Filters
Lecture 3: Quick Measures – Time Intelligence
Lecture 4: Quick Measures – Rolling Average
Lecture 5: Quick Measures – Aggregation per category
Lecture 6: Quick Measures – Mathematical operations & text operations
Chapter 12: Create your own report – Mini project
Lecture 1: Intro to our mini project
Lecture 2: First set of key measures
Lecture 3: Gross, net & profit filtering
Lecture 4: Combining measures with time filtering
Lecture 5: Report creation – part 1
Lecture 6: Report creation – part 2
Lecture 7: Final report to download
Chapter 13: Bonus
Lecture 1: Bonus lecture
Instructors
-
Nikolai Schuler
Building Better Data Careers
Rating Distribution
- 1 stars: 16 votes
- 2 stars: 19 votes
- 3 stars: 190 votes
- 4 stars: 941 votes
- 5 stars: 1423 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024