Advanced DAX for Microsoft Power BI Desktop
What you'll learn
- Master Data Analysis Expressions (DAX) for Power BI Desktop
- Analyze real-world projects & business intelligence use cases
- Learn the same tools used by top analytics & business intelligence professionals
- Test your skills with hands-on demos & assignments (with step-by-step solutions)
- Microsoft Power BI Desktop (free download)
- This course is designed for PC/Windows users (currently not available for Mac)
- Prior experience with DAX and Power BI is strongly encouraged
- Recommend completing our "Up & Running with Power BI Desktop" course before this one
For users looking to take their Power BI skills to the next level, mastering Data Analysis Expressions (DAX) is a MUST. 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
Explore common DAX scalar functions, including rounding, information, conversion, and logical functions
Review CALCULATE modifiers, context transition, interactions with tables, etc.
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 (UNION, EXCEPT, INTERSECT, etc.)
Explore expanded tables, physical & virtual relationships, common relationship functions, etc.
Iterator ("X") Functions
Explore iterator cardinality, nested iterators, context transition, RANKX, DAX calculation granularity, etc.
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!
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!"
"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."
"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%!"
"Where can I leave a 6 star rating?"
Who this course is for:
- Aspiring data professionals looking to master the #1 business intelligence tool on the market
- Analytics or BI professionals looking to build expert-level DAX + Power BI skills
- Power BI users tasked with solving unique and complex analytics use cases
- Students looking for a comprehensive, engaging, and highly interactive approach to training
Maven Analytics helps individuals and teams build expert-level analytics & business intelligence skills.
We've helped more than 1,000,000 students around the world build job-ready skills, master sought-after tools like Excel, SQL, Power BI, Tableau & Python, and build the foundation for a successful career in data.
At Maven Analytics, we empower everyday people to change the world with data.
Aaron is a professional analytics consultant and Power BI expert, with 10+ years working in business intelligence and marketing analytics.
He's an instructor, coach and mentor for aspiring analysts, and has deep experience helping companies develop and implement full-stack BI solutions.
Aaron is the Head of Student Success at Maven Analytics, a leader in analytics education, whose mission is to empower everyday people to change the world with data.