COVID-19 has led to a devastating pandemic all across the world, and we currently have been able to gather data from January 2020 to December 2020 and the goal of our team is to analyse the data to prevent another pandemic in the future. However, our senior data engineer has resigned and he was a specialist in Excel, which we store all our data and we would like to migrate our Excel data to another database.

# Requirements
We've realised the slow tendencies of Excel and to complete our tasks, we will need to move to another database, possibly SQL or NoSQL, but we have no technical experience. We need your help to build us two databases, one in SQL and another in NoSQL, then you will need to move the data from Excel, into both databases.

The reason we are choosing both databases, is so we can experiment with both and understand which would suit our needs. We have done basic research and believe the following two databases would be a good start:

* [MySQL](https://www.mysql.com/)
* [MongoDB](https://www.mongodb.com/)

Even though we've recommended those databases, you are free to move the Excel data into any other database, you do not need to use those two specifically, you can find the file [here](https://github.com/FHaisal/civati-project-resources/blob/main/COVID-19%20data%20migration%20from%20Excel%20to%20MySQL%20%26%20MongoDB/COVID_19_2020_Data.xlsx).

# Resources
You can find the Excel data source here
* [COVID_19_2020_Data.xlsx](https://github.com/FHaisal/civati-project-resources/blob/main/COVID-19%20data%20migration%20from%20Excel%20to%20MySQL%20%26%20MongoDB/COVID_19_2020_Data.xlsx)



Civati

COVID-19 data migration from Excel to MySQL & MongoDB

No submissions

Similar Projects

COVID-19 data migration from Excel to MySQL & MongoDB

No submissions

Similar Projects

.css-1hnz6hu{position:static;}.css-1hnz6hu::before{content:'';cursor:inherit;display:block;position:absolute;top:0px;left:0px;z-index:0;width:100%;height:100%;}Develop an API that exposes our COVID-19 data

Web scrape COVID-19 data using Python

Develop a fully working dashboard to display COVID-19 data

Develop an API that exposes our COVID-19 data