 What's going on, everybody? Welcome back to the Power BI Tutorial series. Today, we're taking a look at all types of visualizations. Now, when you're working in Power BI, there are a lot of different options to create visualizations and you may not always be sure which one to use and so that's what this video is for. I'm gonna walk you through a lot of the visualizations that I like and I use a lot, as well as kind of point out some of the ones that I don't like as much so that you get kind of a feel for the ones that I think are really popular and that are used the most. So without further ado, let's jump into Power BI and start taking a look. All right, before we jump into it, there is a link in the description where you can get the data that we're gonna be using for these visualizations if you want to practice them yourself. Before we actually get into it, we do need to combine this and if you download that Excel and you see this, you'll have to do the same thing. All we have to say is that this product ID is the same as this product ID purchased and now we are good to go. Do one to many and it's okay if it's one way. So right over here under this visualizations tab, there are lots of different options and it can be a little bit overwhelming. You don't really know which one to choose. There are some in here that I have almost never used for my job ever. So I'll point those out as we go through but the main focus is gonna be focusing on the ones that I do use that I have used and showing you how to actually create that visualization, maybe spice it up just a little bit but we have a lot of them to go through so let's jump right into it and the very first one that we're gonna start with, probably the easiest one and the one that you'll recognize the most is a stacked bar chart and what we are going to do is go ahead right over here to the product name and we want this unit sold as well. So we're gonna click product name and it's gonna go straight into the y-axis for us and then we're gonna click unit sold and that will go into the x-axis. Automatically it just kind of intuitively knows but sometimes it will make a mistake and then you can just fix it or flip it and we do want this, let me make this much larger, we do want this to be a little bit more color coded, that is what this legend is down here so what we're going to do is drag this product name down to the legend and now we have each product as its own color and in previous videos we have gone through and looked at some of these visual and general options that you have when you're actually creating these visualizations but we're gonna do some of them while we're in here as well. So we're just gonna go down here, we're gonna choose data labels and we're going to shrink that and if you go higher, the higher you go the less you see so if you want all of them all the way down to the green we're gonna go right about there and we're gonna make it smaller. So now we can go ahead and click anywhere outside of that visualization and now we can create a new one if we had just kept it like this where we were still interacting with this visualization and we clicked on a different one it would have then changed our visualization completely which we don't want. Let's hit control Z, click out of it and now we can create a new one. Let's go right over here to this 100% stacked column chart I'm gonna click on it, drag it over here and make it much larger and we're gonna come right over here to this customer information and we're gonna click on customer and then we're gonna go up to unit sold and click on unit sold and we wanna break these out and so basically what this is doing is it's breaking it out by each of these shops and we can see the total of what they're buying the units sold but we wanna see exactly what products make up this percentage or this 100% so we're gonna go right over here to product name we're gonna drag that down to the legend and as you can see now we have each of these products and each of the products is up here so this backpack we can see the backpack right here backpack right here and right here and we can see which customer is buying what percentage of their purchases so for this prep for anything prepping store they have a very large percentage 40% is duct tape so they're buying a lot of duct tape so really quickly we're able to see what clients are purchasing or which clients are purchasing what products the most so just like this Alex Analyst Apocalypse Preppers they're buying a lot of water purifiers we like drinking clean water that's just what my audience likes and so we can easily get a quick glance of that again we're gonna go in here I tend to like putting these data labels on here that's just what I preference so you know something like this it looks nice it looks clean we can always go back and change these names which we'll do for this one so we're gonna go over here we'll go to title we'll go down to the text and we'll do customer oops customer purchase oh geez breakdown pretend I'm really good at spelling and we're gonna do it just like that we'll get out of there so now we have customer purchase breakdown and that looks really nice it's a good visualization and we're gonna bring that right over here we're gonna have a lot on the screen so I may have to make them smaller or larger to fit everything alright so let's go on to our next one another really common visualization is this one right here which is the line chart and the line chart is great especially when you're using things like dates I have found this one to be the best and a lot of people use this as well so we're gonna go right over here and click on date purchased and then units sold and on the X axis you can see it's broken up by year quarter month and day so we don't wanna do it that high level we only have three months of data in here so we're gonna get rid of the year we're gonna get rid of the quarter and then we at least have this and let's break it out because right now we're looking at all of the units sold so we're gonna drag the product name right down here to the legend and now it breaks it out by the actual product and for each month in January, February or March you can follow these products and see how they did in each of those months and if we wanted to we can come right over here to the filter on the product name and we could filter it by maybe the top three so let's do multi-tool survival knife the nylon rope and the duct tape and we can have it just like this and you can do those for any product that you want but again we just wanna do it for those three just for an example and that really doesn't give us a ton of information we can even go down to the day and it might give us a little bit more information and so we'll keep it like that and we can go over here change the name as well we're not gonna do this for all of them again we're just looking at the different types of visualizations that I think are really good to know but we'll change this one as well to products purchased by date and we'll keep it just like that again nothing fancy we're just trying to look at a bunch of different stuff so let's put this over here down here now let's click out of there and there are other ones in here that are definitely useful and you absolutely can use like this one is a stacked bar chart this one is a stacked column chart basically the same thing just a different orientation like we went to here just a different orientation it's the same thing just like this clustered bar chart custom column chart it's just its orientation either horizontal or vertical then we have things like an area chart stacked area chart not really things that I've used too much in previous positions one that I have used though is a line and clustered column chart so it kind of combines a few of these with you know you have these bar charts as well as line charts into one visualization so let's look at this one because this is one that I have used several times in my actual job so for our x axis we'll use the product name then we'll look at something like the price and so let's make this a lot larger so you can actually see it so now we have the price and now we can look at something like the production cost and that can be our line y axis so now we're looking at the price of it how much someone is actually paying for it and then we're looking at how much it's costing us to actually produce that product and so really quickly at a glance you can kind of see that it's around the halfway to two thirds point on most of these you can see that the production cost is always lower than the actual price because of course we're out here to make a profit on these products let's minimize this one we're gonna put this one right down here let's make it even smaller let's click out of that and the next one that we're gonna take a look at is a scatter chart so let's click on that and make it much larger there we go so let's use the price and the production cost again and so our x axis is the price our y axis is the production cost but now we need to fill in this values right here so let's go over here and click on the product name and drag that into values and so now we have our values we just don't know what they are but we can see it so let's drag this down to legend as well and it breaks it out and we kind of have this scatter plot and for this fake data that we're using it doesn't really show a lot but if you're using real data you can definitely find outliers and trends and patterns using this type of visualization let's go ahead and make that one small as well I get right down into the corner now let's go right over here and we have the dreaded pie charts and donut chart now look I think it's kind of a joke in the data analyst community about pie charts and donut charts but at the same time people use them and they request them and so sometimes you're going to use it whether you like it or not so let's click on the donut chart and let's make this one a lot larger and let's go over here and let's click on state and we're also gonna click on total purchased and that's really all you have to do these ones are pretty straightforward you can change a few different things like where these labels are if you want them inside you can also do that and that would look totally fine again I'm just not a super huge fan but you will get this one requested people like this and want to see it and the reason a lot of analysts don't like using this is because when you start glancing at these it's really hard to tell the difference between these sizes if you look at something like this you can easily see that this is larger like if you're looking at this one the multi-tool survival knife is obviously the longest and it gets shorter, shorter, shorter, shorter but when you start getting in here it's really hard to approximate the size I would not be able to tell the difference between this 5.63, 5.78, 7.72 I would not be able to tell really the difference between these or kind of the difference between them very easily that's why a lot of people don't want to use them in general so again I want to show you this one because I think it's worth noting and worth knowing how to use but I don't really push people towards this because I don't think it's the best visualization available most of the time All right, the next two are super easy but are used all the time maybe more than some of these even but they're just so easy to use so I'm kind of saved them for last this one is the card and all the card is is it displays one number or multiple numbers if you want to use a multi-row card but we'll just look at the card for now all we're going to look at is the total purchased and it's just going to display it just like this and you can make it as large or as small as you'd like and normally it goes on like the top and you'll put a card here, a card here just for example, I'll kind of show you how this might look so it looks something like this right and at the top it'll have different usually high overarching information and this is super common to see and I'm sure if you've looked at other people's visualizations you'll see something like this this is usually totals or averages or something like that in here where it's super easy to look at so like right here this is total purchased and we can go in and look at the minimum and then we can go over here and this one can be a count and so it gives us a lot of information just at a really quick glance and then we have all of our more in-depth colorful visualizations that kind of have more information than just a single piece like the card does and then the very last one that I'm going to show you is this one right here which is the table and this one is obviously extremely popular it's like in a little Excel table and we can go in here and we can get the customer wherever that is and then we'll also get the unit sold and this is what it looks like and it's super easy and oftentimes you'll have it like on the side as well and all the other visualizations over here and so if we're gonna take all these visualizations and pretend they were like a real thing there's a lot in here but we'll just kind of really quickly do this and we might have something like this and we'll make this larger and make this wider and we have a lot of information just in here and this is not a project so don't go put this on your portfolio I'm just through a ton of random visualizations on this dashboard but you can already see a lot of these you most likely have seen in other people's work and other people's visualizations on LinkedIn or on YouTube these are very common, very, very popular and again we did not go through all of the ones over here there are maps that you can use but I haven't used maps ever in my job there are things like gauges and decomposition trees and waterfall charts and tree maps and all these different things but I really have never used those in my actual job and I don't see them a lot in others people's work either otherwise I would be telling you to learn these and use these but again, try them out, see which ones you like if you like this video be sure to like and subscribe below and go check out all the other Power BI tutorial videos that I have on my channel and I will see you in the next video.