 Hey guys welcome to SSUNI Tech, Sushil this side and this is continued version of Power BI project. So today we are going to discuss one more real time project on the Power BI and this is again based on the healthcare domain. So here we are going to include the COVID cases and other cases as well and here we are going to display their counts with the confirmed recovered and total death for overall cases. Let's assume we are having an organization and those are dealing in the healthcare so we are having different different hospitals across the world. So we are capturing the data from all those hospitals in our dataset. So we have three dataset files, first file will have the confirmed cases, second will have the recovered cases, third will have the total death. So we will have three files and fourth file that will contain the country information across the globe. So we will have total four files. So by using those files we will create this beautiful visualization like here you can see the total cases. So here you can see this is the total cases count including the COVID-19 and other cases. These are the confirmed cases like how many persons have affected on the COVID and how many persons are affected through the dengue or any other disease. Then how many has been recovered? How many has expired? So we can see here in the visualization. In the bottom we can see the confirmed recovered and death cases. So basically it is going to display the data for the recovered percentage, death percentage and confirmed percentage. So overall will be 100% and 71.75 will be the confirmed. After that 25.69 will be the recovered. Then 2.05% death cases. So here we'll see this pie chart. After that move to the middle top. Here we can see death by country and region. So here China then Italy then other countries we are having and for this I'm going to use the COVID-19 data set. So this is the dummy data set if you want then you can drop your email IDs on the comment box. I will send this data set to you. So here we can see these are the number of counts as per the country. Then bottom here we can see the death by country and region. So here in this map you can see for the Asia here it should be the China. After that these are the total number of deaths across the globe and we can move this map and we can check the data. After that go to on the right top you can see this table which is country wise recovered cases. Here in the bottom this is area chart. On the monthly basis you can see the data like if we want to see for any particular day then we can check like 17th of February 2020 this is the total recovered cases. In the bottom you can see the confirmed cases recovered cases and death cases. Once we click on the confirmed cases then the above table has been changed and now we have the country wise confirmed cases. And here this is again changed and now we can see the confirmed cases by attribute that is our date. Let me click on the death. So here this has been changed and above table you can see the country wise death cases and in the bottom this area chart is again changed. Now we can see the data for the death. And here you can see we are having this card by which we are going to display the data by switching like total cases then confirmed cases. After that we'll see the recovered cases then total death. So it will be going to change on every four seconds because we have already set on this. After that you can see this bottom. So here we'll see the country and how many cases before and how many number of cases has been increased. So these are the confirmed cases. The analysis is displaying on this. So how we can design this dashboard by using the source data. So we'll see right now. First of all go to on the Excel file and we'll see the source data. So here you can see the country detail the first source file double click on that. So here you can see the area then country and reason after that state and other informations. So this is for the first source. Now let me close this and go to on the confirmed cases. So let me open the confirmed cases. So this is the confirmed cases like here we can see the state then country and reason then date on that date what was the confirmed cases and what was the area. So we have this data on the confirmed cases. Now let me open another file. So this is for the recovered. We have same number of column as we had in the confirmed. Now let me close this and see the last one that is the death. So it should also have the same number of column with the data. So here you can see the state country reason then other informations as the same as we seen for the confirmed and recovered. So these four files will be used to design our visualization. So go to on the new Power BI and we'll try to do that. So before going forward first of all I would suggest just grab two visualization from the marketplace because those are not available right in your visualization. So first that is our scroller. So this scroller will help us on the bottom side as we seen. So this is the scroller. So in this you will see the country and reason after that the total cases and how many counts has been increased. So this is on the scroller and second we should need this rotating tile. So what is this? This is basically here like this is going to change on every four seconds. Like this will be rotating the measures and we can display the multiple values on this measure. So before going forward just grab these two visualization in your Power BI desktop. Now let's start. First of all go to on the home and go to on the transform data. So here we need to get the data. So go to on the new source and click on the excel because we have the data in excel file. So here let me get the confirm cases first. So click on open and we need to wait five seconds. Go to on the seat one and wait five seconds. Click on okay. So here let me rename this as confirm cases. So we can rename this confirm cases. Let me grab the second file. So click on excel again. This time country details. Click on open. Wait few seconds. Go to on the seat one. After that click on okay. Now let me rename this as well. Call this as country. After that go to on the another file and this time let me grab the death. Click on open. Go to on the seat one. Click on okay. Let me call this as death cases. After that go to on the new source. Click on excel and let me get the recovered. Go to on the seat one and click on okay. Let me rename this as recover cases. Now we can click close and apply. So it should be loaded in our Powergate desktop. So we need to wait few seconds. It will be loaded soon. Now first of all go to on the relationship and in the relationship pane we can see we are having all these. So as I have already selected the auto-detect option so that's why it is creating the relationship like area and here again on the area again on the area. So that looks good. Go to on the report. Now let's start with our report. So first of all go to on the view and here go to on the themes and let me get the this theme. So your pace would be like this. After that I need to grab a rectangle. So go to on the insert and here go to on the rectangle and get this. Let me make it bigger and go to on the fill and here let me fill this with this color. That looks good. After that let me have a button that will display like total cases. So go to on the button and let me have a blank button. Now let me make it bigger like this. Now go to on the button text and here let me call this as total cases. After that the font color let me put it as white and here the text that should be 35 I guess that look might be good. Now go to on the background color. In the background color let me have this. So this is like total cases that looks good. After that go to on the shadow. Let me open the shadow. So it is saying like black but I want to have the white. So it looks like this. Now we can set it according to a requirement like we can set a little bit like this. Next we need to have the total cases a measure. So that will have the total number of confirmed cases total number of recovered and total number of death cases. So for that let me go on the country table and create all the measures inside the country table. So click on the new measure and here we need to write the DAX formula to get the total number of cases. So we need to wait few seconds. Formula bar has been opened. So in the formula bar let me call this as total cases and it will have the sum of confirmed cases plus sum of recovered cases plus sum of total death cases. Like this close the bracket and put the enter. So it will create a new measure that will have the total cases. So we need to wait few seconds. Here you can see total cases. Now let me grab a card and let me make it smaller. Let me put it here and little bit smaller like that. Now let me try to drag and drop this total cases in the field. So here we can see the total number of cases. It is showing 8 million. Now go to on the format, go to on the data label. Here you want to see exact number. So click on none. So these are the total cases. But here we need to do the formatting little bit. So first of all I don't want to see the background color. Then in the font color I want little bit yellow edges. So that looks good to me. Now go to on the category and instead of this black color I want to have the white color. So now you can see this is the total cases. Next we want to have one more card that will have the total recovered cases. So let me copy this and paste one more time. Let me have the confirmed cases first. So we can search confirm. So this is the confirmed cases. So we can drag and drop in this. So this is the confirmed cases. We can little bit adjust with this color and put it as white. So this will have the confirmed cases and you can also decrease the size of this. So like it is 45. Let me have this as 30. So we can save the space and for this let me have this as 40. So we can adjust little bit. Now let me copy this and paste one more time. So we have done with the confirmed cases. Next we have the total recovered cases. So let me have the recovered. So here in the recovered cases we can see we should have the recovered. So we can drag this and recover should be drop in the field. So we need to wait few seconds. Here put on the fields. Now let me try to drag and drop in the field. So here you can see total recover cases. Go to on the format. Go to on the data level. In the font color let me have the green. Like this. After that the last one that is the total death cases. So let me put it at bottom and after that go to on the search box and here let me search for death. So this is the total death. So we can drag and drop it here directly. So this is the total death. Now go to on the format. Go to on the data level. Let me have this as red. Like this. So this is the total death. Now we can adjust little bit more on this. So we can add one more visual below of this. So we can set little bit up like that. Now let me have a pie chart. Now we can click on the pie chart. Make it a little bit smaller and put it on the bottom of this. Now go to our existing one and here you can see confirmed cases recovered and total death cases the percentage of that. So here go to on the confirmed cases first. So let me search for confirmed cases. So this is the confirmed one. So we can drag and drop in the values. After that we need to search for the total recovered cases. So this is the recovered cases. So we can drag and drop the recovered cases. And the last one we need to search for the death. So we can drag this death and drop in the values. now we can see we are having the values along with the numbers but we don't want to see the number we want to see the category and the percentage only so go to on the details level in the details level let me have the category and percentage of total now we can see like 2.525.69 which we had before now go to on the data color and here for the depth I want to see as red and for the confirmed cases I want to see this in white color in the recovered cases I want to see in green color now go to on the background color and off the background color so now it looks little bit good after that go to on the title let me have the title font color that should be white so it looks good and after that we can go on the lizen and try to make the change on the color as white for the lizen so it should be like this after that here the numbers as you can see not visible as of now so again we need to go on the detail level in the detail level this color this again should be white so that looks good now you can see this after that go to on the border of this and try to add the border so here this is the border let me on this and little bit radius so now this looks much more better so the first part that we have done like total cases total confirmed cases recovered depth and this pie chart go to our existing one second we want to add the depth by country and region so go to on the training one and here let me add a clustered bar chart and here let me make it little bit smaller from the bottom like that and little bit bigger so here we want to see the total depth by country so here we have already in the depth cases table so area we can drag this area or this country region in the axis after that here we can see the depth it should go on the values so now you can see this value like these are the country and regions and here the values that you are seeing so this looks good after that we need to have a map so let me click on the map so before going to use the map I am going to tell you your system should be connected with the internet otherwise this map will not work for you now go to on the existing one and here we can see depth by country and region so now go to on the training one and here let me try to drag this depth and drop in the size and in the country region it should go on the location now you can see these are the numbers and we can zoom it and we can zoom out as per our requirement after that we need to have three tables first table will be going to display the total confirm cases second will have the recovered cases and third will have the death cases so let me have the table first so click on the table and little bit adjust on the right side and try to make it bigger and this as value now go to on the table in the table as I told you first let me have the depth because we have already searched for the depth so country and region should go in the values first then total depth count should go in the values and this should be some so we can check it has the sum so that looks good go to on the format and try to little bit format this so go to on the grid and try to increase the text size so this is like 14 and now put it on the right side like that now go to on the title and let me change the title of this as death count country wise and you can also change the background color of this as red and the font color of this as white now let me copy this table and paste on the same and let me put this above of this death now go to on the fields and this time we want to have the confirm cases so here in the country isn't let me delete this and that it should be deleted go to on the country and region let me try to drag and drop in the values and after that in the confirm let me try to drag and drop in the values so here it should have the value like that let me try to make it on the right side little bit and go to on the format go to on the title and here instead of the death it should be the confirm now go to on the background color this should be white and the font color that should be black I guess in this case so confirm count country wise let me try to have one more let me copy this and paste one more time so we have done for the death we have done for the confirm last one that we have for the recovered so go to on the field again and let me search for the recover this time now let me delete these two fields from here and here you can see the country and region so you can drag and drop in the values first after that go to on the recovered and try to drag and drop the recovered right here now you can see the confirm count so this is not called confirm one so go to on the title and try to make the change on the title instead of the confirm this is the recovered now go to on the background color so this time it should be green and the font color that should be I guess white like that now let me try to make it little bit bigger on the right side of this map like that after that we need to have three more visualizations go to on the existing one so here you can see this area chart death by attribute once we click on the death if we go on the recovered then we will see this recovered by attribute if we click on the confirm so confirm by attribute so these three visualizations area chart we need to add on this so go to on the training one and here let me add the first area chart and try to configure that so for the recovered go to on the recovered cases table and here we have this date let me try to drag and drop this date on the axis first and after that go to on the recovered and try to drag and drop in the values so now we will see like 2019 as you can see let me have this as date so now we will see the area chart so this is for the recovered so I don't want to see blue color I want to see green color so go to on the data color of this in the recovered I want to see as green so this is like that so we have done for the recovered one let me try to copy and paste one more time above of this and little bit set for this now here you can see the recovered so this time I am going to have the confirmed one so let me search for the confirm so in the confirm we have the date let me try to drag and drop the date and this should have the exact date value not the date hierarchy and in the recovered let me delete this and try to drag and drop this confirm in the values so we will see the confirm by date I am happy with the blue color I guess after that let me try to copy one more time and paste it here and this will display the count for the death so let me delete all these two and search for the death here let me try to drag and drop this date on the axis and instead of hierarchy I want to see the exact date so we can click on this here in the death you can drag and drop in the values now go to on the format of this go to on the data color let me make it as a red so we have done that after that we need to have three buttons to navigate between these three charts which we have created right now so before going forward let me have three buttons here so go to on the insert and go to on the button let me have a blank button first let me try to put it on the bottom right here and go to on the button text and here let me call this as confirm and we can increase the size little bit or we can put it on the bottom area or we can go to on the outline and here we can around the S and we can little bit increase this text size so go to on the button text and here in the text size we can increase it little bit and here let me put it like that the one thing that we need to do we need to a little bit adjust this area chart in the top side so we can little bit decrease the size of the table so this is the third table let me decrease the size of this now let me try to put it on the top side little bit this is for the death next will be for the confirmed and the last one for the recovered now we can put it on the below of this you can increase this and we can put it on the bottom little bit like that so here we need to adjust this that looks good after that we can increase the size of this now we can put little bit on the left side and try to see either we have the same area or not for the death we do not have so we need to put it on the top side now we can adjust now this looks good so we have done with the confirmed one let me copy this and paste one more time and this will have the recovered so go to on the button text and here let me have the recovered let me copy this paste one more time and this will have the death and you can put the color as you want i am going to leave it as it has now you can see confirmed recovered and death so now we have done with this the only thing that is remaining like if we click on this button we can decrease the size of this button little bit so like this like this like this so confirmed recovered and death so you can click on the confirmed so your figures will be changed according to the confirmed and we will click on the recovered so figure will be changed according to the recovered then click on the death so it will be changed according to the death so before going to configure the bookmarks on these three let me have the scholar so we can click on the scholar and put it on the bottom side of this and let me try to make it smaller and here let me put it from here here you can see the category so in the category i want to see the country so go to on the country table and let me so where we can see all the countries so in the country you can see this country reason so we can drag and drop in the category after that go to on the format first and here i don't want to see the title so we can off this title now go to here so here you have seen about the country reason now here we need to create one measure that will see the difference in the number of increased from last 10 days or from last 20 days that we can go in the measure absolute we can display the confirmed cases directly and second we need to create so first let me have the confirmed cases here let me try to drag and drop in the absolute so here it is going to start the confirmed cases that you can see now we need to see like how many number of cases has been increased from last 10 days so that we need to do so go to on the insert and first of all let me remove this and go to on the country table because i want to create all the measures inside the country table let me select that now click on the new measure so here let me have the previous data and here let me for that let me calculate after that the sum of confirmed cases so here we should have the sum of confirmed case then put the comma after that date add then here we can have the confirmed table so confirmed cases date that should be minus 10 comma here we can have the day now we can close the bracket and put the internet so what it is going to do it is going to calculate the data what we have 10 days before so the total number of confirmed cases we will see from this after that we need to have one more measure so go to on the new measure and click on that and where we want to subtract what number we have today and what number we had on 10 days before which we have calculated on the previous data so that will have the increased number so here let me call this as increased number and here just some of confirmed cases close the bracket subtract the previous data put the enter so this will have the increased number and this increased number should go on the scholar on the major deviation now we can see like this is the increased number that you can see right here so this is the scholar the last thing that is remaining the rotating tile now let me click on the rotating tile so we can click on the here and this little bit is smaller from the left side as well and put it on this here first we want to have the total cases so we can drag and drop the total cases after that the confirmed cases so let me search for the confirmed cases so we can drag these confirmed cases and drop it here after that we would have the recovered cases so let me search for the recovered cases so here is the recovered cases after that the last one that we have the death so we can search for the death and try to drag and drop this death on this after that go to on the format and go to on the label setting and in the label setting display unit that should be none now here we can set this as white or any another color which you want so let me have this as black I guess after that here we can see vertical flip so we can click on that so it will be going to switch vertically every time like this so we have done this as well you can do the formatting so that is not a big deal the last thing that is remaining on this go to on the view and add the bookmark so click on the bookmark and click on the selection panel in the bookmark let me add a bookmark first so that will have the confirmed so let me call this as confirmed second bookmark that we want a recovered so let me rename this as recovered let me have the third one that will have the death let me rename this as death so first of all go to on the confirmed one in the confirmed one what we want to see and what we don't want to see so here you can see the confirmed so this is a recovered count country wise so in the confirmed run we don't want to see that so recovered by date recovered count by country we don't want to see this after that the confirmed we want to see the confirmed in the death we don't want to see the death after that you can see the death by date so death by country reason we want to see this this is this one so unhide that here death by date so that should be this one so we can hide that after that confirmed we want to see recovered we don't want to see so just click on this and try to update so this will be update go to on the second the recovered one so in the recovered one we want to see the death by date we don't want to see confirmed we don't want to see we want to see only recovered that is fine recovered count confirmed account we don't want to see this and death count we don't want to see that now go to on the recovered and try to update that go to on the last one that is the death so in case of death here you can see death by date we want to see confirmed by date recovered by date we don't want to see recovered count country we don't want to see this as well so we can hide this after that you can see the confirmed count by country we don't want to see that only death that should be here click on this and update that now close this close this selection now let me click on the confirmed and go to on the action on this type we want to move to the bookmark what bookmark we want the confirmed go to on the recover go to on the action and this time go to on the bookmark and here recover go to on the death action go to on the type bookmark and here that now let me click on the confirmed one so here we can see the confirmed by date we can increase the little bit size so you can adjust according to your requirement now click on the recovered once we click on the recovered we can see recovered by date and recovered count now click on the death so you can see that this only by date that count so I hope guys you have understand how you can create this beautiful with digestion in your practice and if you need anything just drop an email or you can do the comment on this video so I will try to response if you have any another questions or any another suggestion on this so you can drop the comment as well if you have any project that you want to share with us so you can directly contact with me thank you so much for watching this video if you like this video please subscribe our channel to get many more videos don't forget to press the bell icon to get the notification of our newly uploaded videos thank you so much see you in the next video