This course is designed to simplify DAX (Data Analysis eXpression) through visual calculations. It also offers students a wealth of tips and techniques to enhance their Power BI skills.
Participants will learn how to enable and utilize visual calculations in Power BI, explore the interface, and leverage templates/functions to streamline their data analysis processes.
The course also covers the integration of visual calculations with custom visualizations, Direct Query, and calculation groups, while addressing conditional formatting and general limitations.
With a focus on making DAX easier and more accessible, this course promises to expedite the data modeling process, making it an essential learning path for those looking to improve their Power BI proficiency.
Overview
COURSE DIFFICULTY
COURSE DURATION
1h 9m
Skills Learned
After completing this online training course, students will be able to:
Create DAX measures for business calculations
Build calculated columns for data enrichment
BI Developers, Data Analysts
None
01. Class Files
02. Introduction to Visual Calculations
03. What are Visual Calculations?
04. How to enable Visual Calculations
05. Anatomy of Visual Calculations
06. Introduction to Templates
07. YTD, QTD, MTD
08. Moving Sum Demonstration
09. IF Statements
10. Power BI Service
11. Custom Visuals
12. Direct Query and Calculation Groups
13. Conclusion
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Create DAX measures for business calculations
Build calculated columns for data enrichment
WHO SHOULD ATTEND
BI Developers, Data Analysts
PREREQUISITES
None
COURSE OUTLINE
01. Class Files
02. Introduction to Visual Calculations
03. What are Visual Calculations?
04. How to enable Visual Calculations
05. Anatomy of Visual Calculations
06. Introduction to Templates
07. YTD, QTD, MTD
08. Moving Sum Demonstration
09. IF Statements
10. Power BI Service
11. Custom Visuals
12. Direct Query and Calculation Groups
13. Conclusion
