Microsoft Power BI Desktop: Advanced DAX for Data Analysis
Microsoft Power BI Desktop: Advanced DAX for Data Analysis, available at $109.99, has an average rating of 4.64, with 145 lectures, 10 quizzes, based on 12005 reviews, and has 69584 subscribers.
You will learn about Master Data Analysis Expressions (DAX) for Power BI Desktop Analyze real-world projects & business intelligence use cases Learn the same tools used by top data analytics & business intelligence professionals Test your skills with hands-on demos & assignments (with step-by-step solutions) This course is ideal for individuals who are Aspiring data professionals looking to master the #1 business intelligence tool on the market or Analytics or BI professionals looking to build expert-level DAX + Power BI skills or Power BI users tasked with solving unique and complex data analysis use cases or Students looking for a comprehensive, engaging, and highly interactive approach to training It is particularly useful for Aspiring data professionals looking to master the #1 business intelligence tool on the market or Analytics or BI professionals looking to build expert-level DAX + Power BI skills or Power BI users tasked with solving unique and complex data analysis use cases or Students looking for a comprehensive, engaging, and highly interactive approach to training.
Enroll now: Microsoft Power BI Desktop: Advanced DAX for Data Analysis
Summary
Title: Microsoft Power BI Desktop: Advanced DAX for Data Analysis
Price: $109.99
Average Rating: 4.64
Number of Lectures: 145
Number of Quizzes: 10
Number of Published Lectures: 145
Number of Published Quizzes: 10
Number of Curriculum Items: 155
Number of Published Curriculum Objects: 155
Original Price: $129.99
Quality Status: approved
Status: Live
What You Will 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 data analytics & business intelligence professionals
- Test your skills with hands-on demos & assignments (with step-by-step solutions)
Who Should Attend
- 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 data analysis use cases
- Students looking for a comprehensive, engaging, and highly interactive approach to training
Target Audiences
- 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 data analysis use cases
- Students looking for a comprehensive, engaging, and highly interactive approach to training
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 data analysis and 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 analytics 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 CALCULATE
-
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.)
-
-
Relationship Functions
-
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 our full course library? Search “Maven Analytics” to browse our full collection of Excel, Power BI, SQL, Tableau, Python, Alteryx & Machine Learningcourses!
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 Curriculum
Chapter 1: Getting Started
Lecture 1: Course Structure & Outline
Lecture 2: READ ME: Important Notes for New Students
Lecture 3: DOWNLOAD: Course Resources
Lecture 4: Setting Expectations
Lecture 5: Helpful Resources
Chapter 2: Prerequisite Skills Review
Lecture 1: Introduction
Lecture 2: Data Modeling Fundamentals
Lecture 3: Basic DAX Review
Chapter 3: Introducing the Course Project
Lecture 1: Introducing the Course Project
Lecture 2: NOTE: Power BI Options & Settings
Lecture 3: Maven Roasters Data Model Setup
Lecture 4: ASSIGNMENT: Getting Familiar with the Data Model
Chapter 4: The DAX Engines
Lecture 1: Introduction
Lecture 2: DAX Formula & Storage Engines
Lecture 3: DAX Query Evaluation In Depth
Lecture 4: Data & Storage Types
Lecture 5: VertiPaq Columnar Data Structure
Lecture 6: VertiPaq Compression & Encoding
Lecture 7: Value Encoding
Lecture 8: Hash Encoding
Lecture 9: Run Length Encoding
Lecture 10: VertiPaq Relationships
Lecture 11: Summary: DAX Engines
Chapter 5: Tips & Best Practices
Lecture 1: Introduction
Lecture 2: DAX Shortcuts
Lecture 3: Formatting Best Practices
Lecture 4: DAX Evaluation Order
Lecture 5: Commenting Your Code
Lecture 6: PRO TIP: Dedicated Measure Table
Lecture 7: Error Handling
Lecture 8: Creating & Using DAX Variables
Lecture 9: Variable Evaluation Order
Lecture 10: PRO TIP: Using Variables to Test & Debug DAX
Chapter 6: Scalar Functions
Lecture 1: Introduction
Lecture 2: Common Scalar Functions
Lecture 3: Aggregation Functions
Lecture 4: PRO TIP: SUM & SUMX
Lecture 5: Rounding Functions
Lecture 6: ASSIGNMENT: Rounding Functions
Lecture 7: SOLUTION: Rounding Functions
Lecture 8: Information Functions
Lecture 9: Conversion Functions
Lecture 10: ASSIGNMENT: Conversion Functions
Lecture 11: SOLUTION: Conversion Functions
Lecture 12: Logical Functions: SWITCH
Lecture 13: Logical Functions: COALESCE
Lecture 14: ASSIGNMENT: Logical Functions
Lecture 15: SOLUTION: Logical Functions
Chapter 7: Advanced CALCULATE
Lecture 1: Introduction
Lecture 2: Expanded Tables
Lecture 3: Context Transition
Lecture 4: Evaluation Order
Lecture 5: CALCULATE Modifiers
Lecture 6: REMOVEFILTERS
Lecture 7: KEEPFILTERS
Lecture 8: ASSIGNMENT: Advanced CALCULATE
Lecture 9: SOLUTION: Advanced CALCULATE
Lecture 10: PRO TIP: Common CALCULATE Patterns
Chapter 8: Table & Filter Functions
Lecture 1: Introduction
Lecture 2: Common Table & Filter Functions
Lecture 3: Review: Calculated Tables
Lecture 4: DISTINCT
Lecture 5: VALUES
Lecture 6: ASSIGNMENT: VALUES & DISTINCT
Lecture 7: SOLUTION: VALUES & DISTINCT
Lecture 8: SELECTEDVALUE
Lecture 9: ALLEXCEPT
Lecture 10: ASSIGNMENT: ALLEXCEPT
Lecture 11: SOLUTION: ALLEXCEPT
Lecture 12: ALLSELECTED
Lecture 13: ASSIGNMENT: ALLSELECTED
Lecture 14: SOLUTION: ALLSELECTED
Lecture 15: SELECTCOLUMNS
Lecture 16: ADDCOLUMNS
Lecture 17: SUMMARIZE
Lecture 18: ASSIGNMENT: SUMMARIZE
Lecture 19: SOLUTION: SUMMARIZE
Lecture 20: Generating New Data
Lecture 21: ROW
Lecture 22: DATATABLE
Lecture 23: GENERATESERIES
Lecture 24: The Table Constructor
Lecture 25: ASSIGNMENT: Generating Data
Lecture 26: SOLUTION: Generating Data
Chapter 9: Calculated Table Joins
Lecture 1: Introduction
Instructors
-
Maven Analytics
Empowering everyday people with life-changing data skills -
Aaron Parry
Professional Business Intelligence Trainer & Consultant
Rating Distribution
- 1 stars: 59 votes
- 2 stars: 85 votes
- 3 stars: 656 votes
- 4 stars: 3633 votes
- 5 stars: 7572 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
- Digital Marketing Foundation Course
- Google Shopping Ads Digital Marketing Course
- Multi Cloud Infrastructure for beginners
- Master Lead Generation: Grow Subscribers & Sales with Popups
- Complete Copywriting System : write to sell with ease
- Product Positioning Masterclass: Unlock Market Traction
- How to Promote Your Webinar and Get More Attendees?
- Digital Marketing Courses
- Create music with Artificial Intelligence in this new market
- Create CONVERTING UGC Content So Brands Will Pay You More
- Podcast: The top 8 ways to monetize by Podcasting
- TikTok Marketing Mastery: Learn to Grow & Go Viral
- Free Digital Marketing Basics Course in Hindi
- MailChimp Free Mailing Lists: MailChimp Email Marketing
- Automate Digital Marketing & Social Media with Generative AI
- Google Ads MasterClass – All Advanced Features
- Online Course Creator: Create & Sell Online Courses Today!
- Introduction to SEO – Basic Principles of SEO
- Affiliate Marketing For Beginners: Go From Novice To Pro
- Effective Website Planning Made Simple