Table of contents
No headings in the article.
I am still in this data journey and still learning new thing everyday is an opportunity to learn and I always look forward to it, In this series I will be analyzing the covid 19 pandemic data set was gotten from GitHub 30days of learning.
WEBSCRAPPING OF DATA Data was scrapped from CSSEGIS and data/COVID 19 into excel spreadsheet.
Note; I then merge the confirmed, recovered and death cases in power query on excel
TRANSFORMING DATA I changed the various data types to what they should be numbers were formatted as numbers as well as date and text.
Also date was split into month, day and year using the formulas.
ANALYSIS I Created a pivot table to be able to analyse the data.
DASHBOARDING The data was later loaded into power bi
Final a dashboard was created to give insight on my findings.
.
Thanks for reading, hope this was insightful.