IT Skills     Data and Databases     Data Visualization     Design Data Models in Power BI

---

A well-designed data model eliminates irrelevant and uninterpretable analyses and ensures insightful and well-performing reports. Use this course to step up your data analysis using Power BI's advanced data modeling features.
Begin by loading a sales dataset containing a large fact table and multiple dimension tables and modeling it into a snowflake schema. See how Power BI automatically detects relationships. Then, learn how to apply detailed configurations of relationships, from setting the right cardinality to applying bi-directional cross-filtering.
Next, explicitly define a hierarchy in your data to model a set of geographical values. Learn further detailed configurations, such as setting a default aggregation operation on fields and hiding specific ones from the reports view. Lastly, learn how to implement row-level security.
When you're done, you'll be able to use Power BI's advanced data modeling capabilities. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.

---

---

Objectives

PL-300: Advanced Modeling Technique in Power BI discover the key concepts covered in this course load fact and dimension tables containing sales data for analysis recognize the types of relationships that Power BI can detect and apply automatically when data is loaded search for a value in a related table without establishing a relationship use bi-directional cross-filtering to perform an aggregation that is not possible with single-direction cross-filtering identify the types of cardinalities that can be applied to different types of relationships define a hierarchy of fields containing geographical information apply a geographical hierarchy in a Power BI visualization set the default aggregation on a field to compute the average combine related fields across tables into a single unit and configure them together recognize the benefits and limitations of Power BI's auto date/time feature create a table containing user information as a prelude to setting up row-level security set up permissions so that users can only view their own information when analyzing data with Power BI navigate over reports as different users in Power BI Desktop in order to ensure the correct implementation of row-level security summarize the key concepts covered in this course