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
Academic
data
student
  • data_dr280's avatar
    data_dr280
    Copper Contributor
    Jun 23, 2022

    The complain is true sir. The office365 Excel on our side does not have the Get Data Tab and even analyze Data. I added the add-in already but it's not showing up. This complaint is similar to a number of us. theoyinbooke 

  • theoyinbooke's avatar
    theoyinbooke
    Icon for Microsoft rankMicrosoft
    Jun 23, 2022

    data_dr280 , this issue has been resolved. In most cases, the Excel you are using isn't that of Office 365. 

    Signing in with your Developer Account will not turn it to Office 365. All you need to do is to uninstall the current version of Excel and Install directly from office portal https://office.com 

  • Shunlexxi's avatar
    Shunlexxi
    Brass Contributor
    Jul 01, 2022

    ebohamFaith_Oseghale data_dr280 

    I must confess that I'm getting to understand Microsoft Apps and Services better (than I do... Really!)


    I ran into a problem as many others also did; couldn't find "import from web" on Excel (web). I tried reaching out but you will agree with me that the community is quite populated and monitoring all message is (perhaps) impossible, hence I decided to share my findings with as many having same issue.

    First, Microsoft 365 (which include Office 365 Apps; Word, Excel, Powerpoint...) can be categorized into;

    Microsoft/Office Desktop (the one you install on your PC)
    Microsoft/Office Web App/Services (when you use it via your browser)

    Is the above clear? as it will help you continue.

    There are some features that aren't available yet on the web version (Microsoft/Office services/Web App), meaning you can only access them when you download and install Microsoft packages (say Excel) on your PC, unfortunately, the "import from web" is one of them.

    [if you noticed @theoyinbooke used Excel Desktop to scrape the COVID 19 data in the walkthrough, though he didn't explicitly mention it (you may go back to the video to be sure]. Also, let me mention that you need to be connected to the internet (Just in case)

    You may checkout Microsoft documentation to figure out the differences between the WEB (version) of EXCEL and the DESKTOP (version) here;

    https://support.microsoft.com/en-us/office/differences-between-using-a-workbook-in-the-browser-and-i...

    https://support.microsoft.com/en-us/office/data-import-and-analysis-options-3ea52160-08bc-45ac-acd9-...

    Also, checkout my blog! I hope this helps!

  • Yeammy's avatar
    Yeammy
    Copper Contributor
    Jun 14, 2022

    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

  • Nwokocha's avatar
    Nwokocha
    Copper Contributor
    Jun 14, 2022

    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