Transcription
Hey guys, welcome back to my channel. So, in today's video, we will see the design and development of this beautiful dashboard from start to end in Tableau Software. So, our today's topic is credit card complaints dashboard. So, we will see the design and development of this beautiful dashboard from start to end, and you can practice the same in your system as well.
All right, so now the data which we will be using for designing of this particular dashboard, it is a dummy data. We are not using any original data or any real-time data of any of the credit card company or any of the banking domains. So, this data is generated just for practice purpose and it does not relate to any of the company.
All right, so you can see there are different different charts present on this particular dashboard, different panels are present. So, we will see how these are operated. First, how we operate the dashboard first, and it is completely interactive and dynamic. So, I will show you how it is dynamic and how it is interactive as well.
All right, so here you can see there are different KPIs, different charts are there, different export panels are there, different filter panels are there. So, I will show you how it is dynamic first. So, I will show you how it is operated by using an action filter. So, here we have an issue-wise chart. Is there whenever I'm clicking on any of the issues, you can see it is changing dynamically with respect to that particular issue, right? So, this is one interactive or action filter, we can say. By then, we have a company response-wise also. When I'm clicking on this, you can see it is changing with respect to that.
All right, then if we have some quick filters here, a year filter, right? With respect to this also, our data is changing. All right.
So, now you can see on each of these particular charts, there are some individual filters I have applied for that particular chart. So, you can see this is a weekly trend of that particular credit card company, and we have added up on average, like this is the weekly average, one reference line or we can say a trend line which is there. Not a trend line, we can say a reference line, and we have shown the maximum minimum points here. So, if we want to see monthly, you can see monthly. If we want to see weekly, then if you want to see the quarterly trend, then we have this filter. Then we have a yearly trend filter also. We can see how the complaints are coming daily. All right, so this is one filter which we have applied here.
Then we have a state-wise complaint. So, in state-wise complaints, if you can see, we have shown here a density map. So, wherever there is a dense color, is there, we can say the more number of data is present in that particular states or more number of complaints are coming from that vertical states. We will see the design of this, but I have added one more filter over here. You can see, if a user wants to see a density map and he also wants to see a field map, right? So, whenever I'm clicking on field map, you can see a field map will be displayed. Whenever I'm clicking on density map, you can see a density map is displayed. So, this is a, we can say, a sheet scrapping parameter which you will be learning in this particular dashboard.
All right, so then you can see there is one calendar over here. Everyone knows a calendar, right? So, for each of the month, how many complaints are coming daily, you can see. So, when I choose a December 2020, the calendar will be displayed for that, and darker the color, darker or what you can say, darker the blue color, more number of complaints in that particular day has been registered. All right, so you can switch in between different different months. You can see how daily the complaints are coming or month-wise the complaints are coming. All right, so this is a filter which we have applied here as well.
Then we have some export panels here. So, it is used to convert into PDF, to image, or into PowerPoint. So, this dashboard will be automatically converted to PDF, image, or PowerPoint. So, whenever clicking on PDF, see, it is asking you whether you want to convert the entire workbook or this particular active dashboard, and you, it is asking you whether you want to convert it into landscape form or any other form. So, when I click on OK, it is asking you where you want to save it, right? So, this is one way where we can convert it into PDF. When I click on image, this total will be converted into a PNG form, and there are different other formats which you can convert it in, right? Then we have a PowerPoint, like it will be converted into a PPT format, right? So, this is one option which we have.
So, this is our, these are some advanced options which we are going to use here for that. So, you can see there are KPIs, and we are showing a rolling 12 months, what we can say, complaints. Rolling 12 months means nothing but the last 12 months, right? So, whenever we go forward one by month, so like right now we are in December, when we go in January, so from January, last 12 months, it should be shown dynamically. Okay, it should be dynamic. Okay. Then we have total complaints and timely response, and then there are some sparklines which are added over to each KPI.
All right, so we will see the design and development of this complete dashboard. Each and everything from small to this beautiful dashboard, everything will be covered in this video. So, I request you all to see the video from start to end, and definitely you will be learning so many basics to advanced things, right? So, all types of calculations are used here. All types of advanced functionalities of Tableau will be done, and it will help you in your daily day-to-day work, as well as if you are a beginner, it will help you to crack so many interviews as well.
All right, so this is what, this is a credit card compliance dashboard. The next thing I will show you the data which we are going to use here. So, this is the data which we will be using. It is in the form of Excel sheets. So, if we can see, there are almost 86,000 or we can say 87,000 rows are there, approximately. And these are number of fields which we have are almost 25 number of columns we are having. So, as I always say, first thing which we have to do is you have to always learn or spend some time on data first, right? So, if you are understanding the data, the granularity of the data from higher level to the lower level, the 60% of your work is completed over there, okay? Right. Another 40% or 30% of work which is shown in the form of visualization, that is just what we can say, whatever you have studied, you have to show it into the visualization. So, spend some time on data, try to learn the data, what at what level of the data is there, right? So, what different columns we are having, how the data is represented, how the data is captured, at what granular level it is captured, right? So, these are important things, right? So, for me, you have already studied the data and I've already prepared the dashboard, right? So, I request you all to study the data and then you can create a dashboard.
All right, and whatever I am doing, it is not necessary that you should replicate or copy the same. Try to innovate something because the data I have used, I have not used all the columns or I have not shown everything in my dashboard. You can make five to six dashboards of this particular data. So, I've just prepared one, and by using the same, you can add or you can prepare some more dashboards as well.
All right, so before wasting time, so we should start our design. So, I will take a new sheet for that. So, let me open. So, this is my new workbook which I have taken. So, we will see from start how we are doing this. So, first, we have to connect to data, and we are using Excel file. So, I will choose Excel file and I will go to desktop, and I have my data in this, right? So, this is my data and I will just open it. Okay. So, the data, I will add a description, a link for you to download in the description box of this video. From there you can go.
So, whenever I'm connecting, so you will get and so the metadata of this particular data, right? So, here you can see what are what number of columns are there, right? And what are their data types, okay? And this is some sample data which will be shown for you. And from here you can see whether all the particular rows and columns are displayed correctly and if the data is populating correctly into Tableau or not, all right? So, this is the first thing which we do, right? So, now we have connected to our data. We have only, we have only one sheet of data. So, we are fortunate enough like we are only dealing with one particular sheet. So, I will make some videos where you will be dealing with multiple number of sheets and where you have to prepare some or you have to apply some joins, you have to join the tables, you have to apply the relationships or a blending, right? So, we will see that part as well. So, now we will go to our sheet and we will start preparing our dashboard product.
So, the first thing which I will prepare is, I will go ahead and prepare this KPIs. Okay, all these KPIs, we will be preparing the first three KPIs and then we have some normal or we can say sub-KPIs also, and then we will prepare this sparklines aspect. Okay, so we will completely design this first strip that is of KPI, we will place it into dashboard and then we will go ahead for this particular other charts. Okay. So, this video will be going to be a bit long because there are so many calculations in what, so many panels are there, so many charts are there which you have to prepare and then also you have to place it into your dashboard which should be visually appealing and it should be easy for a user or for you to operate easily, right?
So, I will go back to my dashboard and we will start preparing our first KPI that is total complaints. Okay, so I will rename the sheet and I will name it as total complaints. Right. Total complaints, if you go in the data source and if you can see the total complaints is nothing but the number of records, right? So, number of records, you have a last column that is the number of records. So, for each record, it is taking the number as one, right? So, this is what a record for each record of one number is taken. So, we can take the sum of this number of records directly into our tab. Right. So, we have this, what we can say, measure is generated, and there are dimensions and measures are here. So, it's nothing but what we can say, Tableau identifies what are categorical values and what are the major values, right? So, categorical are mentioned in terms of dimensions, and those are what expensive facts, those are converted into measures or measurable values.
So, I will take the number of records and I will just put it into the text. So, these are number of total number of records. So, I will go in text and just, we will format this quickly. So, we will make it 26 and we will make it black and we will make it Tableau bold. Apply, okay. And we will make it entire view and we will just change the alignment to center. All right. So, this is what our first KPI.
Then second part which we have to do is we have to find this rolling 12 months record. Sorry. So, first I will show you what is rolling. First, let me name it as rolling 12 months complaints. All right. So, let's discuss first what is meant by rolling 12 months, okay? So, for this particular thing, we will be using a date received date field. So, when I bring it into visualization and let's convert it into month and I will convert it into the script. Okay. So, you can see our, what we can say, the lowest month or the start of the month of this particular data is December, and the latest month which we are having is April 2021, right? So, we are not having a real-time data like where we can use any today function, right? So, today is 25th of December, like today is Christmas, so Merry Christmas to everyone. And we don't have a 2022. It is some what a historical data because this is the terminator, right? So, what our requirement is that we want to find out last 12 months of data. So, if you calculate from last 12 months, so April, March, from April up to, what we can say, from here up to this 12, right? So, you can see these are 12 items. So, up to May, we have to find out what were the number of records, right? So, this is meant by rolling 12 months, and whenever we go from April to, what we can say, June, right? April to May, sorry. When we go from April to May, so it will be calculating from June up to May, so that will be 12 months, right? So, it should be dynamic, right?
So, how to do that? So, for that, what we will do, first, I will be creating a parameter. So, I will show, I will tell you why we are creating this parameter. And I will take it as a maximum date. See, now this parameter I am creating is because I want this value for the last date of this particular date. Right. If we are using or if you are working on real-time data, you can use a today function because today is what, today is the latest day which will be captured automatically by Tableau. But we are working on historical data, so I have to hard code this value into our calculation that is the latest or the last day of April. So, what I can do is I can just write a LOD function here and I will write a maximum of date received and I will close this LOD. Okay. So, this will give us the latest date. And I will click OK. And after that, I will create the parameter here. So, I will create a parameter and I will name it as maximum date received. Right. So, this will be a date value, and we will be taking it from a workbook, right? So, we will be not hard coding here. It will be an automatic value, right? So, I will take it from the one calculation which you have already created, that is maximum date received. Right. So, it is taking as 10 for 2021. It is the maximum value in this particular dashboard for it. So, our last date or the entry of the last date is 10/04/2021. It is automatically capturing from this particular calculation which you wrote a few minutes before, right? So, I will click on OK.
Right, so now we will write our calculation. So, I will write a calculation, create a calculated field, and we will write a rolling 12 months filter. Okay. So, now we will be using a date difference, date diff function. So, date diff, okay? And we will be using a date part. We are using it on month because we want to show it for last 12 months. So, we will be using a date month. And then I will use again one function that is date trunk. And for date trunk, again I will use a date month. So, what does date trunk do? It rankets to the first or we can say first date of that particular month. So, for April, if it is the 10th April, what date trunk will do? It will convert that particular month to the first of April, right? Means, trunkets to the initial of that particular date part, right? And then we want to select the date, right? So, first, which date we will select? We will see it, the date received, okay, which is our normal date in our particular data set, right? And second argument, again, we will take it as date trunk, and our next will be month, comma, and next will be what, the parameter which we have written, right? So, from here, from this parameter, we will take the latest date, right? That is maximum of date received, max date received. Right. So, you can give some different names so you will not be confused here. So, it is a parameter. So, I will just click here, OK. I will make it a little visible for you to be visible. So, this calculation is valid, right? So, I will click on OK. And I will try to bring it into text. Okay. So, after bringing into text, you can see there are so many values. By taking the difference of that, there are so many values are seen here. So, instead of sum, what we'll do, we will go ahead and make it as of minimum. All right. So, if you convert it into minimum, you can see the difference between each month we are getting. So, like from the difference between April to March, it is 1. Then from April to February, it is 2. So, it is taking the difference from the latest one, right? From April to January, it is 3. From April to December, it is 4. All right. So, what we want is we want the last 12 months. So, if it is starting from 0, so from 0 to 11, if it will be a total of 12 months. All right. So, now how can we convert this calculation into our requirement? So, what I will do, I will first remove this. And the calculation which we have, I will just edit this and I will run, I will show it as less than 12. Right. So, if we have converted it to lowest and 12, I will click on OK. And now it is a true/false filter. And when I click again, put it into the text, you can see we are getting a true condition from May, right? So, if we can see this, 12 items are selected. So, we will be getting it 12 months of, what we can say, 12 months of window we are getting here. And this will be dynamic, guys. If a new month of data will be added, like from April to, like we can say May, what will this calculation do? It will find the maximum date of May, and then it will feed this value into this parameter. Right. And from this parameter, it will feed this value into this particular calculation, right? So, for this, if it is a historical data, we will have to find use pre-calculations. Right. If it is a real-time data, what we will be using here, instead of this, we will be using today function here, right? So, because it is a real-time data, we will be using it today's date, and today will be capturing else, what we can see, automatically the system will capture the today's diff, right? So, this is, this is what for historical data we are using this. All right.
So, now next thing what we will do, we want actual values here, right? So, we will write one more calculation and I will name it as rolling 12 months complaints. All right. Now, what I will write a calculation here is, I will take a sum of this. So, if I will aggregate it as year only, so if the rolling, if this is equal to true, okay? If this is equal to true, then okay. If this, if this is equal to true, then what we want here is a total number of records, okay? Then we want number of records, and we will end this. All right. So, you can see this calculation is valid now. So, I will click on OK. We will remove this. And if you try to bring this into the text, you can see we are only getting last 12 months of records, and above everything, it is blank, right? So, this is a dynamic one. So, now we don't want month here, we want a leave value. So, we have converted it into value. We will click into entire view and we will change the alignment to center. And we will just format this text quickly. So, we will name it as rolling 12 months. Some of them call it as trailing months also. So, for this, I will make it as Tableau bold and this I will keep it as 9 itself, or I will make it as plain and I will use this color. Okay. And for here, I will be using Tableau bold and I will make it as 14. Apply product.
So, now next is what we have to create a sparkline over here, right? So, this sparkline we need to create. So, how to do that? So, I will take a new sheet and complaints sparkline. All right. So, for here, I will be taking as date received and we will be using it for month-wise. All right. And we will be taking it the total number of records. All right. So, this is total number of records. I will make it as an area chart. And what I will do is I will create one more sum of records here. So, I will just press Ctrl and by pressing Ctrl and I will create one more duplicate sum of records here. So, there will be two charts here. Then I will, whatever, or if you are not getting this, you can drag from number of records again over here, right? So, it will again create one more chart. And I will make it as a dual axis. And after making dual axis, we have to synchronize the axis, which is the important thing. Always remember that. And the next thing is what, this is the area chart, but for second one, I will make it as a line chart, not it. And for area chart, I will be using color as this. And for this, I will be choosing a color as white. So, I will make it as a white color. And we will hide everything. So, we don't want this perfect, you know, things on our spotlight. All right. So, we have completed our first KPI, guys. So, this complete KPI has been completed, and we will go ahead for the second one.
So, the second one is what, timely response. Okay. So, now these were the total complaints. Timely response is nothing but, out of total complaints, how many has been responded and been closed, okay? So, that is nothing but timely response. So, we will go ahead and we will create the second one, that is timely response. All right. So, when, when we see our data here, so we have one, what we can say, a field here for timely response. I will show you where it is, okay? So, you can see we have a field here that is timely response. Okay. And for this, if it is timely responded, we have it as a value as 'yes', and if it is not responded yet, we have it as 'no'. Okay. So, we will have to convert this 'yes' as a number one and we will convert 'no' as a number zero, and after converting 'yes' as number one, we will take the sum of that, right? Simple. So, we will just create one calculation here, then we will name it as timely response. All right. And I will write a calculation as if timely response is equal to in single or double inverted commas, you can write 'yes', because whatever value in that particular categorical dimension is there, if we are writing as it is, we have to write it in the form of double quotes, then one, else we will take it as zero, else means we have only one value that is zero, zero, and we will add that. All right. So, calculation is valid. And we will break it into visualization. And we will just quickly format this as well. So, I will name it, make it as 26, Tableau bold. Click OK. Center. And I will make it as entire view. Got it? So, this is our KPI.
The next thing we will make making it as closed percentage. Okay. So, I will take a new sheet and closed percentage. Closed percentage is nothing but out of total complaints, how many of have been responded timely. So, what is the percentage of timely response? All right. So, then we will be taking it as closed percentage, correct? So, it is nothing but we will have to take a ratio. So, sum of what we will take, sum of timely response, divided by sum of total number of records. All right. We will click OK. We will bring this into visualization. So, we will format this and we will convert this number as percentage. All right. So, it is converted to percentage. Enter view. Quickly format this well. This is 14. And we will add here one click, that is closed percentage. So, for this, we will make it as bold. Will be 10. And we will be using this color for this. It will be again bold. Play, okay. Center for it. So, second one is completed.
The next what we have to do is we have to prepare this particular line. This is nothing but a progress bar, we can say. Okay. So, how to do this? We will take again, just calculation we have created that is closed percentage. We will break into two columns. So, we have this as up to 0.98, okay? But we want a hundred percent of something behind that, right? So, I will write here one calculation as average of zero. Average of one, not zero. We will make it as average of one. Okay. So, we have a dual axis chart. So, what we will do quickly, we will make it a dual axis and we will synchronize the axis. All right. And from automatic, we will convert it into a bar. Similarly, for this also, we will convert it into bar. And we will take it this after this, right? So, we will take first the average of one, then we will show percentage closed. All right. So, for this, for first, what we will choose the color as, oh, let me take it as red. For average of one, it is red. Apply. And for this, we will take it as three. [Music] Where is gray? Where is gray? This one will take. Oh, okay. This is okay. Supply, okay. All right. And we will make it as entire view. So, we will be using this into our as a progress bar. So, we will hide everything. Don't want this particular axis. Oops, this is synchronized. And we just found on the headers. All right. If we don't want this as well, or we will be able to show that in particular dashboard while preparing the dashboard, we will have this. Okay. So, I will name it as progress bar. All right.
So, now we have completed our second KPI. Now we will go to our third one. So, in progress complaints is nothing but, guys, if you see in this particular dashboard, info, in progress are nothing but thus those complaints which are taken by the company and they are responding back or they are trying to closing, they are trying to resolve those particular complaints, right? So, let's see how we can find those. So, we have one field here that is company public response or not. Sorry, the company responds to the consumer. So, when we take into the rows, you can see there is one particular category which we have here is 'in progress'. Right. So, when I take number of records into this particular value, so you can see these are in progress complaints which we have. We are seeing. So, we are going to show this itself. So, what we are going to do, we will be writing one calculation here and I will name it as in progress complaints.
Foreign. And I will write a calculation as if company response to consumer it is equal to 'in progress'. Right. So, try to make sure you are not making any spelling mistake here. Whatever it is there into that particular field, same should be repeated here. Then we want total number of records, that is number of records, and we will name it end. All right. Calculation is valid. And we will break it into the X. Right. Then we will again quickly format this as well. And I will make it as bold and I will make it as 26. Okay. Right. So, this is our next KPI.
The next what we have to do is in progress. Right. So, in progress are nothing but out of total complaints, how many are in progress? So, the lower the percentage, it will be a benefit to the company, or we can say the customers are happy that more number of complaints are resolved, right? So, I will take a new sheet again here and I will make it as in progress percentage.
Foreign. Just copy this. Okay. So, what we will do, we will write one more calculation here and I will name it as in progress percentage. And we can write the sum of in progress. Okay. We have in progress complaints here, right? Divided by sum of number of records. Okay. And we will bring it over here. And we will format this and we will convert it into percentage and two decimal points. So, again, we will format this quickly. And I will write here as in progress percentage. And I will make this as bold. And we will make it in plain today. And I will colorize this here as well. I will make it as bold. And we will take it as 14. Apply, okay. Perfect. And the next is the sparkline. This sparkline we have to prepare. And it is it is in the form of week number, guys. Okay. It is not a month. So, I will take a maximum of date received here. All right. I will place it here. Not this one. We want a date received here. And we will convert it into week numbers. Okay. The next one, we will take the number of records in progress. Okay. In progress complaint. And we will place it here. Okay. So, these are nulls. Why? Because these are nulls because we have in progress complaints for 2021 only. Okay. So, we will just hide this because all the complaints which are in progress are from 7/5 to 14/04. Okay. So, these are all the incomplete. And then I will just, what I will do, I will create one more sum of here. So, we will have a dual axis. We want to create a dual axis. And we will create it into a dual axis. And for the first one, I will make it as area chart. And I will color it as this. And second, for this, I will make it as a line chart. And I will make a color as this on it. So, you can see a white line, white line is there, short. Then I will just synchronize this. And then we will hide this. We don't want this this as well. We don't. All right. So, this we will name it as in progress sparkline. All right, guys. So, we have completed all the, what we can say, required calculations and required charts of this particular KPI. What we will do, we will start preparing the dashboard. We will show this particular things into our dashboard, right? So, simultaneously, we will design our dashboard as well. So, I will take a new dashboard. And for width, for me, I will be using it as 1500. Okay. So, depending upon your screen resolution, you can use any form of pixel size, okay? Depend on you and your system. So, I will be using as 1500 by 900. So, I will try to increase that. I will make it as 1600. Okay. This is fine. All right. So, this is my dashboard. I will show the dashboard title here. And what I will do is I will take horizontal container and I will add a blank here. Okay. This blank is nothing but it will be a guide. It requires or sometimes it doesn't requires also. So, I will just reduce its size. And I will make it as up to let's say for 100 or we will make it as, let me see what was our size. So, I have noted it down. We will make it as 155, somewhat okay. So, this. So, we will just increase this very little bit. Okay. So, this this seems all right. This is fine. This is fine. Okay. So, now what we will do, next, we will start adding our charts over here. So, before that, what we have to do, we have to create this backgrounds. Okay. This colorful backgrounds which we have to create here. So, for that, I will take blanks. And I will edit your first blank. Then I will add a second blank. And I will add a third blank. Okay. I've added three blanks here for it. So, now I will go in layout and I will change the background color here. Okay. I will change the color. And for this, I will be using a color code here. So, I've already written my color code. But I will be using is, first, I will be using as AAAA four times A and FF. Hold it. So, this will be my first one. And for my background, I will be using as opacity of 60. Okay. So, this is my first. And for second, I will design it again. And I will be using a code as F39F39367. You can use your own color codes, guys. Doesn't matter. So, I will be using here as 60%. And for third one, I will be using it as #00D6D60. Okay. And I will make it as 60% of transparency or opacity about it. And one more thing what we have to add is we have to add a filter panel which will be there. So, this panel we have to add at the right. So, I will take one vertical container and I will add it here. Yeah. All right. So, I will just make it a small one. Okay. This is fine. Yep. This is fine for it. So, what we will do, we will just give it a color. So, we will be, you know, it will be identified for us that, yeah, this is a panel. All right. And what we can do here is, I will take this particular filter horizontal container and I will give it a background filler as this, this, this is right. Okay.
So, now next thing what we have to do, we will start placing our KPIs over here, right? And we will change the name of dashboard as credit card complaints dashboard. Make it as Tableau bold. And we will make it as 22. Apply. So, we will make it as 20. This is fine. Okay. All right. So, the next thing what we have to do, we will start placing our KPIs over here. So, we will be not using any tiled one. So, we will be using a floating one because these are not a tiled things. These are these will be placed in the form of floatings, right? So, first, we will add a text one because we have to give her heading here. So, first is our total complaints. So, this is my total complaints. And I will make it as to center. It will be Tableau bold. And I will make it as 20. Okay. So, 20 is a little big. So, I will make it as cost black. And I will make it as 16. Yeah, this is fine. Got it. So, then I will Ctrl C, Ctrl V. I will just copy this. And I will place it over here. Similar. Ctrl V. I'm gonna place it one over here. So, this is our timely response. Okay. And these are our in progress. Perfect. Yeah. If you want to reduce the size of this, let's make it as 15. This as well. I'm not remembering what I have used, but still, right? So, now next thing, we will start adding our image. Not an image. First, we will add our this, that is total components. So, first, I will hide this. So, these are our total complaints. Then I will add a rolling 12 months. First, I will hide this. And I will place it over here. All right. We will add our sparkline as well. So, we'll just write the title. We will make it small. So, we will have to adjust it over here for it. So, now what we will do, we will quickly format these things. So, I will just go in format and in shading, I will say no, no, we don't want any shading. Similarly, for this, I will go and say none. And for this as well, I will go ahead and see none. Included. Perfect. Right. So, just increase this sound. Right. And the people format this again. And we will just turn off everything. Every grid line. We will just go ahead and turn off. We don't want anything, any line. We will be not displaying on any of this particular grid lines. That's all. Right. So, we have a small border is there over here. So, we will go in borders and we will remove this as well. Perfect. Right. So, you can see this is, this looks nice, clean, and, what we can say, for good, good looking, what we can say, KPI we can see here. Only here we can see for this particular KPI, we have given a red color. We will just go ahead and change this. So, I would go here and here. And if I will change the color of this blue, right? Apply. Okay. Perfect. So, this is our KPI. All right. So, we have one small line here. You can see I have added one small line. So, I will show you how to add that particular line, which will be a distinct feature. So, I will go in layout. Then first, I will go in dashboard. And I will add a blank over here. I will just reduce its size somewhat. Okay. And we can make it plus 3 and height as let's say 75. Okay. And I will give it a background color. It looks more brown. So, I will give the background as this. Oh, sorry. I gave the background more colors. And we will choose it from here. And we'll just choose a dark one. Okay. Okay, guys. So, the other formattings you can do it on your own. Then we can select this. And I will just first select this container horizontal. And after selecting this horizontal container, we will make distribute contents evenly. What will happen? This will not allow this KPIs to reduce or about this containers to extend or reduce their size. So, it will be distributed evenly into this particular space. All right. So, this is our first. And we will similarly do for these two as well. Okay. So, I will choose our timely response for this. And I will just hide this. So, I will do this quickly in my speed. You can you can do it in your own speed. Slow, guys, slow. Or if you are good in this, you can do it fastly as well. And for the third one. So, we will do the similar thing. So, what we will do, we will just add our images over here, whatever we will be using to show some, what we can say, design to our dashboard. So, I will take an image. I will say enter this. And I will choose. And we have it here. So, I will take a credit card first. Okay. Perfect. And we will just copy this. And we will just edit this image. And we will choose another image. Video for this timely response. Okay. Again, we will choose another image. Looking progress. Okay, guys. So, we have made our KPI. Right. So, the KPI, this part has been completed. So, almost 40% of work is completed. Next, we have to prepare this particular, what we can say, the charts and we will place them again into our dashboard.