Blog Post

Educator Developer Blog
1 MIN READ

Get 40+ Datasets for Your Data Analysis Projects

theoyinbooke's avatar
theoyinbooke
Icon for Microsoft rankMicrosoft
Jun 14, 2022

 

 

Is Data Truly Everywhere?

I would like to start our Day 2 engagement from here. If data is truly everywhere, why is it difficult for data enthusiasts to find public dataset to work with across several sectors/industries? Well, data is actually out there in their numbers just that most enthusiasts do not know how to get them or how to work with them.

 

Today's main focus is a quest for data. Let's go out there and check if truly there are public datasets for your project portfolio. Watch this video to see how to download 40+ sample datasets for your personal projects

 


 

 

I believe you paused the video and follow through, if you didn't, kindly do so now. make sure you have at least 40 datasets downloaded on your PC. that's a very good place to start.

 

COVID19 Stunning Dashboard in Excel

Tomorrow, we will have a live session where we get to build a stunning storytelling dashboard for COVID19 Data with Excel. Yes, Microsoft Excel can also be used to build a stunning and interactive dashboards.

 

For today, I will should you how to import COVID19 Data into Excel. Watch the video below for the session

 

 

Assignment

  • Follow the video and download at least 40 Sample Data sets on your Machine. Put them in a folder
  • Follow the Web Scraping video and scrap COVID19 Dataset in Excel and save the file 

Additional Resources

 

 

Updated Jun 26, 2022
Version 2.0
  • eboham you are to go to the Data Tab on your Excel. you should see the option for Get Data. kindly use it

     

  • eboham's avatar
    eboham
    Copper Contributor

    theoyinbooke I can't seem to have the data "from web" in my Office 365. Can I get some assistance on how to scrap the covid data?

     

  • Nwokocha's avatar
    Nwokocha
    Copper Contributor

    While transforming data using power query, I keep getting an expression error which reads that "Expression.Error: The column 'Column1' of the table wasn't found.
    Details:
    Column1". How do I avoid this error

  • Yeammy's avatar
    Yeammy
    Copper Contributor

    How can I be part if this live training class?

    I registered for the Imagine Cup but finding I don't get notifications on when the class is starting, or probably I have not been added to the membership area.

    I will appreciate if I can be included in this ongoing 30 days challenge. Thanks

    #TheOyinbooke