Creating a Customer Segmentation Dashboard

Kirill Eremenko
A free video tutorial from Kirill Eremenko
Data Scientist
4.6 instructor rating • 59 courses • 2,014,455 students

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:21:06 of on-demand video • Updated January 2022

  • 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 Buy. 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 of a card at the top. We've created a pie chart for gender. We've created a distribution for H, a distribution for balance. And we've created a tree map for job classification. So let's go ahead and create our B.I report. All right. So how are we going to put them together? So the beauty of. Harbi is that we can just simply copy these, um, visualisations onto a new page, so I'm just like this hold on controls like this, then you'll see on my keyboard press control the and will be copied over and they're completely independent. So if I change this one, uh, this one will 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 back up over here. And also, don't forget to save your work by pressing control. S. Here we've got gender going to copy that as well. Put it here somewhere, then we've got the age distribution. Copy that as well. Put it here. Will it. Just all of this in a second that 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 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 screen that you want to prepare this for. And if these reports are going to be viewed on a desktop or mobile or, uh, or if they're going to be viewed on desktop screens or laptops or PABI is also available for iPad. 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 of what we want to do is we want to actually, um, uh, first of all, just use this size canvas and we're going to line up everything. Now, you'll notice that it's a bit hard to lighten 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 the 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 PABI. I 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's here's 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 great grid lines and snap to grid. So go ahead and check this box. Click OK, you might have to restart power by to do that. So just save your work, restart and come back to this visualisation 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 there 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 and very nicely. It's very easy to, uh, line them up like this when you have these grid lines over there. So now, again, let's load this one up. Scroll down. And see up to where maybe this one should be a bit higher, I think. Uh huh, that's good, and you can see the percentages 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. There we go. All right, so obviously, Zeshan 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 a region and region here. So we go here. We we want to keep the legend. We don't want to keep the title and the same thing here. So here, um, do we want to keep the title? We we do, but we don't. We want to change it. So it's a distribution by age. And then here also make it a more intuitive title. We'll call it, uh, distribution by balance. This one title, I will call it, um, job classification. And here. Uh, we'll call this one gender. All right, so that's our total and in terms of colors, even though we worked on the colors as we were creating these individual pages and they seem to be OK 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 which 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 used. It just takes some time and usually it's quite a lengthy process picking up all 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 next time and until then, happy analyzing.