PowerBI Basics - Long Version | Thomas Fragale | Skillshare

PowerBI Basics - Long Version

Thomas Fragale, Microsoft Certified Trainer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
1 Lessons (1h 23m)
    • 1. PowerBiFull

      83:06

About This Class

There's a new way to process your data and get great reports, great charts, and great summaries from your data to produce meaningful results.

PowerBi - Power BI - Business Intelligence - A new product by Microsoft designed to help you get meaningful results and charts and reports from your data.

Learn how to connect to your data, add charts, add slicers, add sorts and filters, and calculated fields into PowerBI. Learn about the desktop version and the Online Version.

Transcripts

1. PowerBiFull: have everybody. My name is time for Galley. I'm a Microsoft certified trainer and I've been doing this for a long time. I've been doing with lots of different data bases and Exelon access for a very long time. You can reach me through the four intuit what you're watching a webinar. I'm available for private webinars or for consulting or for treating on site. You can always find me online or every treated before in French washing a webinar. Today we're gonna cover a powerful topic. Microsoft Power Bi I. So Power bi I is, ah, powerful tool. It's going to allow you to take your date of many different sources and make different charts and dashboards, and that's what we're going to talk about today. It really is catching on because really, you'll see that you'll be able to, you know, make dashboards and reports without really having any programming whatsoever. So first I'm going to show you the on line version of power Bi. I will talk about about that, and then soon we'll talk about the the desktop version, which actually is a lot more powerful than the online version. So I'm gonna go ahead and switch over to let's say you have office 3 65 And when you have the office 3 65 membership with Microsoft. That's one way to get the power. Bi I Now you can go up to the Microsoft website and get power bi I separately, but I haven't through the office 3 65 membership. So here I am, actually on my SharePoint with office 3 65 And let me show you how we would start going in the power bi I So on this screen, I'm gonna pick on office 3 65 0 by the way, sometimes I'll make my mass do that so you can find out where. My mouse sys. I'm gonna come over here and click on office 3 65 right there. And now you'll see the different applications that go with office 3 55 Now, here you have outlook in one drive and word and the things that you're familiar with now those how on mine I do have power, bi I If you don't see that on yours, what you'll do is you'll say, explore all APS and then you'll have a much bigger list. So I'm gonna pick on explore all APS. Then if I scroll down, then it will eventually show power. Bi I So, actually, all these things come with office 3 65 But anyway, there's power bi I If it wasn't on the other list, it'll be right here. I'm gonna go ahead and click on that, and this is gonna be the online version now, um, So I set up these data sets, uh, previously. But when you first go into power, bi I you have to upload data eso the part that the online version can use excel spreadsheets, text files or see SV files that can also connect the SharePoint. You're gonna find that the desktop version can connect a lot more types of data that we'll talk about that. Now let me switch over to excel for a second. Now, in order to use your data, the in power bi I the self specially has to be formatted as a table. So, um, notice my screen right here. We're in Excel spreadsheet, and it's formatted as a table. Now that's how you have your field names. You really You want the field names in the first row and then it's one consistent Bach of data. Now, if you just have regular data, it's pretty easy to convert that into ah, formatted table and excel. What you would do is you were picking them. Pick on one cell within the block of data. You pick on the home menu, and then you come over here and you pick on format as a table, and then you pick one of these styles over here. I usually go with this one, and then it gives you the result that you're looking at on the screen, which is where every other rumors that shade of color, but any one of the styles will be fine. But I do personally, you should go with this one right over here. Now the data is formatted as a table. Then I would say this friend, she like that. So here is a list of orders, for example, And then I have another Excel spreadsheet that we're going to use during the demonstration . That is the customers. And you could see that when it's also format as a table. So that would be really important. Now this would switch back over to power. Bi I there we go. All right, So if you know. So this is the power bi I online version. First, we have to pull in some data, so I'm gonna come over here on the bottom and I'll pick horses, get data. And in this case, um, now you can have some that maybe your company sets up for you. That's thes two choices over here. Now, that's ever here. We can get the files and it says we get to excel. See, SV files and so on. And over here, you can connect Teoh Microsoft Azure. Now I'm gonna show you on the desktop version. You'll have a lot more data sources than what we have here, but this would be a great place to get a start it. So I'm gonna go ahead and pick on, get right. So and then you can use a local file. You could use something from one drive here. Is there? SharePoint? All right, so I'm gonna go pick on local file. And when a point to that excel file on my computer, of course. The laser show you so pick on desktop. And I made a folder for this webinar power bi I webinar what we find. And then we see it as excel files. I'm gonna use the orders of table that I showed up. So double click on orders. Now that's gonna pull that into, um, power beyond. Now you have two choices. In my experience, The choice that works the best is the one that says, uh, empire. If you just upload it, you'll be able to view that almost like an Excel spreadsheet with Excel Online. If you really want to get the benefits of power bi, I I will pick in the word import right there. Give it a second. And then here comes that table. Okay. It says your data set is ready. Now, if I pick under review data set right there, it will show me the Excel spreadsheet. But I'm gonna close that window, and now we'll start to get the benefits power beyond. Now on the on the desktop version will be able to join the tables together and you'll see exactly I mean by that. Now there is the one. I just import it. I'm gonna double click on that. And now we're in the power. Bi. I, uh, tool here, So I just I just clicked on that item again. And now we're really into the power bi I. So if you know this over here you have different chart types. Show about this screen in the next hour and 1/2 or so. Now, on the online version has a pretty unique situation. Here is ask a question. So let me start right there. Now, this is where all of your different charts and things are gonna appear. The charts and the different things that you see in the slicers are all called visuals. It's just a name that he gives them. So each box that we see each slicer and each chart is gonna be called a visual. Now I'm just gonna click right here into the white workspace, and I'll pick on the word Ask a question, right, sir, And it's going to open up this window. And, uh so this window is going to be where the chart appears or where the dash but the slicer appears, and the workspace can have as many of these visuals as you need. This is kind of a nice little tool here, says ask a question. So I might say something like how many orders, for example, and if you notice in the back here says 830 records. Now let's say how Maney orders are from Italy. I know I have a country in the orders table, so if I say how many orders air from Italy, it says 28. So I kind of like that. Ask a question future right there. I can put my question in English on Get different results. Go a lot further than that, but I think that's kind of interesting way to get into our power. Bi, I hear. So I'm gonna say how many orders are from Germany and then you could see now this is 122. Let me show you said, There's a lot of different commands you can type in the English part in the Ask a question part. I'm not ago. I'm not going to go into that too much longer. But here would be another example. How about if we said some of order amount and then if I had just click away from that, then it says the order amount comes to 1.35 million. So I just think it's an interesting tool. What if we said some of free and then you would see it would have a different number so I can start to get quick results from there. But that's the way Start to use the benefit of the power bi I, which is more of the visual charts of things like that. Now, if I went that there as one visual, I can keep that one there or I'm actually gonna click on that one, and then I can change it. So, for example, if you notice where my mouse is going to go, then you have different types of charts and s So we have a stacked bar chart, the stacked column chart and many of the ones you might be familiar with from Excel. You're going to see a lot of similarities between this and excel. Or maybe this and access and things like that. That is, they have different chart types. I want to show you some of this. Now here there's even maps. Eso Let's start with a what if we start with a stacked bar chart that knows how it did it into this same visual over here, so I could could have made a different one, but I'm using the same one as before. Now then you have these areas over here which you could start to change. I'm gonna uncheck it where it is free. And you could see how I can check or uncheck the fields right over here on the right hand side. Here's all the field names from the orders table. OK? The one that we imported from Excel. I would like to see a total for each country. So now this Every here on the right, I'm gonna pick up the word country, and then you're gonna move into these different sections over here. So I put on the stack bar again, all right? And I pick up the worship country, and I'm gonna drag it where it says access. But that's where my mouth says. I'm gonna drag it towards his drag data fields here. If I move it to where is his access? Nothing's gonna happen. All right, So you there. It says drag data fields here. That's where you on a dragon. So pick up the worship country and drag it towards his Ah, Dr Data Fields here. So, in other words, is going to show it to me by country now then you have to put something in the values as well. For the values are pickle when that's called order, amount and track that worse distracted it feels for the value and notice how it started to make Ah, charge for me over here. So now it looks very small over here. I get that what? We can expand us if you notice where the mass is going to go on the visual. This guy right over here will expand that. Of course, I'm gonna show you more about this as well. That's going to expand that good. So now we can see the chart by country, and then we have the X axis down here at the bottom. Well, if you're used to using charts in Excel, then, uh, of course, we could turn the numbers on, and it's called the same thing that it would be in excel. It's called a data label. Let me show you where you find things like that up here. You pick your chart type, and of course I'm going to show you some of this now. Right here is the settings for the chart or the fields for the chart. But this item right there, but I'm gonna click the next one over. Where is his format? All right, so we're gonna click there, and then this is where I can turn on some of the chart options. Uh, that's where my mass is going to go. Over here is his data labels. And I'm just going to click on the item right over here to turn that on and knows what happened right away. I have the total for each country right now. You can go a lot further with these screens. You have to look really closely at these screens. I just turn that on or off by clicking on that button right there. But if I click on this, pull down, then you'll have some different choices there. Here, I can change the color of the text and many different things. That's how you can go a lot further. All right, s so you can always experiment with the Jets were gonna be more about formatting, but I would really want to show you how to use this tool so you can always try to yourself . But I'm just gonna put that away with the arrow, right? So but knows how I just turned the data labels. Now, all of a sudden, we have, ah, some by country after just a few minutes. Now let's see how we can go a lot further with this data. I'm going to click on the U. S. A bar now. By the way, if I move my mouth around the bars, see what's happening, it's going to show you the value that way as well. So I'm gonna click on the U. S. A bar and you can see that that is hide it by itself. Now you're going to see that power bi. I has the ability Teoh drill down. So I'm gonna right click on that bar, and then I'm going to see where it says, see records and then know this how it's going to show me all of the USA Records, right? So we just did a drill down pretty easily. It's built right in. I'm gonna go ahead, pick on back to the report you're gonna find you can drill down just about it anywhere on the power bi I as you get as we get into Russia, more examples of that, I'm gonna expand it again. Good. So what I did was I clicked on the bar for the USA, and I right clicked on that and I said, See records. Now, what if I said show data? What does that would give us? Then? I shows the actual numbers in a chart like format, you know, from the this is what the chart is coming from or this is what the trial is displaying. So that's a nice item as well. Eso Now, let's go ahead. And if I want to just go back to the report here, that it's back to this version and I'm gonna go ahead and expanded again. Good. Now follow my mouse over here, and then you get the three dots and you'll have more choices over there as well. Now I can export this data if I pick on show data. That's the scene. When I just showed you I can remove this visual or I can sort it in different ways. You can say right now it's sort of by the order amount, or I could start by the country alphabetically, and then you have that choice as well all right. Now, they're sort of reverse order alphabetically. If I go back to their, I'll pick on sort by order amount again. And now the highest one should be up top, as you could say. All right, so we're starting to look pretty good. Start to get some good results. Eso Now, let's go a little bit further. I'm gonna I'm gonna go back through the report here. So what's really interesting about power, Bi? I is. I can click to the different chart types, and it will instantly change, as you can say so, if you notice over here on the right, I'm clicking the different try types. And if you look it over here on the left right away is gonna change that chart type. So change your chart type is pretty easy here. Just click among this now what if I wanted to have the bar chart and the column chart at the same time? So I'll pick on the back to the bar chart then, uh, you know, I could right click on that, and we can always, um we can always duplicate. So if I come over here now, your workspace could be made up of many pages to notice. Down here, I can add a new page and you can go back and forth among your pages, Of course. And so that's I want to duplicate this place over here. Then maybe this one I would make into, ah, bar chart or the column chart. All right. No problem with that. So I could easily duplicate that without a problem. Now let's add what we call a slicer. I want to leave this. I'm gonna leave this one there, but I'm gonna add another visual, So I'm gonna click away from it. And when you click over here, they're going a blank space of the workspace. Then if you notice where mass is going to go, this is gonna have a slicer. Ah, slicer is a visual filter. Maybe if I demonstrated for you, it'll make more sense. I'm gonna go ahead and click right there, and those haven't opened another visual. Oh, by the way, if you want to move these, you move your mouse to the lines right here and then you could just drag it. You could put that anywhere on the on the screen. Here. You can also resize this. So let's say it went to resize this one. So it's nice and big like that. Good. All right. So what we'll do is remove this one over here. I want to resize this one. Okay, that would be good. And then this would be where we put our slices. I'm just moving these around now for the slicer. I just click from that visual again, and then you're gonna tell what feels will be in the slicer. So let's say I would like to have Let's say I would like to have the, um, employee I d. So I pick up employee I d and drag it over here Toe wears his field for the slicer. Good. Eso In this case, I can, uh, I could just go back and forth year, and I can actually drag this. Let's see, I just went employees one and two, and then those had the numbers just changed the gap. All right, so if I destroyed that back and forth, you can see how the numbers are changing eso I'm showing different employees. Let's try a different slicer. Let's say I'm not really happy with that one, so I could easily switch my fields out. Why don't we do it by order? Amount. Instead, I'm gonna go and close this window for the employees. T. I want to get rid of the field for the employee. I d on the slicer. I'm gonna pick over here again to make another visual this time, when we use order amount. So pickup order amount A dragon two wears his values right there. And we'll get the same kind of scream. And then in this case, what we delete that one. Uh, let's try. What if we tried the order date? So I pick up order date and drag it to the values and then we see the different dates. So what if I want to do the orders? Let's say bye bye month or by year. Right now it's by individual date. And then I could click on any one of those Just showed the orders for that for that one Data's you could say so that's an interesting way to do a slicer. But I'm gonna go and clicking This pulled out. Where is his order date? And then we can do it that in these different ways, So here's his earliest latest count and so on. So I'll pick on earliest. And then if I just picked on that date, then the numbers change so we can get some really great results with the slicer as well. I'm gonna go tend to eat that. So I was able to show by country pretty easily. Why don't we try to slice it with the customer? I d. So again, when I click over here in this part of the workspace Ah, pick up, customer, I d I'm gonna click on this slicer visual. All right? We'll pick up customer I d and drag it right into here. Good. Now, let's say I just wanted to see the the orders for a customer. I'm just gonna go ahead and click thes and you could see how it's changing. All right, then we're getting specific numbers. Now, if I want to pick more than one from this list Ah, hold down the control k. This case I'm holding down the control key and that you can see how I can pick more than one. Now you could have more than one slicer. Of course. So the power, the great advantage of power bi I should have as many. When does this? You wanted to, and we're starting to make a dash for So I just collapsed that one. Now I'm gonna click over here on the workspace again on the blank workspace, and I don't have another slicer. So picking the words slicer right there again, you could see him in another one When every size, that one Now, maybe this one I let tohave by employee i d. So I think I'm employed the movie to where it's his drive fields here. Good. Now that say, I just wanted for employees one. And I just want to certain customers. Right? So you can really start to get some great results, as you can say, just by clicking around. And that's what we mean by a dashboard. I'm gonna go ahead and expand some of these. Excellent. All right, so you can see we can start to make some basic charts. Now, what if I wanted that to be a pie chart instead? I'm just going to click on the first visual and I'm coming over here and pick on the pie, for example, Or maybe the doughnut and you could start to see some tremendous results here right now in power, bi I We can also start to make maps as well. Eso I'm gonna go ahead and get everything back again. Now, to get everything back at this time, I think is, uh I could just get rid of that slice or window so this him would expand this toe. 129 All right. And then maybe I don't need that window anymore. So I could just hit my delete key, for example, on my keyboard, and that one goes away. And then for the customers, if you notice over here, I could say clear selections, and then that would show everybody All right, so that's that little tiny taken over that, uh, the clear selections and that I was able to show everybody. Now I could show them as a list, or I could show them as a drop down as well. And then at that point, you would have a pull down for when she could choose those as well, whichever that you like. All right, so I have it back again. Now, in this case, I'm gonna delete the slicer window for the customers. Now, let's see how we can make this into a map. So I'm gonna click on the visual for the donut chart, and I'm gonna come over here and there's actually a couple of different maps that you could use. There is this one over here, and it looked more like a globe. So I'm gonna click that and then notice how it filled in. Now, that's I'm gonna expand this over here if you notice for my master's gonna go expended to the full screen. And then if I move them out over the circles, it will give you the country and the circle where it appeared. Them I mean, the value. Okay, so anyway, we could make map out of our data. Now you can use data that will be for states, for countries, for cities, for zip codes. They should all work in the way that I'm showing you. Now, if you notice, I can go over here and I'll say back to the report. All right, Now, remember, we're gonna have questions and answers at the end. Um, s so hopefully you, your see you. What's going on here now? I could even add a sleigh, sir, for the map. this is kind of interesting. I'm gonna go ahead and click over here on the workspace, and I'm gonna add another map if you notice for a mass is called the filled map. But click right there. Now, this shows the map in a different way. And if I go ahead and ah, of course I wanna have that fill them. So put on the ship country and drag it to where it says location. Of course, I'm gonna drag it towards his drag data fields here. Good. And then, um C In this case, I can kind of zoom in, but you certainly wanna have a value here. So in this case, we will use says legends, latitude, longitude, and so on. All right, eso if I zoom out of that. That is how broad it was actually a slicer for this window over here. If I pick on South America, then it went to the South America ones over here, so I can actually use that as a slave. Zahra's. Well, just by clicking around this one, this other one is going to change. So this is gonna be the online version everybody. So I want to start to move over to the desktop version and because the desktop version will give you a lot more choices on explain what I mean by that. So in this case, I'm gonna go ahead, and, uh, I could just create those slicers there. Now, let's say you're really like what you're looking at here. Then, of course, you can save this. You can. You can save it over here so you can always use it in the future. It will let you pull that data back into excel. All right, Now, let's go ahead and let me show you how you're gonna start to download the the desktop version. Now, if you go to the Microsoft website, you can get the desktop version. I think they give you, like, a 30 day free trial or something like that. But if you have this online version, watch where my mass is going to go. Actually, before I do that, let me catch up with some of the slides. So I'm gonna go back to our power point and share some of the slides. So this is where I first got into power. Bi I I was able to click on the office 3 65 You'll see that in SharePoint when you have office 3 65 and then you'll get your fine power. Bi I If it's not there, your pictures has explore all APS. Then when you do, we'll explore all after going to scroll down. Then you're fine. That's called Power Bi. I and you would just click on that. Why don't you start to see the initial screen now? This is where at the bottom of the window you pick on, get data and then remember how we were on this window and I put the word files. At that point you would pick to the local file, and then it's gonna value to picture an Excel spreadsheet or, in this case, the CIA's V File. Now I would recommend that's the one that's called Import. Actually, even though I have the word upload circle right there, the one that's called Import really works better. And then you'll be, ah, back on this screen within power Bi I and then you would double clack on that data set right there that would bring it into the workspace. And then that's how I started to do the work space. So this is where we made the, um this is where we made the first bar. Try it. And I moved the ship country over here, into the access, as you can see where my Mass west. And then I moved the order amount into the values, and all of a sudden you start to have a nice start there and then, Oh, let me show you how you would expand that sharp If you notice what I have in the square that this little icon right there would maximize that. And then you see the larger screen now to get to the data labels, watch what we did over here on the toolbar. We clicked in this no paint a zycie a paint roller, and that will be the format. And I clicked over here to turn oil where says deal labels already where you would get some nice shoes off then. This is where I was able to show you to drill down. You just right click on one of the bars, for example. And then you see the actual data when it is to drill down is the actual detail. Now, in this case, uh, now I'm gonna show you how to download this onto the desktop version. So let's switch over to power bi I This is the on this is the or my version And watch my screen when you're ready to download this, you're gonna pick on this little arrow and I am gonna get the power bi I desktop. Now, everybody look at the bottom of my screen here. It's going to start the download that now you can see how it's going to be 100 85 megabytes if you notice where my mouth says So it's going to take a while for that to download. Of course, if you have a faster Internet connection, obviously it would be faster than that. Now, after that is done, then you're double click on that, and then they will start to install it. There's nothing unusual about the installation process. You just accept all the defaults on that. You want to change this. But when I did it, I accepted all the defaults and there was no problem. So if you get done down that downloading that you would double click on that icon, it'll start to install, you know, a normal installation and just accept all the defaults. Now, some of you who are working for different companies may have to get your i t team to download that and install it. So by all means, please follow your company procedures to down this software. Now, I don't You don't have to watch me download that. So I'm gonna go ahead and click on this arrow and I'll pick on cancel. But when I first did it, I let that down it all the way, and I just double click on that. And then we went through the normal installation. Now, everybody, I'm gonna go ahead and minimize the online version. And now let's go into the desktop version. So once I have that download it, I'm gonna go ahead and click on the start menu. Now, I do have Windows 10 here, but you know, if you're working with those eight as well when the seven I believe oh, are now knows how I have it right there. Power bi I And if it's not there, then it will be in alphabetical order, as you can say. And there it is, under the peace. Okay, so I'm gonna go back up or is under Microsoft. Okay, so there is power bi desktop and then either one of those is fine. I can click on that and then we see the icon. Now, of course, you could move that I can't hear desktop. Naturally, there's going to be some great advantages Cheese in the power bi desktop. Let's go right into that. I'm gonna double click, and it's going to start the program now, I have a lot of programs open. Right now, I have excel open and access and even a sequel server because I want to show you some different types of debt, so yours might open up a little bit quicker than that. When you first go in the power. Bi, I, um you can get some help right away. Here's some other videos you can watch as of the tutorials and so on are those forums It actually start to be very widely supported. Uh, you can always use the screen, but I want to go ahead and close this window. And now we're in the power bi I desktop version you're gonna see divisional is over here on the right are gonna be very similar. Alleges showed you. Ah, but let me start to show you some of the great benefits of this. First of all, there's gonna be a lot more data types that you can use. I'm gonna come up here and I'll pick on get data. Now you'll see that in this case, we can get to Excel. Spreadsheets, sequel, server, text. Ah, Web file. So there's even more right now. But then let me show where there's a lot more I'm gonna pick where Says more. Then you're going to see there's many, many data types. I mean, just about any kind of data that you can think of is going to be on this list. Sequel server. Oracle, IBM, db two. Now, for some of these, you might have Teoh might have toe interact with your I t team. They have to give. You may be using the password on some other features, but it certainly can connect to all these different data types. Azure is in there. SharePoint. I'm gonna show you a bunch of them. Lucia excel in access. Even Salesforce's in there. Now I look at all the different data types you can get when you have the desktop version O D B C's uh oh, Data. All right, so let's go ahead and get the Excel spreadsheets first. And then later on, we're gonna talk about how important different data. And then you can actually combine all the different data from different sources into one big report here. So what if you're gonna get data, you know, let's go with Excel first, and I'm going to use the same Excel workbooks now the advantage one of the other advantage of the desktop is we could make relationships and joining tables together, and that's going to really increase its power. Assures that the orders table before. So a double click on orders and that's gonna pull that right in and I won't even say, Well, this is going to start something that's called Microsoft Queary with Microsoft Query, I could, uh, let me just show you an example. A pick on the tables 13 and you can see the data. Now, if you didn't wanna have all of that data or if you want to sort it or filter it, then you come down here and you pick on the word at it. If you want all the data. You could just pick on the word lowered from there. But if you want to go on Microsoft Queary, you pick on at it. Yeah. Now, this is what we call Microsoft query. Here I consort the information. I could do filters and just get the exact records that you're looking for s so we could go further with Microsoft Query if you wanted Teoh, I'm just saying that when you go into this edit screen, then you can really sort or filter right and do a lot more with the Microsoft Queer. But I want to really continue to talk about power bi I of course. So I'm gonna go ahead and open close and with your clothes and apply any changes that you would have made, Of course, would have come into that. And now the orders table is now within the workspace. You can see it's over here. And then if I pinched in this, if I pick in the data over here, then you'll see that data set. No problem with that. Now let's go ahead and pull in another data set. Now we'll be able to start making relationships as well. So pick on get data again and up. Uh, once again, we'll go back to an Excel spreadsheet very soon. I'll say, how will use other data? But let's stay with itself right now. Took in excel and this time will use the, um I think I pulled in customers that time. Yeah, and then it's good with orders. I think I did the orders. That time You got any pecan Cancel. I think it did. The owner is the first time. So that's been get data. I pick an excel, and this time it's good to customers. Now, on this screen, everybody you can pick, load, and then I'll just learn all of the data. If you want to go into the power query, then you pick in the word at it and then you can pick and choose the more sore thumb or felt woman. And you're different things there. But I'm gonna pick on load. Okay. Now, in this case, it actually made the relationship between those two tables automatically. Let me show you what I mean by that. I'm gonna pick on the relationships over here on the left, and if you've ever used access, this would be kind of like access where the tables are joined together. If you want to see the field that it is joined by, then I'll click on the line. Actually, we're when I cook to the line here, the customer is shown over there and the customer is shown over there, so we're trying to find the appropriate field now. If it didn't pick the appropriate field, then you can make up your own relationships. Oh, I can double click on that line and changed the relationship there. But in this case, it did find the right one. Now we could talk a lot about the the relationships here admits. Well, because many toe one or some people call the one to many one customer can have many orders . So that's why it says many orders toe one customer. The customer I d is the primary key in the customer's table. All right, so because is the primary key, one customer can have many orders. The customer i d in the orders table is called the Foreign Kid eso that goes into some database technology, but, um, power bi I certainly is a relational database Now. It made that relationship for us automatically based on the common field customer I d. If it didn't do that, why don't we go ahead and let me show you how to make a relationship? If you didn't, if it didn't do that, I'm gonna click on that line and I'm gonna hit my delete. He get, actually, get rid of that relationship, Then I could do it manually. So, um, I'm actually gonna rename these tables. So to rename them I'm just good and right Click rights are that took every name and that one is the orders table. It would just be less confusing for May. I'm gonna call that one orders. And when a right click on this one and I picked every name and call that one, customers good now would make more sense for me and pie for you. Now watch. I'm gonna pick up the customer i d from the customer's table and drag it to the customer D on the orders table. So you always looking for a common field? And then if it didn't do that relationship for you, you could just make it yourself. Now th