Data Loading & Visualization in Power BI: Data Modeling

Power BI 2.12    |    Intermediate
  • 18 videos | 2h 1m 33s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
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.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Load data for calculated tables
    Create calculated tables using intersect
    Create calculated tables using naturalinnerjoin
    Create calculated tables using union
    Create calculated columns
    Create multiple calculated columns in a table
    Load data for data modeling
    Set up a one-to-one relationship
  • Set up a one-to-many relationship
    Set up a many-to-many relationship
    Configure many-to-many relationship's cross-filter direction
    Create a calculated measure
    Write a dax formula to create a calculated measure
    Read data with the default date hierarchy
    Use time intelligence and the date hierarchy
    Create a map visualization
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 2m 22s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 5m 57s
    During this video, you will learn how to load data for calculated tables. FREE ACCESS
  • Locked
    3.  Creating Calculated Tables Using INTERSECT
    6m 26s
    In this video, find out how to create calculated tables using INTERSECT. FREE ACCESS
  • Locked
    4.  Creating Calculated Tables Using NATURALINNERJOIN
    9m 58s
    Learn how to create calculated tables using NATURALINNERJOIN. FREE ACCESS
  • Locked
    5.  Creating Calculated Tables Using UNION
    5m 36s
    In this video, you will learn how to create calculated tables using UNION. FREE ACCESS
  • Locked
    6.  Creating Calculated Columns
    5m 30s
    Find out how to create calculated columns. FREE ACCESS
  • Locked
    7.  Creating Multiple Calculated Columns in a Table
    7m 2s
    In this video, learn how to create multiple calculated columns in a table. FREE ACCESS
  • Locked
    8.  Loading Data for Data Modeling Using Relationships
    7m 47s
    During this video, discover how to load data for data modeling. FREE ACCESS
  • Locked
    9.  Setting Up One-to-One Relationships between Tables
    6m 16s
    In this video, discover how to set up a one-to-one relationship. FREE ACCESS
  • Locked
    10.  Setting Up One-to-Many Relationships and the Cross-filter Direction
    8m 55s
    Discover how to set up a one-to-many relationship. FREE ACCESS
  • Locked
    11.  Configuring Many-to-Many Relationships
    5m 8s
    During this video, you will learn how to set up a many-to-many relationship. FREE ACCESS
  • Locked
    12.  Setting Up Many-to-Many Relationships and Cross-filter Direction
    6m 28s
    In this video, find out how to configure many-to-many relationship's cross-filter direction. FREE ACCESS
  • Locked
    13.  Displaying Star Ratings Using Calculated Measures
    8m 36s
    Learn how to create a calculated measure. FREE ACCESS
  • Locked
    14.  Creating Calculated Measures Using DAX Formulas
    6m 30s
    In this video, you will learn how to write a DAX formula to create a calculated measure. FREE ACCESS
  • Locked
    15.  Understanding the Default Date Hierarchy
    5m 43s
    Find out how to read data with the default date hierarchy. FREE ACCESS
  • Locked
    16.  Using Time Intelligence and Date Hierarchy Drill Down
    11m 11s
    In this video, learn how to use time intelligence and the date hierarchy. FREE ACCESS
  • Locked
    17.  Creating Custom Hierarchies and Using Map Visualizations
    9m 54s
    During this video, discover how to create a map visualization. FREE ACCESS
  • Locked
    18.  Course Summary
    2m 15s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

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.

YOU MIGHT ALSO LIKE

Course PL-300: Loading & Transforming Data in Power BI
Rating 4.7 of 830 users Rating 4.7 of 830 users (830)
Course Data Loading & Visualization in Power BI: Advanced Visualizations
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Course PL-300: Advanced Modeling Technique in Power BI
Rating 4.5 of 100 users Rating 4.5 of 100 users (100)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Performing Joins Using Merge Queries in Power BI
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Course Data Loading & Visualization in Power BI: Loading Data from Databases
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)
Course Getting Started with Power Query in Power BI
Rating 4.6 of 14 users Rating 4.6 of 14 users (14)