Mastering Data Modeling Fundamentals in Power BI

Connect Power BI to multiple data sources to create reports. Define the relationship between your data sources.

Learning objectives

In this module, you will:

• Create relationships between your data sources

• Create a new field with calculated columns

• Optimize data by hiding fields and sorting visualization data

• Create a measure to perform calculations on your data

• Use a calculated table to create a relationship between two tables

• Format time-based data so that you can drill down for more details

This module is part of these learning paths

• Create and use analytics reports with Power BI

• Introduction to modeling your data

• How to manage your data relationships

• Create calculated columns

• Optimize data models

• Create measures

• Create calculated tables

• Explore time-based data

• Check your knowledge

• Summary

One of Power BI’s strengths is that you don’t need to flatten your data into a single table. Instead, you can use multiple tables from multiple sources and define the relationship between them.

How to manage your data relationships

The Model view in Power BI Desktop allows you to visually set the relationship between tables or elements. A relationship is where two or more tables are linked together because they contain related data. This enables users to run queries for related data across multiple tables. Use the Model view to see a diagrammatic view of your data.

Rating Distribution

• 1 stars: 5 votes
• 2 stars: 4 votes
• 3 stars: 21 votes
• 4 stars: 26 votes
• 5 stars: 30 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!