Data cleaningĪ significant part of your role as a data analyst is cleaning data to make it ready to analyze. Schneider of Wedding Crunchers scraped some 60,000 New York Times wedding announcements published from 1981 to 2016 to measure the frequency of specific phrases. If you’re unsure where to start, here are some websites with interesting data options to inspire your project:Įxample web scraping project: Todd W. You’ll also find several tools that automate the process (many offer a free trial), like Octoparse or ParseHub. If you don’t know how to code, don’t worry. If you know some Python, you can use tools like Beautiful Soup or Scrapy to crawl the web for interesting data. Plus, knowing how to scrape web data means you can find and use data sets that match your interests, regardless of whether or not they’ve already been compiled. While you’ll find no shortage of excellent (and free) public data sets on the internet, you might want to show prospective employers that you’re able to find and scrape your own data as well. These data analytics project ideas reflect the tasks often fundamental to many data analyst roles.

As an aspiring data analyst, you’ll want to demonstrate a few key skills in your portfolio.

Name any two tools for data analysis