Data Loading & Visualization in Power BI: Data Modeling

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. 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.