It is the second week of the side hustle portfolio boot camp and we were tasked to make a disease health analysis with specific parameters. It was quite a tasking but worthwhile journey. Getting data was not an issue, however getting data with the indicated parameters was overwhelming. We opted for Covid-19. In this article, we give a detailed analysis on the steps we took to arrive at our dataset, how it was analyzed and the visualization process. Tool : Microsoft powerBi
We got our data from the Nigeria Centre for Diseases and Control (NCDC)
Context :
States Affected
No. of Cases (Lab Confirmed)
No. of Cases (on admission)
No. Discharged
No. of Deaths
Step 1 : Webscrapping the data using Microsoft powerBi
Note : make sure there is internet connection
Step 2 : Total number of affected states
Note : use the card visual, then you drag and drop the 'affected states' column after that then you change it to distinct count
Observation : There are 37 states in Nigeria
Step 3 : Total Cases
Note : use the card visual, then drag and drop the 'No. of Cases (Lab Confirmed)' column
Step 4 : Active Cases
Note : use the card visual, then drag and drop the 'No. of Cases (on admission)' column
Step 5 : Discharged Cases
Note : use the card visual, then drag and drop the 'No. Discharged' column
Step 6 : Deaths
Note : use the card visual, then drag and drop the 'No. of Deaths ' column
Step 7 : Number of Deaths per state
Note : use the column chart, then drag the 'states affected' column on the x-axis and 'No.of deaths' on the y-axis
Step 8 : Number of Discharged per state
Note : use the matrix table , then drag and drop the 'states affected' column and 'discharged' column
Full Dashboard
