Power BI Data Model Design: Advanced Modeling Technique

Microsoft Power BI 2.96    |    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 DA-100: 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

  • Playable
    1. 
    Course Overview
    3m 6s
    UP NEXT
  • Playable
    2. 
    Exploring and Loading a Sales Dataset
    9m 53s
  • Locked
    3. 
    Auto-detecting Relationships
    9m 14s
  • Locked
    4. 
    Using the LOOKUPVALUE Function
    9m 42s
  • Locked
    5. 
    Applying Bi-directional Cross-filtering
    11m 13s
  • Locked
    6. 
    Setting the Cardinality of Relationships
    4m 45s
  • Locked
    7. 
    Creating a Geographical Hierarchy
    9m 28s
  • Locked
    8. 
    Using Geographical Hierarchies
    5m 54s
  • Locked
    9. 
    Changing the Default Aggregation
    7m 22s
  • Locked
    10. 
    Grouping and Hiding Fields
    8m 24s
  • Locked
    11. 
    Using the Auto Date/Time Feature
    8m 21s
  • Locked
    12. 
    Setting up Entities for Row-level Security
    8m 25s
  • Locked
    13. 
    Implementing Row-level Security
    10m 57s
  • Locked
    14. 
    Validating Row-level Security
    7m 21s
  • Locked
    15. 
    Course Summary
    2m 52s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.