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

1.What is data modeling? Data modeling is the process of structuring and organizing Data to make is easily accessible for reporting in power BI. It involves connecting tables, defining relationships, cleaning and shaping data. Organizes data into a structured format. 2.SQL Joins in Power BI (power query) Powe BI enables SQL like joins via merge queries to create a physical table. These are essential for data cleaning. Combine tables based on specific requirements. INNER JOIN: Keeps only rows that have matching values in both tables. Example: joining employee table with department table. Only employees assigned to a valid department are returned. LEFT JOIN: Keeps all rows from the left table and matches from the right. No match it returns null. Example; Joining sales table with product table. All sales products are kept and product details added and id a sale was made for a product not in the product table, the product name will be null. RIGHT JOIN: Keeps all rows from the right table a