Created by: Paul Pitcher
Creation Date: Aug 16, 2025
Updated Date: Oct 14, 2025

Data Model

(Also called: ) (Related Topic: )
A Data model used in a databases, power BI, and other tools allows us to shows relationships between tables. I have been using these for over 20 years. This is helpful so that others, and other systems, can interact with your data and get the same/similar results. For example if I have 2 tables, one with a list of states, and then a second table with a list of employees, I can describe the relationship between the two tables so that additional information can be understood from the data. I won't go into the details of how a Data Model is different from a Semantic Models but the short version is that as of 2025 I'm not going to have to worry about a Semantic Models for several years too come. Here is a great article explaining the difference between the two. All of the data at TMO that I work with is in structured tables in a database. As an example I'm not working with blob data. In Power BI Microsoft now calls "Data Model" "Semantic Models" but that is just because they are looking down the road of where things are going and trying to get people to use Fabric. So if I see "Semantic Models" in Power BI I don't need to get to concerned because knowing about a traditional "Data Model" is going to be enough (I believe) to pass the PL-300 exam, and to be able to do my TMO job.
Recommended book .