Creating a Customer Segmentation Dashboard

Learn more from the full course
Power BI A-Z: Hands-On Power BI Training For Data Science!
Learn Microsoft Power BI for Data Science and Data Analytics. Build visualizations and BI reports with Power BI Desktop
04:19:57 of on-demand video • Updated November 2023
Connect Microsoft Power BI to data sources
Create Barcharts
Create Treemaps
Create Donut Charts
Create Waterfall Diagrams
Create Piecharts
English [Auto]
Hello and welcome back to the Course on Power BI. In today's tutorial, we're going to finally create our business intelligence report. In fact, it's going to be an interactive business intelligence report. So we're going to put together these five elements that we've created in the previous tutorials. We've created a map with an indicator or with a card at the top. We've created a pie chart for gender. We've created a distribution for age, a distribution for balance, and we've created a tree map for job classification. So let's go ahead and create our BI report. All right, so how are we going to put them together? So the beauty of, um. Power BI is that we can just simply copy these, um, visualizations onto a new page. So I'm going to select this, hold down control, select this, then press control C on my keyboard, press control V, and it'll be copied over and they're completely independent. So if I change this one, this one won't change and the other way around. So basically, if I want to make changes here, I'm free to do so and I will always have this backup over here. And also, don't forget to save your work by pressing Ctrl s here. We've got gender. I'm going to copy that as well. Put it here somewhere. Um, then we've got the age distribution. Copy that as well. Put it here. We'll adjust all of this in a second. Then we've got balance. Copy it here. So this is the beauty of preparing everything in advance. There is minimal problems further down. You just need to copy these things. All right, so all of that has been copied. Now it's about putting it all together so it looks very nice on one sheet. And also take into account the size of the screens that you want to prepare this for. And, um, if these reports are going to be viewed on, uh, desktop, on mobile or uh, or if they're going to be viewed on desktop screens or laptops or power BI is also available for iPads. So maybe if people or the executives are going to be viewing this report on iPads, you might want to make this canvas a little bit smaller or something like that. So it's about experimentation and testing these things out. But now at this stage, what we want to do is we want to actually, um, first of all, just we're going to use this size canvas and we're going to line up everything. Now you'll notice that it's a bit hard to line things up because they're kind of like free flowing. There's no, there's no grid lines, no guidelines here. And also, you may have noticed that throughout this section I have a new tab at the top, which is called View. Now, this is something new in one of the later versions of Power BI, maybe in your version. So if you're watching this video even later, it might be here by default. But if you don't have it right now, then what you can do is you can click this dropdown, go into options, go into options here and here. Just go down to updates, not updates. Go into preview features. And here it says the following features are available for you to try in this release. Preview features might change or be removed in future releases. So for now we have the ability to enable grid lines and snap to grid. So go ahead and check this box. Click. Okay, you might have to restart Power BI to do that. So just save your work, restart and come back to this visualization and then you'll be able to show grid lines so you can see these grid lines up here at the back of your canvas and also you can snap objects to grid that will allow you to have more control of. So less freedom, but at the same time more control of how you're placing these visualizations so that they are actually lined up very nicely. All right. So now it's very easy to tell the width that you want. For example, here, you might want to snap it to that level and then to this one as well, to that level, the same thing. And then you can maybe increase it up to there. All right. And then this one goes in here very nicely. It's very easy to, uh, line them up like this when you have, uh, these grid lines over there. So now, again, let's line this one up. Scroll down. Let's see. Up to where maybe this one should be a bit higher, I think. Uh huh. That's good. As you can see, the percentage is lined up very nicely over here. Uh, then. Let's take this and line it up. Up over here. It does take some work, some manual editing, but it's going to be worth it in the end. So maybe this needs to go up to the same level as this. Yep. And finally. The final chart goes into. One up. There we go. All right. So our visualization is pretty much ready. The last things that we would like to probably change are these labels and the colors. So let's start with region and region here. So if we go here, we we want to keep the legend. We don't want to keep the title and same thing here. So here, um, do we want to keep the title? We we do, but we don't want, we want to change it. So we would say, uh, distribution by age and then here also make it a more intuitive title. We'll call it, uh, distribution by balance. This one title, we'll call it, um, job classification. And here, uh, we'll call this one, uh, gender. All right, so that's our title. And in terms of colors, even though we worked on the colors as we were creating these individual, uh, pages, and they seem to be okay in this case, it doesn't look like the colors work well together. And you can tell just by looking at it that this is a bit bit stands out, this stands out, and maybe some of the colors here are not ideal. So I suggest the following approach. I'm going to end this tutorial now and I'm going to play around with the colors on my side and then you'll see the final result, the colors I pick in the next tutorial. Whereas you can also do that. You can also try to fix up your colors, or you can just proceed to the next tutorial and see the ones I use. It just takes some time and usually it's quite a lengthy process picking up out the colors and I wouldn't want to make you wait through this painful exercise. So on that note, I'm going to end this tutorial. I look forward to seeing you next time. And until then, happy analyzing.