# UNDERSTANDING DATA MODELLING IN POWER BI

Introduction Power BI is a business analytic platform that transforms raw data into actionable insights through visualizations and reports that helps users to analyze data, identify trends securely across organizations to make data-driven decisions. Data modelling is the process to connect, structure, optimize data tables to work efficiently together. Concepts to Understand Joins Joins are performed in Power Query where you combine two columns by selecting the first and the second table and join them by clicking on the headers. Also ensure they have same data type for accurate matching. Relationships Relationships define how table connect. These are, One-to-Many (Most common) Many-to-One Many-to- Many (Used carefully) Example: One customer- Many Sales Schemas Schemas refers to the way your data is structured either in facts tables or dimensions and organized in the data model. One Central fact table Multiple surrounding dimension tables Power BI Relationships Cardinality Cardinality is