PL-300: Advanced Modeling Technique in Power BI
Microsoft Power BI
| Intermediate
- 15 videos | 1h 56m 55s
- Includes Assessment
- Earns a Badge
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 PL-300: Analyzing Data with Microsoft Power BI certification exam.
WHAT YOU WILL LEARN
-
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
IN THIS COURSE
-
3m 6s
-
9m 53s
-
3. Auto-detecting Relationships9m 14s
-
4. Using the LOOKUPVALUE Function9m 42s
-
5. Applying Bi-directional Cross-filtering11m 13s
-
6. Setting the Cardinality of Relationships4m 45s
-
7. Creating a Geographical Hierarchy9m 28s
-
8. Using Geographical Hierarchies5m 54s
-
9. Changing the Default Aggregation7m 22s
-
10. Grouping and Hiding Fields8m 24s
-
11. Using the Auto Date/Time Feature8m 21s
-
12. Setting up Entities for Row-level Security8m 25s
-
13. Implementing Row-level Security10m 57s
-
14. Validating Row-level Security7m 21s
-
15. Course Summary2m 52s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
