Okay, so now we've loaded our data. We're happy with what we did, okay, and we've applied our first transformation, which is extracting the year from order date. Okay, so we've done a great job. So far, we're happy with both of them salesperson and sales. What we're going to be doing next is go to home, select close and apply. And this will now get added to into our data model.
So it's pretty quick. Okay, so if we jump over to data over here, and you can see that sales and salesperson have already been loaded, we just scroll down. It's the same data that we're seeing right now, if we jump over to salesperson is the same six people over here, so that's looking good as well. And the next thing for us with our data model is we want to ensure that they are correctly related to each other. Okay, so what do I mean by that? So let's jump over to this tab over here in the model.
And you can see now the relationships so we have sales, we have sales person But you might be wondering, where did this come from? Okay, so this line over here signifies on how sales person is related to sales. And you can see if we hover over the line, you can see sales person ID being highlighted. Okay? So let me just double click on the line so that we can have a better look over here. Okay, so if we go over to what's highlighted is showing that Power BI was smart enough to infer on what was the relationship or the related columns between the two tables?
Because it's correct. Okay, so you can see that salesperson ID of salesperson table was related to the salesperson ID column of sales, which means what we're saying is, this one over here would pretty much represent as well, wherever the salesperson is to a specific sales role. And it was able to infer as well that there's many to one for the cardinality What this means is Many to one so many sales, right is related to one single salesperson, which is true. Because, for example, this one, Michael Jackson has a sales person ID of one. And there's only one, salesperson ID with the number of one in here, right? But over here in the sales table, there's a lot of ones over here because Michael Jackson has made more than one sale.
Okay, so same thing for to salesperson tree, right? So for john, for example, if we jump over to the spreadsheet so that he can have a quick look. So if we jump over here, you could see that there's a lot of trees over here, right? Because there's many instances of salesperson ID number three. So these are all sales that are made by john over here. Okay, so if we jump over back here, so which means this relationship is working fine.
So the inferred relationship by Power BI is fine. So we're good with it. Let's go Okay, which means our data model is good to go.