Okay, now once we have our data model ready, we're going to be going to the most exciting part, which is this wonder report. So select the Report tab, we'll be creating our visualizations. And we have a number of chart types that we want to play with. So first things first is we'll be working with a column chart wherein you want to combine the locations and the number of wins. So what I'll be doing is let's look for the location and number of wins. So it's under team stats.

So I'll be dragging location over here, okay? And it's going to be defaulting to a table by default. Okay, over here, as we just drag the fields. So let me just move over and grab the wins over here. So let's just drag this over here. So now we have a table showing all of the locations and the wins for each location or which each team actually but what we're after is a column chart.

So what I'll do is Let me just go back here, make sure that's still highlighted or selected, and select a clustered column chart. And that's going to magically change into a column chart over here. So I'll just expand this, so that you can see all of the teams listed out over here. Okay, all of the locations. So you can see that Houston is actually the most number of wins with 65 wins all the way to Phoenix with the fewest wins of 21. And we just add, right, you're able to create your own column chart.

Now, let's go over here you can see to access location, the value SD wins column over here. Let's go here to the Format tab, you can actually make some changes, whatever formatting that you want to play with. For us, let's just change the color. Okay, let's just play around with it. And we have our column chart now. Next is we want to create some fiscal statistics over here on the number of teams, the games played and the number of touch games played.

Thank you. So that's true. So to fix that we want. And to do that, we want to use a card over here. So let's work with the first one number of teams. How do we display that over here?

So I'm just resizing the card. Let's move that over here. And let's pick the smaller bit. Okay, this is pretty cool. And number of teams, right? So which means we can grab here, the team and drag it over here for the card.

Now, it showed you the first team, okay, but we can make changes to that. Let's go to fields, select here, and you can change it to count. So what it's going to be doing is it will be counting the number of teams inside the team stats table. And here it is show you this card or here, right. That's pretty cool. Now let's work on the next card.

What we want is the number of games played. So let's just drag this here. Okay, resize this. And the number of games played. Okay, so we have games played inside here. Let's just drag this here.

And that's actually the total number of games played, which is 2004 to 60. That's a lot. Okay. And the last card that we want to do is let's create another one. And the last one is the number of clutch games that was played with all of the teams. So let me just move this here.

So let's go to Team clutch. And let's get the total number of clutch games. drag this over here and we have 1270. And now we can play around again with the formatting just to make it look better. Let's go to the Format tab is go to background, turn it on, and then let's change the color to whatever you want. Same thing here.

Let's do the same steps format. On this card, change the background color, make it go for blue, and clutch games go format, change the background color, okay, and that's picked up Yeah, just like that you have your three cars over here with the statistics. Okay, so next thing is let's create a gauge, this gauge over here just like it. Okay, let's just put this over here. Resize it to fit here. Okay, so for to gauge, what we want to do is we want to have a gauge of the points, and then showing it the minimum, the maximum and the average.

Okay, so this is pretty cool. So what I'll do is four points, we'll just drag the value over here. Okay. And then let's drag it to minimum, maximum, and the target value over here. And now we'll be doing some customization. Now, because for the minimum value, we want the minimum of points to be shown.

For the maximum value, we want the maximum, so let's change it. And then for the target value, we want to show the average ad now you can see it over here. The minimum is 98 Maximum was 113. And the average is 106, as shown over here. So that's where to gauge and same thing, let's change the color just to make it different. So let's go to data colors.

Just change it to say, violet over here. Okay, cool. Now, let's work on next with maps. So for maps, this is really cool, because what it can do is let me just select the map, what I can do right now is just show you the locations right inside the map. And it the circles will represent the size of whatever value that you select. So for our map, what we want to show is all of the locations of the teams, and then the circles the size of the circles will be reflecting the number of wins, so which means the greater the number of wins for a team, then the bigger the circle, okay, so we would expect Houston, for example, to have the biggest circle in our map.

Okay, so what we'll do right now is let me just try The location, okay to location for the map, right. And then for the size, we will be dragging the number of wins in here. And just like that. So let me just resize that so that you can see it better. You can now see all the locations listed out over here and it was intelligent enough to determine that most of the locations are within the United States. So which is why it's zoomed into the United States over here, and the size right in the circles.

Okay, so if we select For example, this one, right? This is Golden State, okay. If we select this one, right, it's a big circle. So you know, it's Houston over here. Let's go to the circle that we think that's the smallest one is this one over here? Nope, that's Memphis.

It's go to Phoenix over here. There you go. So you could see that it highlighted Phoenix, that's the smallest circle over here. So it's pretty cool, right? Without even doing anything it was able to find the locations for You, and then it represented the number of wins as different circles so that it provides you a geographical visible view. Okay?

Another cool thing is whenever we select that one of the records over here, okay, you could see, like, for example, this is Denver, right? It was able to interact with the rest of the graphs or the visualizations we have over here. It's just one team, right that we selected, that team played 82 games, and Denver played 43 clutch games. So we could do the same for the others. And the numbers will change because they're related to one another. Okay?

So that's really, really cool with the interactivity of the visualizations in Power BI. Okay, so let me just select outside so everything gets selected again. Okay. So this is the map and we can actually go to Format and make some changes again. So if you want a different map that for example, let's change this to an aerial view. And now you have I have a different, different view over here.

Okay, that's for the map. Now let's try now for the column in line chart. So let's have a look here we have the lining clustered column chart, select that. Okay, so let's play around with it. And what we want to show here is the location. And then in the column, write the columns over here, we want to show the number of wins.

So it would look similar to this. But we want to add a couple of different stats in here. For the lines, we want it to be the defensive rating, and the points and the number of clutch games. Okay, so that's a lot of data that we want to fit it. But this is going to be looking good. So first things first, we want to add the location in here in the shared axis.

And the column values we want to show is the number of wins. So let's just drag this here, column values. Okay. So it's looking very similar to this above chart. Okay, so let me just extend this a bit, I think I might need to make this smaller. And then let's move this chart over here.

Okay, now we have this for the lines, what we want is the defensive rating. So we can just go over to team defense line values and just drag defense rating over here. And now it gets. Yeah, we can see it now over here. And Nexus, we want the point. So we'll drag the points from Team stats to line values.

And there's another line exhibiting the points, the point values. And last but not the least, we want to show the clutch games as well as a line value. drag it over here, and you have your clutch games now shown as the yellow line over here. And what is wonderful with this one is thanks to our data model, we were able to relate all of the records to one another between these three tables. And you were able to drag different values from different tables right in just a single graph. You were able to drag three fields over here touch game defense rating, right points over here as line values, and they're from separate tables.

And Power BI was able to determine from which team right each value belongs to thanks to our relationships that we did with the data model. Okay. So the last chart that we want to play with is the pie chart. So let's go to pie over here. Okay, let's add this pie. And what we want to show is the location and the number of touch games for each location.

So we'll just be going over here to location as the digit and then for the values, track over D Touch games. And now you have your pie chart shown over here for all of the locations. Okay, so I hope you had fun over here. You can play around with it even more, try all the different visualizations because it's very easy to play with with your data. And it's the appealing as well as you enjoyed the process. Okay, so the next one we'll work on after is once we have our report ready, such as this one, we will now be publishing it to the Power BI website so that you can share it with your colleagues.