Advanced DAX for Power BI
Hear why our Power BI courses are the TOP-RATED on Udemy:
"I totally loved this Power BI course. Everything was very easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much and had fun doing it. In fact, at the end of the day, I didn't want to stop learning I wanted to keep charging on to the next lesson. "
-Ann S.
"Amazing. 5+ stars if you ask me. Concise, superbly organized and prepared. I have learned a ton about Power BI and DAX and enjoyed the course from start to finish."
-Nikola H.
"Hands-down the best Power BI courses on Udemy. Courses are well prepared and very hands-on, and the instructor makes the whole experience easy and fun. I recommend it 100%. "
-Jorge M.
"Where can I leave a 6 star rating?"
-Carlos B.
COURSE In this hands-on, project-based course, you'll put your DAX skills to the test and apply what you learn to some of the toughest real-world business intelligence use cases.
You'll be playing the role of Business Intelligence Analyst for Maven Roasters, a small-batch coffee chain based in New York City. Your goal? Use Power BI and DAX to answer key questions and deliver data-driven insights for the business, by analyzing product inventory, repeat customers, store-level performance, and everything in between.
We'll start by quickly reviewing prerequisite topics (evaluation context, filter flow, basic measures, etc.), then dive behind the scenes to explore how the DAX formula and storage engines actually work, including query evaluation, columnar structures, and VertiPaq compression and encoding.
From there we'll cover helpful tips and best practices for DAX power users, including variables, comments, query formatting and error handling, then dive deep into scalar functions, iterators, advanced time intelligence, calculated table joins, relationship functions, and much, much more. Last but not least, we'll share a sneak peek into performance tuning and DAX query optimization using DAX Studio and Power BI's Performance Analyzer tool.
If you're looking to build expert-level data analysis skills using DAX and Power BI, this is the course for you.
FULL COURSE OUTLINE:
Prerequisite Skills Review
Review the core DAX concepts you should already know, including evaluation context, filter flow, measures, etc.
Course Project Intro
Introduce the Maven Roasters course project, and build the data model that we’ll analyze in Power BI Desktop
The DAX Engines
Understand the DAX formula and storage engines, data types, VertiPaq encoding & compression methods, etc.
DAX Tips & Best Practices
Review helpful tips for formatting DAX queries, adding comments, handling errors, and using DAX variables
Scalar Functions
Explore common DAX scalar functions, including rounding, information, conversion, and logical functions
Advanced
Table & Filter Functions
Create calculated tables, review common DAX filter functions, generate new data, etc.
Calculated Table Joins
Create calculated joins between physical and virtual tables in Power BI ()
Relationship Functions
Explore expanded tables, physical & virtual relationships, common relationship functions, etc.
Iterator ("X") Functions
Explore iterator cardinality, nested iterators, context transition
Advanced Time Intelligence
Build date tables with DAX, compare custom time periods, manage fiscal calendars, etc.
SNEAK PEEK: Performance Tuning
Introduce DAX Studio, the Power BI performance analyzer, and common DAX optimization techniques
Join today and get immediate, lifetime access to the following:
150+ page Power BI & DAX ebook
Downloadable datasets and Power BI project files
Homework assignments & quizzes
1-on-1 expert support
Course Q&A forum
30-day money-back guarantee
See you in there.
-Aaron (Power BI & DAX Instructor, Maven Analytics)
Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses.
Get a Reminder
Rating | 4.7★ based on 74 ratings |
---|---|
Length | 11.5 total hours |
Starts | On Demand (Start anytime) |
Cost | $12 |
From | Udemy |
Instructors | Maven Analytics, Aaron Parry |
Download Videos | Only via the Udemy mobile app |
Language | English |
Subjects | Business |
Tags | Business Business Analytics & Intelligence |
Get a Reminder
Similar Courses
What people are saying
power bi
The review portion of the course was exactly what I was looking for to quickly provide a concise explanation of these concepts before moving on to what I was interested in (without having to do a full course that when into crazy detail on these) I anyways waited for this course for long and here it is...Going to be a great add on in my existing power bi skills.
Next course which i am waiting for is DBA Advanced SQL course...That is in my waitlist..... One of the best course that will absolutely take you to the master the DAX skills in Power BI.
What would make an "Advanced Power BI" Course even better is if they added the M Language section and examples to it.
There was almost nothing on M Language in any of their Power BI courses.
Hope Maven will make more advanced lectures about power BI (should have one about M) and I will definitely enroll all.
Good examples to learn DAX Great follow up to the "Up and Running with Power BI Desktop" course, perfect level of detail and extremely well presented.
This is a good follow up to "Up and Running with Power BI".
I learned so much about Power BI and DAX and can’t wait to start using it in my day-to-day work!
As an analytics professional I found this course to be an outstanding deep dive into more complex topics and examples within Power BI.
As usual other Power BI , Maven analytics course Loving this course so far and specifically looking forward to the table and filter function section.
It's my third Maven course, also took Power BI Desktop and Tableau Desktop, and I love how these guys teach!
Even if I just startet using Power BI I can see how helpful it is for my customers.
Read more
easy to understand
Takes one gradually through the DAX formatting & functions in an easy to understand way!
Awesome step by step dax lecture easy to understand I have been waiting for this course.
The instructor explained the concept with easy to understand videos and clear instructions.
I really understood the concepts Clear explaination / easy to understand / easily appliable to my job - Thank you so much !!
Read more
very good
Very good match with a lot of relevant examples and exercises.
I hope this will be like that until the end Well explained with very good real time examples.
Very applicable to building quality dashboards yes Very good course to learn advanced DAX.
Read more
next level
Clear and concise, quality course to bring one's DAX skillset to the next level Thanks, Aaron for putting together a very thoughtful and well presented course!
Corso semplice e intuitivo This course has allowed me to take my DAX to the next level.
Read more
dax skills
Exactly what I needed to improve my DAX skills.
aaron parry
Aaron Parry is making a very clear explanation in each and every aspect of the concept, which is very essential to understand.
Credits and acknowledgements to Aaron Parry.
Read more
`` up
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Power BI/Tableau developer $60k
(Bi $61k
BI Administrator $98k
BI Programmer $99k
BI Engineer, CS BI $106k
BI & Analytics $106k
Nuclear Power $110k
D&BI Developer $111k
ETL / BI $116k
IT BI Architect $122k
BI Architect 2 $140k
BI Consulting $156k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | 4.7★ based on 74 ratings |
---|---|
Length | 11.5 total hours |
Starts | On Demand (Start anytime) |
Cost | $12 |
From | Udemy |
Instructors | Maven Analytics, Aaron Parry |
Download Videos | Only via the Udemy mobile app |
Language | English |
Subjects | Business |
Tags | Business Business Analytics & Intelligence |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course