Transcription
Hey guys, welcome to the second part of the video. So till now, what we have designed in part one, that is, we have already designed this banner. That is, we have designed these KPIs, uh, and we have also designed the sparklines. We have also designed the minimum and maximum, whatever we can see here, uh, the points of that particular month in that particular year. So now, what in this, uh, dashboard or in this part of the video, we will be starting with, uh, developing our dashboard. So whatever we have developed, all the elements, we will try to bring that into the dashboard simultaneously, and then we will proceed with our other designs. Okay? So I will open my sheet. So we have designed till here. And one more thing which was remaining, guys, was, uh, to design our tooltip. All right? So, uh, I request you to follow the same procedure which we have done before, and you can design your tooltip by following the same procedure which we have designed for sales and profit sparkline. So I will not waste much time on that, and I will take a new dashboard and I will name it as Sales Dashboard. Okay? All right. And for here, what I will do will be using my own pixel size. That is, on what we can say, the size of my dashboard, depending upon your resolution or your screen resolution, which laptop, for which system you are using, you can use any, any screen resolution you want, whichever is, uh, what we can say, fitting in your window or your screen size. So I will be using custom one. So the width I will be using is 1600 for me, and I will be using a height as 900. Okay? So this is a perfect fit for me, and I find it very much suitable for my visualization. So this is what I will be using. Uh, the next thing, uh, what I will do is I will bring a horizontal container. Okay? I've brought a horizontal container, you can see. And next, I will add an image to that. Right? But before doing, uh, uh, whatever the background which we have set, uh, to the dashboard, if you can see here, uh, the background we have already designed, and that has been designed in PowerPoint. So I will open my PowerPoint. All right? So here you can see, I've already designed this background, uh, by using different, uh, what we can say, colors and different images and different shapes. All right? So, uh, what I will do, I will make a separate video how to design a background, and it will be helpful for you as well to design your own custom background. So you can see here, I have different background colors which I have used here. So this is a white background which we will be using, and this is the background which we will be using for, uh, right now, the dark background. So now I will be sharing this PPT into our description, uh, or the link for you to download in the description box of this video, and from there you can download it and you can use it your design. So what we have to do is, how you can save this? So what you have to go, you have to go in files. All right? And you have to click on save as. Okay? So after clicking on save as, you can save it anywhere you want. So I will click on desktop, and then you have to click on JPEG format. So you have to save it in the form of image. So when you click on save, it will ask you to save only this particular slide or you have to save all the slides. So you have to click on this particular thing. So now I have already saved, I will not repeat my procedure again. So I will go back and I have everything again saved in my folder. So I will open that one second. We'll go in desktop, and I have my file saved here. All right? So you can see, I've already saved this in the form of image, and this I will be using in our dashboard for it. So just bring here. And now what I will do, this is my dashboard. I have already added a horizontal container. Then you have to take an image over here. Make sure it is a child one, and I will put it over here. All right? Then it will ask you, uh, I will ask to fit and center the image, and I will choose the image which we are using, and this is the image we will be using. Click on open, apply. Okay? All right. So you can see our image has been perfectly, what we can say, resized with our that particular horizontal container, and it is being taken, ticking all the screen which we need for our visualization. All right? So now, first thing, what we will do, we will add the title for our dashboard. So for title, now it is a tiled one. So now we will be adding our all our floating objects. I will click on floating, and I will click on text, and I will bring it here, and our dashboard name is sales, uh, sales, what? Let me check if it is Sales Dashboard Overview. Sales Dashboard. When I add a pipe operator over here, Overview. All right? So I will make it as a Tableau fold, and I will make it first 26, and I will use, uh, this color as of color for me. I will click on OK. Just let's increase the size. I will reduce it vertically, and I will place it over here. All right? So this is our name of our dashboard. Well, it's perfect. So it is looking good. So I will just take it a little down so it is centering our this particular element. The next thing, what we will start adding our elements over here. So I will show you how first element I am adding. For the rest of the element, I will just fast forward my video, and you can follow the same procedure which we have done it for the first one. All right? So now, next thing, what we have to do, we have to take a horizontal container and make sure your and floating selected. So I will take a horizontal container and I will place it over here. All right? So make sure you are adjusting this in this particular size itself. So, okay? So make sure you are making a perfect fit, whatever the shapes we have in our background. All right? So we have a horizontal container. Then next, what we will do, we will take a sales KPI. Okay? Now, to put this sales KPI into this horizontal container, I will make it tiled again. Okay? So make sure you are making tiled again, and now I will take and place it into this container. Okay? So you can see this has been placed. So now we have a title over here. So I will just hide this title. All right? So everything, it has a quite the entire area of this particular thing. Next, what we have to take, we have to take a sales sparkline. Okay? Make sure it is tiled again. Okay? So I will take again the sales sparkline and I will put it into this container forward the right. Okay? You can see this great region is there, so it is added towards the right side. Got it? Then we don't want this particular label, so we will be deleting that for it. And then I will just hide the title for this as well, and make sure it is showing the values perfectly. All right? So this has been added, guys. Okay? So this is looking nice. So now, just we will do some quick formattings over here. So I will just right-click and I will choose format. So whatever the sheet color which we are having for this particular sheet, we will go into shading. Okay? So we have to go into shading and you have to use your none. Okay? So when I click outside, you can see, uh, so let's go for sheet. You have to say none. So you can see the color has been gone. Similarly, I will click on this sheet. Similarly, in shading, and I will say none. Okay? So you can see both the colors have been gone. So now, one thing which is remaining here, like we have chosen the black color for this, but it is not looking nice on that for this 746 value, that is sales value. So we will go into that sheet and we will change the color for this. Okay? So we will go in text and we will change the color, and we will choose it as this one. Okay? So great out region, like this one. Apply. Okay? Okay? So then we will go again to our dashboard, and you can see it is looking nice. Uh, and the next thing, what we will do, we will get rid of all these for orders, all these grid lines over here. Okay? So I will just click on format. And the next thing, what we will do here is, uh, it is go into our borders, and just we can say we can, uh, delete all this border, or we will say just we don't want any border. So we will say none to everything. So we still have some of the grid lines. So you have to go in this particular lines and say none to everything. Okay?
So now you can see, uh, our chart looks perfectly fine. If we have all the values, we have everything. Okay? So we will start with the designing of the second ones. So I will click on floating again and take the horizontal dashboard over here. Sorry, the horizontal tiled container. So remember that whenever we are dragging the horizontal one, you should know that it should be in floating. So now I will fast forward everything. So we have placed all the sales KPIs, uh, the profit KPIs, and all the sparklines over here, and you can see the tooltips are also looking good, and they are perfectly in, you know, giving some, uh, the insights to the customer or to the user of this particular dashboard. And you can see the trend of this particular current year. You can see it is highlighted. So the current year should be highlighted, and so we can see the previous year should be grayed out somewhat, so that, you know, it will be easy for us to understand. The next thing, what we have to do is, guys, we have to add, uh, what we can see, a line over here which will be indicating, uh, like the information about what is, uh, where in this particular KPIs or this particular card, and we will also mention the legend in that itself. All right? So what I will do, I will just copy the things which we have already here. So I will just copy this, and you can just, you know, pause the video and you can type the same, what we are using here. And let me check. So whatever you have to do, you have to take the text and make sure it is floating. So you have to take floating, and you have to press Ctrl V. So what for now, what I will do, I will put everything in black color, and I will show you how we are going to put the colors. And first thing that whatever we are showing, it is in Arial font. This is in Arial font, and the font is nine. And if you can see for important things, like important text, like numbers, we are using Arial font, but it is in bold, right? So you can do that. And the shapes which we have added here, this dot, you can find it in Excel, right? Which we have taken the shapes of up and down arrow, the same will be available in Excel, and you can copy from that and you can use here. All right? So you can pause the video and you can type this into your editor, like Xbox. So now we have to give the colors over here. So whatever the colors which we will be using for this, so if for this, we will go into more colors, and now the color which we will be using is, uh, we we already have the document with us. So for current year, we are using this color, right? So for current year, this is Ctrl C. So I will paste it over here, Ctrl V, and just click on OK. Similarly for this also, we have color. So we will go in more colors, and here we have it as this one. So I'll just Ctrl C and Ctrl V. Okay, perfect. Then, uh, for the maximum month, is nothing but this is, uh, this values, that is, we are showing what, which pointer shows the maximum, which shows the minimum. So for that also, we have already, uh, this thing. So the maximum one is this. I will just copy this. So press Ctrl C, and we will go in more colors, and we will press this here, Ctrl V. Click on OK. Similarly for this is minimum. Ctrl C, uh, we will change it for minimum as well. Ctrl V. Ctrl copy and okay. Make sure you don't take an extra space over here, because it is not taking characters more than, I think, I think there are seven characters. Okay? So click on OK. Okay, perfect. So you can see the text has been added. We will just make whatever other things are in black, we will make it in white. So this should be white, as well as this should be in white color. So we will make this as well. We will make this. So this will be white, and this has been white. Got it? Your own year change should be also in white color. If similarly for this also, we have to change the color. So we'll go in more colors. Uh, one more way to choose the color is, we can we can choose it from screen as well. So if I click on quick from screen, and we know this is the year on your color. So just click on that. Okay? And it will click on OK and OK. Perfect. So the year, we have mentioned all the colors, and now we will go here and we will place it here. All right? So this was what, uh, how we are mentioning and using our KPI. So this is for 2022, 2021, minimum, maximum, and your own year change colors. All right? Okay? So next, we will be designing our, uh, map chart, and if we can see into our, uh, this dashboard, this snapshot, we will be designing. So this is a custom map. So we will see how to design it. So for that, what I will do, I will take a new sheet, and to prepare this map, guys, we will be taking a custom, uh, hex file, which will be an external file, and we will be using that to modify our data source. So for that file, uh, that that file, I've already added, uh, the link for you to download in the description box. So its name with the hex file, so you can download from there and you can use to change your data source. I will come in my data source. So this is the logical layer. So we have to go double-click and go to the physical layer. So here we will be adding our data for what we can say, the table. So here we will be adding a data source. I will click on ADD. I will click on micro of Excel, and we have this file here, that is a hex map. So I will just click on OK, and you can see that sheet has been added over here. So just we have to go ahead and we have to change our, uh, joints. Okay? So if Tableau is not able to identify the joints, it will give an error for us. So we will be having, or we will, we have to enter the manually the joining clause. So it will be on State, State, Probins, and here also we have a state column. Okay? So we have used this, and we will be using an inner join for this. All right? We have already added. So now we will go in our sheet, and once we have joined it for inner, we can see that all the data which we will be having will be only for us. Okay? Why? Because the data which will be there in this particular sheet. So let me show you in the data source. So whatever the data which we have in this particular sheet is everything is for us, right? And the data which we have for the superstore, since it is having the some data for Canada also, right? So we will be changing our data source with respect to that. All right? So you will be noticing some values will be changed for sales because we are using an inner join, and some data will be lost. And so we are more focused to do us only. So I have not initially applied any filter over here, like for country, because eventually whenever you are going to use this particular sheet, we will be so much of restricting towards inner join. So inner join takes the matching data from both the tables, and we will be only having the US data, right? And the Canada data will be, what we can say, neglected because we don't have matching numbers for that or the matching values in the second sheet. So this is what we will be doing. And the next thing, what we have to do is, the second table which we have added here, or the sheet, you can see, we can see there are two measures, that is rows and columns. So first, I will go ahead and convert them to discrete. So just right-click, and I will change the, uh, node to discrete. Okay? So here also, I will convert to discrete, and then I will bring the columns in here, and and the rows. So before that, what we will do, once converted to screen, convert into dimension as well, right? So we will just convert this to dimension. Okay? Once they have converted into dimension, then bring them into rows, uh, column into column, and rows into quotes, and we will click on entire view. All right? And now here, you go ahead and make it continuous. Okay? All right? In visualization, we will go ahead and make it into continuous, but in data source, it should be dimension only. Why? Because if we, if they are continuous field, when we bring them into visualization, it will by default go into an aggregation, and we will be not able to visualize what we want to, right? So now we can see this is inverted. Right now, uh, the map is inverted. So to change it, so I will just click and edit the axis, and I will make it reversed. Okay? So now we can see it is looking perfectly fine. So now I will just, uh, what, what we can do here is, uh, we will change this to solid circles. Okay? So you can see this is the solid circles, and next, what we want to visualize is, we want to visualize the total current year sales with respect to total current year profit. So I will take the total current year sales and I will put it on size. Okay? So you can see the size has been increased, and for now, we'll keep the same size, whatever we have right now here. And next thing, what we have to add is, we have to add a profit tooltip. So first, what we will do, I will create one more instance of this column. So I will just press Ctrl and I will bring it near to it, and we can see one more axis has been created in this marks card. We can see there is one more marks card has been created. So in this particular marks card, we will go into the second one, and we will bring, remove the sales from here, and we will make it as shape, and from shape, we will choose it as a circle. Okay? It should be a circle. Now we will take total, uh, current year profit. So it's here, and we will put it into size. All right? And we will just go ahead and increase the size it somewhat for this level. Okay? So you can see it has been increased. The next thing, what we will be doing is, we will go ahead and make it as a dual axis. All right? So we have made this a dual axis chart, and now we have to synchronize this axis. So I will just click here and I will synchronize this. Okay? So remember, you have to synchronize the axis. It is very much important. Right? So we can see the perfectly matching figures are there, and then I will just go ahead and unhide these axises, this as well. Okay? So now, what we, what we need to do is, uh, we need to label these as well, as we need to modify our tooltip, and we need to give the colors to this as well. Okay? So we will go in all, and we will give the color same for everyone. So we will just take total current year profit from here, not profit sales, and we will put it into colors. All right? And now we will be using our own custom colors. I will just double-click over here, and we will be using a step five, five colors, and but it will be a custom diverging. So the color which we will be using for minimum value is, uh, we already have word document for this. So this is the color which we will be using, and this is the first, which is before minimum. So I will just copy this, and we will paste it over here. Click on OK. And for maximum, we'll be using this. Ctrl C, and Ctrl V. Okay? Apply. Okay? All right? So now you can see from this that this particular state, that is, uh, we can see this, we are not knowing which state this is. So far, for us to know, what we will do, we will take, uh, the state abbreviation. Okay? The state abbreviation, and we will put it into label. Okay? And so we have put it into all marks card, so it is giving the label twice. So we will remove it from here. Okay? And we will just keep it into the column second. So now we can see, uh, these are the states. We can see the California is the maximum sales which we have occurred in the mega, or you can say called California state, as well as we have got good amount of profit from there as well. Then we have the on second number is the New York, right? And then we can buy colors, we can see, and by sizes, we can measure like which is the high performing country, which is the low performing country. All right? So now, what we can do is, uh, I will just quickly rename the chart name first. So this is what on sales and profit by state. All right? So now, next thing, what we will be doing, uh, I will just modify our labels properly. So in the second marks card, I will just change the alignment on top, and we will, so change the color as well. So we will make it as 8, and we will use the context area. Okay? So we will be using an Arial font, and the next thing, what we will be doing here is, we will try to change the color of this. Okay? So we will use this. Apply. Okay? All right? So we can see, uh, the chart is almost completed. Now, next thing, what we have to just do is, we have to modify our tooltip. Okay? So we will just off the tooltip for, uh, the all the other marks card. We'll just stop it from this. We will off it from here as well, and we will just show everything same for all. Right? So we will go here. If we don't want to show here this Audits, and we will just go back, and instead of abbreviation, we will show our states. Okay? And to show the state, what we have to do, we will just click on OK. So, uh, we have a state and Province here, and okay, just find it. State and Province, and we will put it into tooltip. Okay? And now we will modify our tooltip again. So we will just take State and Province here, and we will name the state, hold it. So now select everything and make it as Tableau semi-bold font is nine, and color as this. Okay? Perfect. So now you can see tooltip has been modified correctly, and we can see which, what is the state, and which is what are the current year sales and the current year profit. Right? So now, next thing, what we will do, uh, I will just format this chart quickly, and, uh, we will just remove all the, uh, what we can say, the sheet lines which we have here. So we will remove everything, and also we will remove all the grid lines. We don't want those as well. We want everything clean. So we have designed the sales and profit by state, and the next, which we will be designing is, uh, we can see these two small custom maps, and for that, what we will do, we will go ahead and take a new sheet over here, and it will name it as favorite sales by street. All right? And for this, again, we will be taking, uh, columns from the sheet which we have added as a new for table into our data source. I will take column, uh, into columns, and we will take rows into our roads, and we will make it as entire view, and same, we will again convert it into continuous. Okay? And we will just reverse this axis. All right? It's perfect. So this is what we want, and next, we will convert the event to circle. All right? So now we want to find out the states which are below the average sale of overall states, and which are the states, uh, which are above average of overall average of, uh, we can see United States, right? So now, for that, I will write a calculation, and so let's write a calculation for that. So first, we will name it as average sales street wise. Okay? So we want to determine, uh, the statewide average sales, like for each state, what is the average sale, right? So for we will be writing for that of fixed LOD. So I will write a fixed, and I will name it as state, and we will be writing it on dimension of state, because we want state wise, so we will take a level of detail at state, and then we will take average, because we want between aggregation as an average, and we want to find it for current year, that is for total current year sales. All right? So this is our, uh, average for this particular states, and then we will click on OK, and we will have to write one more calculation which will be giving us the overall average of this particular United States, that is, overall average at data source level. So I will name it as average sales. Okay? Overall. All right? And then for this, again, we will be using and fix LOD. So I will write a fixed, right? But we will be not mentioning any dimension over here. Previously, we mentioned a state, but for this, we want it at total US level, or at portal data set level, or total country level, right? So, uh, instead of, we can use your country, but obviously we are excluding our, uh, Canada, so we can use the country that is which will be at US by default. But if it, if you're not writing that is also fine, because it will be a total data source level, right? And we will be using again aggregation as this, and I will writing a if condition for here, because we want it for only current year, right? So if year of order date is equal to, if year of order date is equal to maximum for here, again, I will mention flexibility, maximum year of order date. Okay? And then we will close this bracket, uh, for node, then we want total current year sales. Okay? And we want to close this curly braces over here for maximum. Okay? So this is for this particular, uh, what we can see, or the maximum LOD, which we are using here to find out the maximum year, then we want the total current year sales, and we want to close our this parenthesis for if. So I will just close this, and before that, we have to write end here, and then we will close this parenthesis. Well, let's, you can see our calculation is valid. I will just click on OK. So now I will show you how exactly we have written this calculation. So let's take a new sheet, and I will show you in the sheet and explain you why we have written it. So I will stick state, and we have all these states right now. Okay? And now, if I take average sales overall, and if I show you, overall sales is nothing but whatever calculation we have written here is, we have write written it as a data source level, right? So you can see it is giving us all the values over here, right? So it is giving all the values for that particular state, the same, right? Because it is overall level, right? So it will be same for all the states, because it is a data source level. But when we take this calculation, so you can see it is giving a statewise average calculations, right? So these are statewide. So we want to find which states are below average, and which states are above average, right? So now, to find out, what we will do, we will go again back over this sheet, and we will write one more calculation here, and we will name it as, and we want to give it the color with respect to that. So what I will do, I will name this as a sales average, and name it as color, right? Because we will be using a color for that, and I will write a condition here. If our average sales by state, okay, average sales by state, if this is less than average of overall, okay, if it is less than average, then what we can say, it is a below average, right? So, and we will name it as Bill average. All right? Then similarly, else if, and I will name it as, else if average sales statewise, if it is greater than average sales, like the overall average sales, then we say it is above average. Else if, if both are equal, right? So I will just copy this. If this, these both are equal, that is, average sale and, uh, the sales overall sales is equal, then we will say that is equal to average, right? And then we can add this. All right? So we have, we have written our calculation. I will just click OK, and I will bring it into colors. Right? So we have got, uh, our average, uh, above average, until average sales, and we want to also format our tooltip. So what I will take, uh, we will go ahead and take state. I will just find state, and we will break into tooltip. All right? And we can see which state is above average, and which state is will average, right? So now, what we have to do is, uh, we have to change our color. So before that, I will just increase the size little bit for here, and we will be changing the color. So we have already a color code here. So for average sales, we will be using this, and this will be the color code for above average. I will just double-click over here, double-click over here, and we will change this. Okay? Apply. Okay? Similarly for below average, we will be using this, and we will change it. Ctrl V. Okay? Apply. Later. So now we will neglect this, uh, null values. Why? Because there are some states which don't have the current year sales, but we will not delete those, we will not exclude, but we will keep it into visualization. But, uh, there are only two states which don't have current year sales, right? So that is why it is giving us a null value. All right? So now we will modify our tooltip as well. So we don't want, uh, the rows and this, this thing. So I will just delete that, and we want, uh, state. Ctrl X. So we want state first. So I'll just enter it, and I will paste it over here, and we will make it as a 9, and we will make it as W semi-bold, and we will change the color for this. Okay? Perfect. So now you can see Washington above average, and this is what we can see. So we will modify some more. So we will remove this. We will just show the, like whether it is above or below average. All right? So, uh, state, this state is above average, this state is above average, this state is above average. You can say this is Bill average, right? So likewise. All right? So then we will just do formatting. We will remove this. We will remove this, and we will also hide our title, and we will format our chart, and we will remove all the lines which are present here. Okay? We will hide the grid lines as well for next super effect. So this chart has been prepared. Find the average profit by state. We will take a new sheet. So first, I will copy this name. Or yeah, so I will just instead of this, I will just duplicate this, and we can just change it over here itself, and we will name it as profit. All right? So this is by profit. So just we have to change our calculations over here, and what we can do is, uh, first, whatever average overall sales we have, just we will duplicate that, and we will edit this, and we will just name, instead of sales, we will be taking your profit, and I will just click on OK. Similarly, I will just rename the name of this first. So it is a profit, and we will remove this. Okay? Similarly, we will just duplicate this, edit, and here as well, instead of sales, we will take a profit. Hold it, and we will change the name here. Perfect. So you just click on OK, and one more thing, we have to edit this calculation available. So I will just duplicate this, and I will edit it, and we will change the name as profit average color, and we will remove this. So instead of average sales, what we will be using here, average profit. Got it? So this is profits, and this is what sales, that is, instead of here, we will be using profit, that is, overall. All right? So I will just copy this. Ctrl C. So I'll just paste it over here. Will be, and it should be greater than. Similarly, here will be, and it should be is equal to. Same logic, just we have to change the measures. And I'll just click on OK. So instead of sales color, uh, so we will be using an average profit color, right? So this is profit average scale. I will put, and I will replace this. Right? So this has been replaced. Just what we have to do is, uh, we will have to, uh, what we can say, change the colors here, right? So I will just change the color for profit here, and we have a document for that. So if it is above average, we will be using this color. So Ctrl C, and I will just rename this. Ctrl V. And for Bill average, we will be using this color. So we'll see, and we will change it over here. Ctrl V. Okay? Perfect. So this is what we have done. Now we will change the tooltip as well immediately, and we will be using the profit color. Okay? So you can see above average, Bill average. All right? So this is what we have created our custom maps. Now, what we will do, we will start bringing them to the visualization. All right? So we will go into our dashboard, and first thing, I mean, look for it is a floating, and we will bring the first map which we have here, and we will just increase its size. So for now, we will just take this a little away for it, and we will hide our title, and we will just try to fit it over here. Okay? So it's looking good. So now, next thing, what I will do, I will just format this, and so we will just say none. Hold it. So you can see, uh, this is what we wanted. So I will just make it a little down. We'll just increase this, and we will place our, uh, legends as well over here. So just reduce this, this as well. We will increase this, and we will reduce this as well. Similarly, this. All right? So we have placed our legends as well, and we will quickly format our legends. So I will just click on format legends. So whatever the names which will be there, we will be using a font as Arial to this, and we will name it as Arial, and we will be using in this colors, right? Or we can use this for it. And the body which we have, the body should be also in Arial font, right? And we will make it as eight, and, uh, the shading, uh, or the color, we will be using as this. We can use this. All right? Perfect. Okay? So we have used our legends as well over here. So just look for this. Perfect. Yeah. So instead of this, we will just reduce some more further. All right? This looks fine folder. So you can see, uh, we have already, uh, posted our map over here. The next thing, what we have to do is, we have to add our other charts, right? So we will give the names to this as well. So to title, what we can do, we can fix a text, and we will bring it over here, and we will name it as Sales and Profit by State. Okay? And we can change it to 11, and I will be using Arial font again over here. So I'll be using Arial, and I will be using it as bold, and we will be using as this color for this. Okay? And we will name it our review sit over here. Got it? So if you can see to our other dashboard, one second. Okay? So it is in Sales and Profit Distribution by State. So we'll just rename it. Okay? And just increase the size solid. So now, next thing, what we will do, we will start placing our, uh, the other two small charts, that is, for, uh, this, the average sales by profit and sales, right? So we will just take it and we will bring it over here, and we will hide the title, and I will just reduce the size. So we don't want the legend over here, so we'll just delete that. Perfect. Pull it. So similarly, we will take this as well, and we'll bring it over here, and we will hide the title for this as well. Okay? So we'll just reduce some more. So if we can go in layout, so the bit of this is 300. I will make it as 300, and height I will make it as 190. Similarly for this, width I will make it as 300, and height will be 90. Okay? So both will be having the same height, and just bring it over here. Perfect. So now we will just quickly format this, and I will go in here, and I will say, uh, for this as a none. Similarly for this also, shading, I will say it as perfect. So we just want to remove the lines from here. So we have to remove it from here. So we have to see none, none here. It is axis, none as well, in rows or in sheets, say everything has none. All right? And similarly here as well, axis ruler, we can change it as well. So now we can see our charts are clean. So we will just delete this as well, and now what we have to do is, we will give the names to this, right? So this name. So I will just copy this first. I'll just copy Ctrl C, and here what we have to do, you can pause and you can write the names, guys. So I will just bring a text over here, and I will just paste it over here, and you can see it is Arial, and it is a font of 8, right? And I will just click on OK, and I will just try to bring it over here. Perfect. So you can see, guys, uh, the legends are smart enough. Like if it is above, I've already mentioned it in, uh, yellow color, and it is below, if, uh, if it is a in, like we can say, a purple color. So for this, you can go ahead and you from, uh, I will just select this. I will go in more colors, and from this document which we have here already, so you can give the colors like for this is for average sales, and this is for average profit, right? So you can use the colorful for those respective things, and you can get this, right? And for other, other, uh, text, the color which we are using is this, right? So you can note it down. So I will just not, so mention like waste too much time on this. So I will just copy it from here itself. Similarly, I will just copy this, and we can take one more text over here. It will be okay, and I will place it over here. Right? So we have got it. And the next thing, what we want to do is, we want to find this, uh, the portals, right? So this is nothing but, uh, how many states are above, and how many states are below, uh, with respect to, uh, that average. All right? So for that, what we can take, we will take a new sheet. So dashboard, I will take it at last. We have a sheet over here. So I've already explained you. So we will just delete this, and I will use the same sheets. So sales, or we can say average sales by state counter. All right? So for that, we will take our average sales into our rows, right? And I will just make it as circle, call it. And next, we will take again the average sales, and we will put it into colors. So here it is, and we will put it into color. So it will take automatically those colors which have already assigned. And here I will just exclude this. We don't want a null to be shown. Then we will take our state. So I will take state, and state province, and I will put it into labels over here. And instead of labels, what we will do, I will just right-click over here, and I will make it as count. Okay? So we have got our count, but I will make it as distinct count. Okay? So we have got here, and here we will just go ahead and we will unhide the header. Call it. So this is the numbers which we have got, and I will just sort it. So it is maximum is up, and below it is the average, right? So the same we will be doing for, uh, the other, that is, for profit. So I will just rename this, and it will be for profit. So I've duplicated the sheet. All right? So instead of, uh, this average, uh, average call sales average color, we want to be as profit, right? So we will just take and place it over here. All right? And instead of this, we will place it over here. All right? So we have got the state count for this as well, and we will just unhide this as well. All right? So this has been done, and now we will bring this again into our visualization. All right? So this is what we are doing, where we will take this, and first, I will just reduce its size. All right? We will hide the title, and I will select this, and I will make it as entire view. All right? And just we will reduce it somewhat, and I will press it over here. Got it? Similarly for profit also, we will bring it, and we will hide the title, and we will reduce its size. Okay? Similarly, I will make it an interview. Perfect. And we will just format this. We will go into this, and we will say none. All right? Similarly for here, we will go and we will see now. Pull it. And now the text we have to make it in, uh, what we can see, in white color. So I will just go ahead and select a state, that is, count, and we will make it in white color. This is good, and we will make it again an Arial color, Arial font. We'll be choosing an Arial font here, and it will be a bold, right? Similarly for this as well, we will choose this color, and we will make it as Arial and bold. All right? So this is Arial. So this should be also Arial. Okay? Perfect. And now we want to remove this top two lines. So we will just go in sheets, and we will say none. Okay? For all the lines, right? Similarly for this, we will go ahead and we will see none. Perfect. So this is clean, and we will just adjust it with respect to the respective maps, and if we just increase its side a little somewhat, a little bit. Perfect. And we will take this to the center. This as well. Perfect. And we will just delete this. We will see it. Perfect. So we can see, guys, almost 70 percent, 70 to 75 percent of dashboard is already completed. The next, what we have to do is, we have to draw area chart, and some, what we can see, a bubble chart, and a bar chart, which will be representing the region-wise sales, and then we have to add our filters panel, then we have to add a dashboard which will be with the white background as well. All right? So at this was for part two. For part three, I will make another video, and I will add you well the link for that in the description box. So for now, till now, if you have learned something, so go ahead and like the channel, uh, like the video as well, and, uh, subscribe the channel, and share it to your friends. Thank you, guys. See you in the next one.