Understanding Data Modeling in Power BI.

Data Modelling Data modelling involves creating a visual diagram of data to show how it can be organized, structered and analysed within a database. In Power BI, data modelling enables ease in report creation, accuracy in calculations and efficient performance. SQL JOINS SQL JOINS is used to combine data in multiple tables based on the related columns between them. They are important in relational database since it enables us to retrieve data with unified view that is mostly spread across multiple tables. INNER JOIN INNER JOIN is an SQL operation that enables combining rows from multiple tables with respect to a related column. LEFT JOIN LEFT JOIN retains rows from the left side of the table, and combines rows that are matching from the right side of the table. RIGHT JOIN RIGHT JOIN merges two tables by retaining data from the right ide of the table and only matching data from the left side of the table. FULL OUTER JOIN FULL OUTER JOIN merges two tables by retaining all the data from b