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

Data Modelling is the most important aspect of a Business Intelligence Implementation. Without a proper data model, the business will not get a true picture of the data. Data Modelling is a process of organizing the data elements and defining how they relate with each other. A good data model adheres to the business rules and assists in quick decision making. Combining Queries Using Joins Power BI Supports combining queries using the merge queries option in Query Editor. It supports all the different types of SQL Joins. Joins are used to display the data from multiple tables or when merging two tables based on a join condition. These are the various types of joins present in Power BI Inner Join: Only the matching rows between the two tables are returned, else it returns zero rows. Left Join:It returns all the rows from the first table and only the matching rows from the second table. Right Join: Right join is opposite to the left join. It returns all the rows from the second table and