Now that we're happy with our data, we have done all of the steps involved. We've loaded it here, we've done our transformations, it's looking good. So we're going to be going to home and select close and apply. So once we do that, it's going to be loaded into our data model. So it's applying query changes, and then it's just going to be taking quite a while for it to load everything in our data model. Now it's loading the data to the model, and then it's going to be attempting to create relationships as well.

Okay, so there you go, detecting relationships. And now we can see that it's finished, right, you can see here, and let's just go straight to data. And let's see what happened. So if we look at team clutch, right, we have our data in here. The clutch games, okay, team defense, let's like this is looking good. We have the defense rating over here, defensive rating score to Team stats, right?

We have all the teams we have the points as well. So that's looking good. Okay. So what we can do right now is we can just make some changes All right. So for example, and when presentation, let's say it's being displayed as a decimal, we want it to be displayed differently. Let's go to modeling.

And let's change the format to person presentation over here, just to make it look better. Okay? So let's go to Team clutch, any changes that we want to do, let's say when person page we can change the format again to presentation we're here. Okay? Just to make it look a bit different. Let's go to team defense, okay?

Nothing, nothing that we want to change over here. Okay, now it's looking good. Let's go to this tab over here for the model, we can look at our relationships. So let me just move this a bit so that you can see the lights better. Okay, so what Power BI has tried to do okay is it tried to infer the relationships between our three tables over here so you can see there's a line relating team clutch and team stats, there's a line for it. Defense that's and then there's a line for clutch and defense.

Okay? So if we go over one by one, you can see that it linked it by location. Okay, so when we look back at our data, okay, so let me just move back here, you could see that team clutch for example, right? Because all of the data over here for the tree tables that we have, they are all uniquely identified by the team. Okay, so you could think of it as the location as being unique right? across all of them.

And then we also have team as well being unique. So which means any two of the columns over here, either location or team can be used to uniquely identify a specific row over here. Okay, so for simplicity, let's just select location. Okay, so the good thing with this one is location is consistent across team defense team stats, and team clutch so which means this row over here for Houston, we would know that this row of stats would be related to this row status file over here, right for Houston as well. Right? And same thing as well, for Team stats.

If we go here, right, the role of Houston would also be related because this location would uniquely identify and relate the three separate girls from the three tables together. So same goes as well for that, say, let's just pick New York, for example, then we would look for a row in New York as well. And you would know the stats here would be related to the same stats that has the value of New York for the location. Okay, so the reason why I explained this concept is because it's going to be crucial in instant stablishing relationships in here. So if we go over here, and surprisingly, Power BI was able to infer that location is the one that's relating the team clutch values and the team stats values. So what I did was, let me just redo that.

I just hovered over the line and double click on it to open the relationship tab over Relationship window. And you can see that is this one is related to this column as well for the location. And that's good. And you can see it's one to one. So which means one row is related to one role in from Team stats to Team clutch, or vice versa. Okay?

So that's what we want that looking good. Select OK. If we hover here, okay, you can see that it's team is relating team from Team touch to team defense and activity, that's fine, but for consistency, what we want to be related, right, would be location, and location. Okay, and it's one to one. Okay, so we just made a change to the relationship over here. And once we're happy, just select Okay.

Now, if we hover again, yep, it's looking good. It's now location and location. So if we do this as well, let's check team stats and team defense. And it's looking good, right, it inferred and used location so we're happy with that. Now once we're happy with the relationships will now be able to move on from our data model and we can now start with our visualization.