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

DATA MODELLING This is a detailed process that involves creating a visual representation of data and its relationships. TYPES OF TABLES FACT TABLE It contains quantitative data for analysis. DIMENSIONS TABLE Provides context to fact table data. STAR SCHEMA It contains a single fact table in the center that connects to multiple other dimensiontables. SNOW FLAKE Is an extension of a star schema where dimension tables are broken down into subdimensions. FLAT TABLE A table that displays data in a simple, two-dimensional format without any relationships to other tables. SQL JOINS IN POWER BI INNER JOIN: Returns rows present in both tables if there is a match. LEFT JOIN: Returns all rows present in the left table and matching rows from the right table. RIGHT JOIN: Returns matching rows from the left table and all rows present in the SQL right table. FULL OUTER: Returns all rows present in both right and left tables. LEFT ANTI: Returns rows from the left table that don't have matches in the r