Data Loading & Visualization in Power BI: Data Modeling
“Power BI s data modeling capabilities empower users to craft sophisticated data relationships calculations and hierarchies. With the ability to establish meaningful connections between different data tables through relationships users can seamlessly integrate disparate datasets and facilitate the creation of dynamic calculated columns and measures for in-depth analysis with Data Analysis Expressions (DAX). Hierarchies further enhance exploration by enabling intuitive drilldowns in your data.
In this course you will explore calculated tables and perform operations such as UNION INTERSECT and NATURALINNERJOIN to craft new tables. You will work with calculated columns and create and use calculated measures. Next youÆll learn how to create and model relationships between your tables explore cardinality and uncover the concept of cross-filter direction that influences the flow of filters across relationships. Finally you ll explore hierarchies in Power BI working with both default and custom hierarchies.”