Microsoft Power BI Desktop: Advanced DAX for Data Analysis

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 ReviewReview the core DAX concepts you should already know, including evaluation context, filter flow, measures, etc. Course Project IntroIntroduce the Maven Roasters course project, and build the data model that we'll analyze in Power BI DesktopThe DAX EnginesUnderstand the DAX formula and storage engines, data types, VertiPaq encoding & compression methods, etc.