Mastering Data Modeling Fundamentals in Power BI

Learn how to create relationships, calculated columns measures and use DAX formulas in Power BI Data Modeling
Free tutorial
Rating: 4.0 out of 5 (72 ratings)
2,556 students
41min of on-demand video
English
English [Auto]

Introduction to Power BI
Introduction to interface and tools
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

Requirements

  • None: Students from any faculty can join and take advantage from this course

Description

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.


Who this course is for:

  • Beginners from any industry, Power BI developers, data visualization designers

Instructors

Online Instructor | Power BI Developer | Web Developer
Ameen Khan
  • 4.0 Instructor Rating
  • 72 Reviews
  • 2,556 Students
  • 1 Course

I am a Computer Engineer with experience of 10 years in the industry. I am an online instructor of WordPress and Microsoft Power BI. I am a data lover, Power BI developer, and data visualization expert.

My mission is to educate at least 1Million students to learn and understand the new technologies. And especially after taking my course, they can successfully apply for the jobs.

So come with me and help and support me with sharing my videos to educate students around the globe.

You can rate me 5stars so more and more people will see my videos and in this way you can also play a positive role in spreading knowledge.

**Happy Learning**

Ameen Khan
  • 4.0 Instructor Rating
  • 72 Reviews
  • 2,556 Students
  • 1 Course

Top companies trust Udemy

Get your team access to Udemy's top 16,000+ courses