Understanding Data Modeling in Power BI: Joins, Relationships and Schemas Explained

INTRODUCTION I'm currently learning Power BI and I keep hearing about data modeling. Honestly it sounded very complicated but when i researched and practiced, I realized it's just about organizing data in an organized manner. In this article I'll explain data modeling in a simple way. I'll cover joins, relationships, schemas and how do do them on power BI step by step. What is Data Modeling? Data modeling is simply arranging your data into tables and connecting them so that Power BI can analyze them properly. SQL Joins Explained Joins help in combining data from different tables. They include inner join, left join, right join, full outer, left anti and right anti join. Let's say for example we have this sample data: Customers Table ID Name 1 John 2 Alice Orders Table Order ID Customer ID 001 1 002 2 003 3 Inner Join The inner join returns only rows that have matching values in both tables. Therefore using our data, inner join will only show customers who have data that is Customer ID 1