 Hey guys, welcome to essential tech, so till this site and this is part one of Power BI projects. So basically what we are going to do in this video, we just wanna create this beautiful dashboard and in this dashboard we will analyze about the corona cases. So basically nowadays you know corona virus is gonna affect for each and every individual's life. So what I was thinking to create a beautiful dashboard where in a single place we can get the many more information which is required to us. That's why I have created this beautiful dashboard. Here we can get the information which is required to us. For example, in the left side in the top we can see the countries so it is acting as a filter which is in the power base called as slicer. Then total amount of cases, active cases, total death, total recover and serious cases. So if we wanna select only for Afghanistan then it will be filtered and in Afghanistan we can see total cases is 24, active cases is 23 and recovered is 1. So this is working like this. After that go to 1% category wise. So here total recovered cases 33.03%. After that active cases is 62.85%. Then total death as we can see 4.13%. In the down we can see the top 5 countries by active cases. So in the active cases Italy is on the top after that Germany then Spain then Iran then China. In the right side we can see the total cases, active cases, new cases and serious and critical cases. So this is very beautiful dashboard I guess and this is very simple to create. So how we can create it? So go to on power play desktop in the blank. So this is the blank one here we will create from scratch. So press the like button for this video and do subscribe our channel if you like it and please share to others. So what is our source? So I wanna get the data from a web source and here we are having this website which is vortometer.info plus coronavirus. So here as we can see if we gonna top then it will be a site like this here go to on the down scroll down and here we can see this table. This table is required for our project here we can see the country then the total cases new cases total death new death total recovered active cases serious critical. So these informations are required to us. So basically how we can load this into our power play desktop. So just copy this link go to on power play desktop and here get data and select the web. After that we need to wait few seconds here paste that URL and click on ok. Now it will take few seconds so we need to wait until it will not gonna be complete. So it is connecting basically it's gonna connect with our website so it will take few seconds you need to wait until it will not gonna be complete. So here navigator is gonna opening. Now here this is the table view if you will move to the web view then that will have the web view just click on it and this is the web view. So basically what we want go to on table one and go to on table view. In the table view as we can see we are having the same table as we were seen in the website. So this is required. So just select that one and click on load. So it will directly load into power play desktop and it will not gonna edit inside the query editor. So it will load. So here as you can see table one is loaded successfully. Now first we need to add a slicer to filter out for the countries. So here go to on this and click on this slicer and just bigger this one and what would be the values. So values would be the country and others. So we can drag and drop this country and others inside the fields. So now here it will wait few seconds and now we can see we are having this slicer. So now it's good but you know the design is not good for us. So what we need to do go to on the format and here go to on the items and now we need to increase the size for that. So text size should be increased and it should be told. So that may looks good. Now it's better if you want to increase more then we can increase and here we can select the font family. So what I prefer to use the aerial. So we can select this aerial go to down and now we can click on this. Now we can select this aerial. So now it looks good to me and here what you want to do in the top that is a title. So it should be highlighted. So how we can do that? Go to on the format and here scroll it open the title and here we can write anything which we want. So I want to write country and go down what are the font and background color. So we can change the background color according to our requirement and our font it should be white. Now it looks good and alignment should be center and here you can increase the size so we can also do that. Now it looks good but here country and others so it shouldn't be here. So how we can remove that one? So for that we can see slicer header. So we can click on this. So that is gone. Now it is good after that as I told you we are having few measures that will be capturing the total number of cases, active cases and many more information. So for that we need to select the cards. So here go to on the cards and here we are having two types of cards cards and multi row cards. So we are required only cards. After that put it smaller after that here what we want to display the total cases. So here we are having these total cases. So we just need to drag and drop inside the fields. Now it looks good but what we want we just want to have the total values not values in the thousands. So go to on the format and we need to set the format for this and in the data level scroll down and here we can see display unit it should be none. So now this is the total cases. But here you know this figure is not seems good. Why we are not getting this figure good? Because go to on the website here at the bottom as we can see we are having this total. So this total shouldn't be there because if we will add this total so this will be double. So go to on power bi desktop and here click on query editor and here we need to filter out for the total. So go to on this country and let me filter out for the total. So we can scroll down and we need to get the total and it shouldn't be the part of our query. So we can click on okay. So it will be filtered now we can click on close and apply. So this figure will look good and correct. So we need to wait. Now it looks good. Now what we need to do here go to on the format and here scroll down in the title we just want to display the title as total cases. So we can write this total cases and what else we need to do we just put it in center and what would be the background. So background will be the custom and here let me select ff6600 and now go to on back and here go to on the font color it should be white. So we can select the white. Now it looks good and if we can put it bigger then here we can see the total cases but we don't want to display that one. So go to on the format again now go to on categories in the categories it should be off now it looks good and we can put it smaller and we can increase the size as well if we want. So size is 45. So let me increase to I guess 50 that looks good. Now we can set the background for this. So here we can search for the background just close it and here we have background color as of now it's white so we can change it according to our requirement. So now it looks good. So this is the first part we did in the second part we just copy it and paste it and just put after this and this will be the active cases. So we can put it active cases over here and go to on the format then go to on the title just need to change this total cases to active cases. After that we need to copy one more time and paste and it should be the total death. So here we can see the death we can drag and drop if we click over here sorry let me drag and drop total cases and if we click over here then we can see it is some if we want to use the aggregate minimum maximum count listing down count then we can do but our requirement is to summarize that one. Here is the death so we can go to on the title and let me change this as death. Next will be the total recover so we can copy paste and put it right side and let me drag and drop the total recovered that should be over here and let me drag and drop and go to on the format and let me change this title as total recover now we need to add one more card so we need to put it smaller then active code it should be smaller like this and put it left side then total death it should be smaller put it left then total recover it should also be smaller and put it left and here we need to add one more and that will display the total critical cases so we can drag and drop the total critical cases and put it here and here go to on the title just need to change this title so this title should be serious cases now it looks good and first part we did second what we need to do we need to add a doughnut chart over here and that will display the percentage of active cases death and recovered so for that here go to on this with resistance and let me click on this doughnut chart and put it smaller and bigger from right side so next what we need to do we need to drag and drop this active cases inside the values next we need to drag and drop the total death inside the values and we need to again drag and drop total recovered inside the values now it looks good but what we need to do we need to do one more thing like we just want to get the percentage we don't want the exact value so how we can do that so go to on the format and here we are having all these options first is data color so let me change this data color total death is should be red so click on this go to on custom color and here we can select the red after that it is the total recovered so total recovered should be green so we can click on this and we can click on this green so it's a light green and this is the total active cases so we can put it as blue so it may be the dark blue so now it looks good next thing what we need to do we just want to display the percentage so go to on data labels and here we are having the option to display what we want to display so here we can say the label style so in the label style we just want to display the category and percentage of total so it looks like this but we just want to display the percentage so we can click on percentage of total so now it looks good next we just want to put the border for this and title so click on format and go to on border and enable the border then go to on title and in the title what we want to display percentage category wise so we can put percentage category wise now go to on down and here we can select the background color so it should be like this we can select the font color let me put that white after that alignment should be center so now it looks good and next what we want to do we just want to display top five active cases by country wise so how we can do that so for that we want to display column chart so go to on this and click on this column chart next we just want to display the top five country so here go to on the countries and let me drag and drop with the axis after that go to on the total active cases and let me drag and drop inside the values so here we are having all these countries but what we want to do we just want to use only top five countries so how we can do that so go to on the filter and here let me add a filter for this country and it should be top n and number is five and what would be the value value is the total active cases and click on apply now it will be changed and now we can see Italy US Germany Spain and France now what next we need to do go to on format and here we can change the format as we want so first go to on data colors in the data color we can see its default value we can click on this so all and if we want then we can change it according to our requirement for Italy like its top so we can put it as the red in US it's the second top so we can put another color after that we can put one more color so we can we can change as we want to change it so let me change for for France it looks good now close this data now go to on data levels so if you want to turn on then we can see the exact values so here 43,000 24,000 22,000 and 12,000 that looks good now scroll down and go to on title so here it will change this title as top five countries by active cases now scroll down and let me put at center and what would be the background background should be like this and what would be the font color it should be white no it not looks good so we can change it to dark blue that may looks good now it looks good after that what we need to do we need to hide this active cases and country others so this is not required to us so how we can do that go to on the format and here let me open the y-axis and scroll down in the title we can put it off so that is gone after that we can close this y-axis and go to on x-axis in the x-axis let me scroll down and here we can see this title so we can turn it off after that we can go to on the borders and turn on the border so now it looks good so we made a great progress as yet so next we need to add a bar chart so I want to use this bar chart now let me bigger this one and let me go back and bigger that one after that here as we can see we are having the axis so in the axis it should have the data in the country wise so we can drag and drop this country after that we just want to display the total cases first so we can drag and drop inside the values then the active cases so we can drag and drop the active cases after that I want to add new cases so we can drag and drop this new cases over here then we need to add the case and critical cases so we can drag and drop the series and critical cases inside the values now it looks good if we want to change the color then we can now go to on format and here after that go to on the y-axis and here as I told you we don't want to display this country another so we need to turn off the title so it will be gone now it looks good go to on the x-axis and this active case total case will be gone after turning off the title so we can turn off this title now it looks good next what we want to do we just want to change the color for this so go to on data colors over here so let me put it down and here we have data colors so in the data colors as I told you in the series and critical it should be red so we can put it as red and in the new cases it will be it looks good in the active cases it is good and in the total cases it is good so now we can see we are having all these after that we can see here we have total cases active cases new cases and series critical another so this title shouldn't be here and we are not required to have this so go to on the title and turn it off so now it is good now what next we need to do so here as you can see we are having all these values but the slicer it looks bigger so we can put it as smaller like this or it may be like that next we want to put it in the left side so we can select all these and go to on left side after that let me put these two visualizations in the left side we want to make it bigger here as you can see we don't have turn it on water for the visualization so we can go to on format and try to on the border for this and go to on this total cases here again we need to turn on the border let me use this format and paste it here let me use this format for this paste it here one more time and the last time now it may be bigger and put it right side and total cases it should be on the right side so it will have the spaces between these cuts so I hope so I hope if we have made a great progress and we have almost completed our project and here let me bigger this one and now we can see it is on the top if we want to decrease the size then we can also do that now we can see it is almost the same as we seen in the earlier so go to on that one and we will try to compare so this is that one and here we have made this one so this is almost the same little bit formatting are required over here so you can make that formatting and this is very simple task code but if we want to check the values then we can one thing I missed over here like in the country we don't have the values for the select all so go to on the visualization and go to on this format now in the selection control it should be select all option now minimize this and now let me select all this now let me check for few values for example I need to check the Italy first because it is on the top so it's called down Italy now we can get and here these values are gonna change but in the earlier it was not gonna change only only these cards were changing and this category wise values were changing but these two illustrations were not gonna be changed so how we can revoke to change these values so for that let me on this and let me select that one go to on format and here edit interactions it is selected and we don't want to filter this one so we can disable that one in this we can disable rest we want so that is good now we can minimize this now it is working fine now let me select for Italy and try to check one more time so here scroll down go to down and here Italy is already selected so values are gonna 53,000 the total cases in the Italy and active cases is 42,681 so this is very big number and death 4825 so this is very crucial and very sensitive and let me check for India so here we can select this India the total cases is 332 and active cases is 304 after that here we can see the interactions so go to on format and click on this it will not be displayed now in the India we can see that 332 304 5 is there total recover is 33 and series and cases is blank so this is what we are having as of now and this is not in the format so what we can do we can increase the size of this or it looks good after that we just want to check for Iran so we can click on Iran or in the Iran after that we can check for Iran so we can click on this here we can see 200610 so this is very big in the number now let me check for US so go to on the down and here let me check for US so in the years 24,204 this is very big number and active cases is 23,000 death is 302 and total recover is 176 so the recovery is very less in the numbers after that let me check for UK so in the UK is 5,018 let me check for UAE so total cases is 153 and death is 2 and now go to on top and let me check for few more and here we have Pakistan so let me check for Pakistan so 645 active cases is 623 total death is 3 and total recover is 30 now go to on top side and let me try to check few more and here let me check for France so in the France we can see 14459 total cases 12310 is the active cases now go to on the top and let me check out for few more let me check for Australia so this is 1072 active cases is 1019 so this is very big in the number now go to on the top so I guess we are in the top let me check for Bangladesh last so in the Bangladesh 24 total cases 19 is active 2 is death and total recover is 3 and we can check all these values and here Italy then US then Germany then Spain then France and in the active cases we are having all these so I hope you have understand how we can create this beautiful visualizations in the simple way so I have explained from scratch to end so thank you so much for watching this video if you like this video please subscribe our channel to get many more videos thank you so much guys see you in next video