Use DAX in Power BI Desktop

Overview

Unlock the power of DAX in Power BI Desktop with this comprehensive course from Microsoft Learn. Perfect for those interested in data analysis, Microsoft Power BI, and mastering Data Analysis Expressions (DAX), this course covers everything from model structure and design principles to advanced DAX formulas and functions. Enhance your Power BI Desktop models by learning:

• The essentials of Power BI Desktop model structure, star schema design, analytics queries, and report visual configuration.
• How to craft calculated tables, columns, and measures using DAX formulas. Plus, delve into DAX's functions, data types, and variables.
• The application of row context in calculating column formulas and when to prefer calculated columns over Power Query computed columns.
• Creating simple to complex measures, understanding the nuances between calculated columns and measures, and the choice between implicit and explicit measures.
• The capabilities of iterator functions in DAX for custom summarizations, ranking, and concatenation.
• Mastering filter context, manipulating it with the CALCULATE function for dynamic calculations, and understanding context transitions.
• Adding time intelligence to your models for powerful time-based calculations such as year-to-date and year-over-year growth.

This course is ideal for those looking to deepen their understanding of DAX within Power BI Desktop, offering practical knowledge for both beginners and advanced users. Dive into the rich features of DAX and elevate your data analysis skills with Microsoft Learn.

Categories: Data Analysis Courses, Microsoft Power BI Courses, DAX (Data Analysis Expressions) Courses.

Syllabus

Taught by

Tags

united states