Overview
Unlock the full potential of Power BI by learning to use Data Analysis Expressions (DAX) in this dynamic two-day live online course. Designed for business users who are familiar with Power BI, this course will elevate your ability to create sophisticated analytic solutions.
The course provides a balanced mix of theory and hands-on practice, focusing on solving common business problems through DAX. You will explore the creation of calculated columns, measures, and tables, and gain skills in visualizing and troubleshooting your custom DAX code.
Software Utilized:
A Windows 10 PC equipped with Power BI Desktop and DAX Studio.
Target Audience:
Business users ready to leverage the powerful DAX language for flexible and dynamic data analysis.
Prerequisites:
Prior experience with Power BI is recommended to maximize the benefit of the course labs.
Topics Covered:
- DAX functions: date and time, filter, information, logical, math and statistical, table manipulation, text, and time intelligence.
- DAX basics: syntax, creating calculated columns/measures/tables, evaluation context, and performance testing.
- Advanced calculations: handling errors, iterator functions, and context modifications.
- Time-specific calculations: date tables, custom periods, year-over-year changes, and moving averages.
- User experience improvements: visibility controls, what-if parameters, banding, and row-level security using DAX.
This course is provided by CourseHorse and falls under the categories of Data Analysis Courses, Business Intelligence Courses, DAX (Data Analysis Expressions) Courses, Data Modeling Courses, and Calculated Columns Courses.
Syllabus
Taught by
Tags
