FREE Course
Self-paced course
Self-paced course
Advanced DAX for Power BI
Advanced DAX for Power BI
Course Description
If you’re looking to take your Power BI skills to the next level, mastering Data Analysis Expressions (DAX) is a must. In this hands-on, project-based course, you’ll apply DAX to tackle some of the toughest real-world business intelligence challenges.
You’ll step into the role of Lead Business Intelligence Analyst for Maven Roasters, a small-batch coffee chain based in New York City. Your mission? Use Power BI and DAX to uncover insights about product inventory, repeat customers, store performance, and more.
We’ll begin with a quick review of key DAX foundations — including evaluation context, filter flow, and basic measures — then go behind the scenes to explore how the DAX formula and storage engines work, covering topics like query evaluation, columnar storage, and VertiPaq compression.
Next, you’ll pick up pro-level tips and best practices for writing efficient, readable DAX, including the use of variables, comments, formatting, and error handling. From there we’ll go deep into scalar functions, iterators, filter functions, advanced time intelligence, relationship functions, calculated table joins, and beyond.
Finally, we’ll wrap up with a preview of performance tuning and query optimization using DAX Studio and Power BI’s Performance Analyzer tool.
If you’re ready to build expert-level data analysis skills with DAX and Power BI, this is the course for you.
Course Description
If you’re looking to take your Power BI skills to the next level, mastering Data Analysis Expressions (DAX) is a must. In this hands-on, project-based course, you’ll apply DAX to tackle some of the toughest real-world business intelligence challenges.
You’ll step into the role of Lead Business Intelligence Analyst for Maven Roasters, a small-batch coffee chain based in New York City. Your mission? Use Power BI and DAX to uncover insights about product inventory, repeat customers, store performance, and more.
We’ll begin with a quick review of key DAX foundations — including evaluation context, filter flow, and basic measures — then go behind the scenes to explore how the DAX formula and storage engines work, covering topics like query evaluation, columnar storage, and VertiPaq compression.
Next, you’ll pick up pro-level tips and best practices for writing efficient, readable DAX, including the use of variables, comments, formatting, and error handling. From there we’ll go deep into scalar functions, iterators, filter functions, advanced time intelligence, relationship functions, calculated table joins, and beyond.
Finally, we’ll wrap up with a preview of performance tuning and query optimization using DAX Studio and Power BI’s Performance Analyzer tool.
If you’re ready to build expert-level data analysis skills with DAX and Power BI, this is the course for you.
Course Content
19 course hours
20 assignments & solutions
10 quizzes
2 skills assessments
19 CPE credits
Who should take this course
Analytics or BI professionals looking to build expert-level DAX skills
Power BI users tasked with solving unique and complex analytics use cases
Students who are comfortable with DAX and Power BI and want to dig deeper
Meet your instructors
Aaron Parry
Partner & CCO
Aaron is a professional analytics consultant and Microsoft 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.
Featured review
"This is a very complete course and contains many advanced techniques in Power BI. Aaron went the extra mile to bring in topics that are not usually covered in other DAX-focused courses. Lots of tips and best practices were included and they really helped deepen my skills!"
Siow C.
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements
Advanced DAX for Power BI
Advanced DAX for Power BI
CPE Accreditation
CPE Credits:
19
Field of Study:
Information Technology
Delivery Method:
QAS Self Study
Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.
*Last Updated: May 25, 2023
Course Description
If you’re looking to take your Power BI skills to the next level, mastering Data Analysis Expressions (DAX) is a must. In this hands-on, project-based course, you’ll apply DAX to tackle some of the toughest real-world business intelligence challenges.
You’ll step into the role of Lead Business Intelligence Analyst for Maven Roasters, a small-batch coffee chain based in New York City. Your mission? Use Power BI and DAX to uncover insights about product inventory, repeat customers, store performance, and more.
We’ll begin with a quick review of key DAX foundations — including evaluation context, filter flow, and basic measures — then go behind the scenes to explore how the DAX formula and storage engines work, covering topics like query evaluation, columnar storage, and VertiPaq compression.
Next, you’ll pick up pro-level tips and best practices for writing efficient, readable DAX, including the use of variables, comments, formatting, and error handling. From there we’ll go deep into scalar functions, iterators, filter functions, advanced time intelligence, relationship functions, calculated table joins, and beyond.
Finally, we’ll wrap up with a preview of performance tuning and query optimization using DAX Studio and Power BI’s Performance Analyzer tool.
If you’re ready to build expert-level data analysis skills with DAX and Power BI, this is the course for you.
Course Description
If you’re looking to take your Power BI skills to the next level, mastering Data Analysis Expressions (DAX) is a must. In this hands-on, project-based course, you’ll apply DAX to tackle some of the toughest real-world business intelligence challenges.
You’ll step into the role of Lead Business Intelligence Analyst for Maven Roasters, a small-batch coffee chain based in New York City. Your mission? Use Power BI and DAX to uncover insights about product inventory, repeat customers, store performance, and more.
We’ll begin with a quick review of key DAX foundations — including evaluation context, filter flow, and basic measures — then go behind the scenes to explore how the DAX formula and storage engines work, covering topics like query evaluation, columnar storage, and VertiPaq compression.
Next, you’ll pick up pro-level tips and best practices for writing efficient, readable DAX, including the use of variables, comments, formatting, and error handling. From there we’ll go deep into scalar functions, iterators, filter functions, advanced time intelligence, relationship functions, calculated table joins, and beyond.
Finally, we’ll wrap up with a preview of performance tuning and query optimization using DAX Studio and Power BI’s Performance Analyzer tool.
If you’re ready to build expert-level data analysis skills with DAX and Power BI, this is the course for you.
Curriculum
Meet your instructors
Aaron Parry
Partner & CCO
Aaron is a professional analytics consultant and Microsoft 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.
Student reviews
This is a very complete course and contains many advanced techniques in Power BI. Aaron went the extra mile to bring in topics that are not usually covered in other DAX-focused courses. Lots of tips and best practices were included and they really helped deepen my skills!
Siow C.
Amazing well put together course!!! I would highly recommend this course to anyone who has spent some time working with DAX but is looking to progress their skills and understanding to the next level. The instructor does a fantastic job of walking you through lessons and a structured and methodical way so you are continuously building your knowledge and understanding after each lesson.
Mark Cunningham
One of the best course content i have came across. Thanks maven analytics.
Deeksha Singh
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements
Advanced DAX for Power BI
Advanced DAX for Power BI
CPE Accreditation
CPE Credits:
19
Field of Study:
Information Technology
Delivery Method:
QAS Self Study
Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.
*Last Updated: May 25, 2023
More courses you may like
FOR INDIVIDUALS
Master data & AI skills
Build data & AI skills to launch or accelerate your career (start for free, no credit card required).
FOR COMPANIES & TEAMS
Transform your workforce
Assess your team's data & AI skills and follow personalized learning plans to close the gaps.
FOR INDIVIDUALS
Master data & AI skills
Build data & AI skills to launch or accelerate your career (start for free, no credit card required).
FOR COMPANIES & TEAMS
Transform your workforce
Assess your team's data & AI skills and follow personalized learning plans to close the gaps.
FOR INDIVIDUALS
Master data & AI skills
Build data & AI skills to launch or accelerate your career (start for free, no credit card required).
FOR COMPANIES & TEAMS
Transform your workforce
Assess your team's data & AI skills and follow personalized learning plans to close the gaps.
Empowering everyday people with life-changing data skills.
DISCOVER
Empowering everyday people with life-changing data skills.
DISCOVER
Empowering everyday people with life-changing data skills.
DISCOVER