Understanding Data modeling in power bi,Joins,relationships and schemas explained.

introduction When i first heard about power BI,i thought it's all about making charts and dashboards.I came to realize even the most beautiful visuals can produce wrong numbers when it's not well organised and most beginners start questioning themselves why their totals are not adding up correctly. Data modeling Data modeling is organising and structuring your data so that it can be efficient and accurate for power BI to easily analyse it. In simple terms,modeling is what separates a report that looks good from what is actually correct.You can think of it like a building plan.You cannot skip the plan and expect the building to go well.If you skip data modeling,you will get inaccurate report. Joins Joins in SQL are used to join tables with common columns. 1.inner join The inner join joins common columns in two tables.It ignores data that does not match.Example: select customer_name,age, from customer, inner join orders , oncustomers.customer_id=orders.customer_id; 2.outer join Outer joi