 What's going on everybody welcome back to another video. Today we're going to be starting our Power BI tutorial series. Now I am super excited to start this series with you guys. We're going to be breaking this up in about six or seven videos. I don't really like those super long videos where it's like four hours long. I like breaking mine up into chunks so that's what we're going to do. This is the beginner series and so we're going to start with the very basics and we're just going to work our way up and I'm going to walk you through every single step of the way. It'll be very easy to follow. Everything will be provided for you so that all you have to do is really follow along and by the end of it you should know Power BI a lot better and you should have a lot more confidence using it. Now before we actually jump on to my screen I want to give a huge shout to the sponsor of this video and that is Udemy. You guys know that I absolutely love Udemy. I've been using them for years and that is no exception when it comes to Power BI. I have taken some of the best Power BI courses ever on Udemy so I highly recommend you checking out the ones I have in the description. These are ones that I actually took and I loved the most. So if you're looking for a full Power BI course I highly recommend checking out Udemy. Thank you so much again to our sponsor and now without further ado let's jump on to my screen and get started with the tutorial. Alright so the first thing I'm going to do is download Power BI desktop. I believe this link in the description so you can just click on it. Go to it and download it. We're going to click this download free button and once we click it you can go to the Microsoft Store and I already have it downloaded so when you see it it'll already say downloaded but for you you can go in here. You can click download and it will download it for you. I'm on Microsoft but it may look a little bit different for you if you're on a different system but once that is done we are going to open up Power BI. So let's go right down here to our search. Let's go to Power BI and it is going to open up for us. Alright so right away this is what it's going to look like when you open it and we're going to go right over here to get data and let's click on that. It's going to open up this window and it's going to give us a lot of different options for where we can get data from. Now some of these are free and some you need to upgrade from but you're just taking a quick glance through here. You have a ton of options. There's databases, there's you know blob storages, there's PostgreSQL or different SQL databases, there's Google Analytics, there's a lot of places and you can go through the process to connect to that data and you can pull that data in from those data sources. Now for what we are doing we're just going to be using an Excel. I'm going to leave the Excel that I'm going to be using in the description. You can go and download it and walk through this with me. So what we're going to do is click on Excel Workbook and we're going to click connect. So we're going to go right here in our Power BI Tutorials folder and we're going to click on Apocalypse Food Prep. So let's click on that and it is going to connect and pull that data in. Now right here we have our Navigator and so if you had a lot of different sheets you can click on that and choose which ones to pull in. I just clicked on it right over here and we're able to preview the data but I can't load or transform it yet. I need to select which sheets I'm bringing in. So we only have ones that's the only one we're going to bring in. So you can go ahead and load the data or you can click on Transform Data and it's going to take us to Power BI, Power Query, which is going to allow us to transform our data. So I'm going to have an entire video on how to transform the data but I'm going to give you a really quick glance at it to kind of show you what it is. So right up here it says our Power Query Editor and this is the window to basically transform your data and get it ready for your visualizations. Now you can do this in Excel if you want to and do that beforehand or you can do it here and there are lots of things that we can do in here as you can see at the top. Again I'll have an entire video dedicated to just Power Query but let's take a quick look at the data and see if there's anything we want to transform quickly before we actually go and start building our visualizations. So over here we have the store where we purchased it, we have the product that we purchased, the price that we paid and the date that we bought it. Now the first thing that jumps out to me is that this just says date on it. We might want to say date underscore purchased and we're going to hit enter and if you noticed right over here on these applied steps it says renamed columns. Everything that you do, every single step that you apply to transform this data is going to be right over here and if I want to, if I go back and I say you know I really didn't want to rename that column I can just click X and it is going to get rid of that and take it back to its original state. So again I'm just going to say purchased and we're going to enter that. Now this is our apocalypse food prep. So this is food that we are buying for the apocalypse for this example and if we look at our products we have bottled water, canned vegetables, dried beans, milk and rice and all that stuff makes sense except for the milk. Milk will not stay or last long in the apocalypse so I think what we're going to do is we're going to filter that out really quickly and we're going to click okay and right over here again says filtered rose and so now if we scroll down there's no milk. So what we are going to do is we're going to go over here to close and apply and it is going to actually load the data into Power BI desktop. So on this left hand side it immediately takes us to the report tab and what we want to do is go right here to the data tab and take a look at our data. So again there's our date purchased and as you can see the milk is not in there. Another tab that we're going to take a look at and again in this report tab this is where we actually build our visualizations. The data is where we can see the data and change it up a little bit and change some small things about it like sorting the columns or even creating a new column and over here we have this other tab and it's called model and this is especially useful when you have multiple tables or multiple excels and you need to join them to kind of connect them together. We don't have that but in a future video I'm going to walk through how to use this entire tab. So now let's go back to the data tab and I want to just look at the data really quickly before we go over to the report tab and we start building our first visualization. As you can see I've been buying these different products in different months. So this rice I've been purchasing in January February March and April and I've been buying it from three different locations because I wanted to see if I was spending less money at one location on all of the products so then I would just shop there in the future and save a lot of money or if there were specific products that were really cheap at one location but others they were cheaper at a different location so I should just buy like the dried beans at Costco but everything else I should be buying at Walmart and so that's what we're going to look at in just a little bit so let's go over to the report tab right up here at the top there's this data section so you can kind of choose if you want to add any more data now that we are here we can also write queries or transform the data like we were looking at any power query editor window over here in the insert we can add a new visualization or a text box and then in the calculation section we can create a new measure or a quick measure and then over here we have share where you can actually publish your report or your dashboard online. Now over on the visualization section on this far right this is a very important area this is where a lot of the actual creating of the dashboards happen so let's take a look really quick and we'll get into a lot of these things as we're actually building our dashboard so we're not just sitting here looking and talking we're going to be actually building and doing all right so we're going to click right here on this drop down on sheet one that's going to show us all of our columns now two of the things that we wanted to look at were where are we spending the least amount of money buying the exact same product that will help us determine where we want to shop and the second thing was should I be buying all my products at the same place or are there certain products that they're going to be cheaper at a specific store and I should buy it there so let's start out with the first one which we're just going to see with the store and the price where we're spending the least amount of money and just at a quick glance we can see we're spending the least amount of money at Costco at $210 versus Target 219 and Walmart at 225 and that really answers our question but we want to visualize it better be able to see it in an easier way so we're going to go right over here and we can click on a lot of these but the one that probably makes the most sense is the stocked column chart and it's going to show what Walmart Target and Costco now they're all the same color let's add a legend so we're just going to drag store over here down to this legend and let's make this larger while we're working on it so now we can see we're spending the most amount of money at Walmart right in between at Target and then at Costco is the lowest and so right there we know that Costco is the place to go for our apocalypse food prep but is it going to be that way for every product I don't know let's take a look let's put this up in this corner and let's start a new one we're going to select the product for sure and the price and probably additionally the store as well and let's click on let's not do this one we need a clustered column chart that's what we need let's bring this over here let's expand this quite a bit and so really at a glance this is giving us everything that we need we can see each product right here and we can see how much we're paying per store and so for rice we're paying it looks like a lot more for our rice at Walmart's while at Target is actually where we are paying the least now if we look at all of these it looks like for Costco the only one that we're really paying a lot more on is on our rice but for our dried beans our bottled water we're paying quite a bit less and really it's pretty negligible for these canned vegetables we're paying maybe what 60 cents 50 60 cents more per can so that's pretty negligible but for the big ticket items we're really spending a lot less at Costco if we wanted to spend to save just a little bit more money we could go to Target for our rice now if I want to make this more like a dashboard and we're only keeping these two things I'm going to kind of size them kind of like this whoops I'm going to show you that in a little bit I'm going to size them a little bit like this so now that we have that looking good we want to change the title of both of these so what we're going to do is go over here in our visualizations and format your visual and we are going to go to this general go to title and now we can name it anything we really want for this we're going to say best store or product and while we're in here one other thing that I wanted to do is I want to go to this visual go right down here into these data labels now we haven't added any data labels so I'm going to click on you'll see exactly what it does it just puts the labels and the numbers above it so you don't actually like hover over it and see what it is now it is actually rounding these numbers so what we're going to do is go down here we're going to go down to values and we'll go down to display units and it's on auto so it's auto rounding those numbers and we're just going to say none so we can see the actual value of these numbers and we can do the exact same thing over here it probably is a good thing to do um and it just is going to visualize it a little bit differently in here but you can always change that if you want to go over here to title and we're going to say total by store and now we're going to take a look and so in a matter of minutes we were able to take our data from an excel put it into power bi transform it a little bit then we're able to create these visualizations that gave us concrete answers to some very important topics we now know that Costco is the place to go for basically every single product except if we're buying rice and if we want to save just a few dollars we're going to head over to target and that's genuinely going to change my shopping habits for the next several years until the apocalypse happens so in future videos we're going to dive into a lot of the things that we looked at today but just in more detail and then at the very end of this series we're going to have an entire project where we really use every single part of power bi and create a beautiful dashboard and so that's all we have for our very first video in our power bi series i hope it was helpful if you like this video be sure to like and subscribe below and i'll see you in the next video