Build expert-level BI skills and solve real-world exercises using Data Analysis Expressions (DAX).

In this hands-on and 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.

Throughout the course, you'll play the role of Business Intelligence Analyst for Maven Roasters, a small-batch coffee chain based in New York City.

Your goal is to use Power BI Desktop and DAX to answer key questions and deliver data-driven insights for the business, by analyzing product inventory, repeat customers, store-level performance, and more.

We'll start by quickly reviewing prerequisite topics, 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 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.

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

WHAT ARE THE COURSE REQUIREMENTS?

• Students are strongly encouraged to complete our intro-level Power BI Desktop course before attempting this one
• We'll be using Power BI Desktop throughout the course (free download)