Name: Patrick Mugisha

Data source: https://data.humdata.org/dataset/novel-coronavirus-2019-ncov-cases

Business Intelligence Questions

Data Ready for Analysis Would Look Like This!

Data needs reshaping

How to Transform Real-World Data to Data Ready for Analysis

Transpose

Melt

"The top-level melt() function and the corresponding DataFrame.melt() are useful to massage a DataFrame into a format where one or more columns are identifier variables, while all other columns, considered measured variables" Source

What is the worldwide trend of COVID-19?

The above chart shows an increasing trend. Of course, the data is about the aggregated cases of each country.

What is the worldwide trend based on daily cases?

How is the United States doing?

What countries are doing better than others?

Conclusion

  1. Real-world data is not ready for analysis.
  2. Read-world data needs to be cleaned and transformed.
  3. Pandas (Python) is a valuable tool for data cleaning and transformation.