Data Modelling in Power BI: The Foundation Every Analyst Needs.

I started learning Power BI backwards. I jumped straight into building visuals, dragging fields onto a canvas, and then kept wondering why my numbers are wrong. Well, the reason is that I had completely skipped data modelling. Data modelling-is the invisible architecture behind every Power BI report. Here is what you need to understand: What is a Data Model? A data model is the structure that defines how your tables relate to each other. In Power BI,there is a tool called the Model View, where you connect tables using relationships. Its often depicted as lines that tell Power BI "this column in this table matches that column in that table." The most important concept in data modelling is the difference between two types of tables: Fact table-They contain measurements i.e. numbers that change over time e.g. sales amounts. Dimension table-They provide context i.e. the who, what, when and where e.g. Customer names, product categories, customer locations etc. Star Schema-It is a data model