[Music] [Music] all right everyone so this is my co v19 dashboard and I spent literally two weeks or even more than two weeks now to find the right information in the internet such as the API right data source making sure that I have the data coming from a reliable source so all this work which has been done so far just to make sure that the data is correct took me a while a long time than actually building the dashboard itself so I'm pretty much happy that I am I'm done with the first part which is the important one so now I'm going to share with you more details how we can use this dashboard what we can what we have here as data how we can understand with the charts and graphs and so on and also I will be giving you some more details about how you can build this dashboard on your own basically it's going to be some guidelines it's not going to be very detailed one but just few guidelines and then if you would like to also access this dashboard I will be putting some information in the description ok so let's see what we have here on the right side of the dashboard here I had the ten most affected countries with the mortality rate and I selected here only few countries okay I did not include all the countries only countries where we can where we have basically more than 50,000 confirmed cases so I listed here all these countries from the highest mortality rate to the lowest mortality rate so you can see here from Belgium UK France Italy and Spain they have more than 10% and the remaining countries there are around five to six percent and you can as well see the trend over all over over time for each individual countries in the third column again you can compare this trend to the global mortality they can see here in the big yellow chart we can see we can quickly see it's going it is having it's going it has the same trajectory okay and there are sort information that we have in this dashboard probably you're familiar of it is the for example on the right on the right side here you have the total number of active cases total number of recovered cases confirmed cases and dead cases these are global numbers okay for the entire world and we can also see here what is different that we have from the day before so you can see four active cases we have an increase of 0.6% which are present around 14,000 people and we can also see an increase of 2.3 percent for recovered cases it's sharper than 29,000 people and it's color-coded green is basically a good information and read everything it is in red it's a bad thing okay so in this center in the top center what you have is basically the year or evolution of cases or come from cases recover cases active cases and good cases and over a certain period of time so this is for the global situation report so let's see what we have in the tab can't cope in nineteen countries specific okay so in disturb Cove in nineteen countries specific you can see the result for example for India and you can see the number of confirmed cases active cases recovered cases and dead cases okay that's what we have on our first row pretty much the same thing that we have in a global situation report and the second row we have for each individual status at the evolution over a certain period of time in a column chart here okay the third row is much more interesting where you can actually see the difference between active cases and confirmed cases in an area chart so that you can see can observe here basically there is a kind of green lighter green zone which is basically if it is getting bigger and bigger and bigger that means we are going in a positive direction that means also we have less and less active cases and most probably the confirmed cases are are are in the same level so we can have the same grab the same graph sorry charts area charts for debt and mrs. recover cases so I guess everybody is curious now to know how to build this dashboard I'm going to give you some sort of guideline not to achieve this result so the first thing that you have to do is to build a custom table and make sure what you want to have in your custom table so here I have total confirmed total recovered total that these are the numbers that I'm collecting also the country and also dates okay so bring your custom table that's the first part the second one shows your API send a rest request your API with the flow designer action a pass your response get your outputs and once you have done all these things on show successful with that take the code snippet available in the flow designer action once you publish the attraction so that cold you can put it in the datasource so when you create a data source you can you have different type of data source and one type of data source is a load bi script they are source so you can select that one put the script that you have in your code snippet and you have to add more script basically you have the output at this level but you need to insert a map into your staging table you have to create a map right so you need to write a code for that specifically and you you're going to run your data source at this point it is actually going to call the flow design our action get the output create the map insert the result into your staging table and then create your transform map which is actually going to take the data that you have in your staging table put into your target table so in our case the target table is a custom table that we have built and make sure here that if you repeat the process so if you schedule the data import so if you do that one three three times a day I'm doing it like every three hours then you have Qualis option for certain fields set to true because otherwise it will create the same I mean the recording you have multiple records from the same date okay so and once you have all the data into your table so the next thing is to just build create widgets with indicators indicators sauce from the indicators breakdowns in some cases here I brought for some indicators some script okay it's a very two line script it's not completely so so this is I explained you like let's say not in details these are the guidelines try to find a way how you can basically bring the data into your table by having this let's say this this is not the only way there are multiple ways to do this so I chose this way because I think this kind of low-level cold okay so I'm not writing too much of course I'm trying trying to use different features that is available in the platform and trying to put the data and automate that part as well okay so that's a kind of like you have a less you spend less time by writing course okay so yeah so this was also another thing that I want to mention this is actually opening for me a new door so I am pretty much excited to go for building another dashboard by Anik for analyzing different data like data for what is the traffic congestion that we have in India hub where we can analyze there and take inside and what decision that we can make so I'd like to analyze this kind of data and I think it is possible that we can do that in performance using performance analytics and I will try to do a course detail course how we can build this entire dashboard step by step thanks for watching hope you enjoy bye