5 Data Analytics Projects for Beginners

Key takeaways

Data analytics projects allow you to develop content for your portfolio that demonstrates your skills and experience to hiring managers. 

• Data analytics portfolio projects can focus on web scraping, data cleaning, exploratory data analysis, sentiment analysis, or data visualization.

• Access public data sets and free data visualization tools as you embark on a portfolio project.

• You can add data visualizations and mini projects to your portfolio to showcase your range of skills to potential employers. 

Discover five types of projects you should include in your portfolio, especially if you’re just starting out. If you’re ready to enhance your skills, consider enrolling in the Google Data Analytics Professional Certificate. You'll have the chance to build your data cleaning, visualization, and analysis skills in as little as six months. Upon completion, you’ll have earned a career credential to add to your resume.

Data analysis project ideas

As an aspiring data analyst, you’ll want to demonstrate a few key skills in your portfolio. These data analytics project ideas reflect the tasks often fundamental to many data analyst roles. 

1. Web scraping

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. 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.

If you know some Python, you can use tools like Beautiful Soup or Scrapy to crawl the web for interesting data. If you don’t know how to code, don’t worry. You’ll also find several tools that automate the process (many offer a free trial), like Octoparse or ParseHub.

If you’re unsure where to start, here are some websites with interesting data options to inspire your project:

• Reddit

• Wikipedia

• Job portals

Example web scraping project: Todd W. 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. 

Tip: Anytime you’re scraping data from the internet, remember to respect and abide by each website’s terms of service. Limit your scraping activities so as not to overwhelm a company’s servers, and always cite your sources when you present your data findings in your portfolio.

Want insight into how employers view data analysts? Learn more about how data analysts and their portfolios are viewed by hiring managers in this lecture from Google's Data Analytics Professional Certificate:

2. Data cleaning

A significant part of your role as a data analyst is cleaning data to prepare it for analysis. Data cleaning (also called data scrubbing) is the process of removing incorrect and duplicate data, managing any holes in the data, and ensuring consistent formatting. 

As you look for a data set to practice cleaning, look for one that includes multiple files gathered from multiple sources without much curation. Some sites where you can find “dirty” data sets to work with include:

• CDC Wonder

• Data.gov

• World Bank

• Data.world

• /r/datasets

Example data cleaning project: This Medium article outlines how data analyst Raahim Khan cleaned a set of daily-updated statistics on trending YouTube videos.

Learn how to collect, clean, sort, evaluate, and visualize data with the Meta Data Analyst Professional Certificate.

3. Exploratory data analysis (EDA)

Data analysis is all about answering questions with data. Exploratory data analysis, or EDA for short, helps you explore what questions to ask. This could be done separately from or in conjunction with data cleaning. Either way, you’ll want to accomplish the following during these early investigations.

1. Ask lots of questions about the data.

2. Discover the underlying structure of the data.

3. Look for trends, patterns, and anomalies in the data.

4. Test hypotheses and validate assumptions about the data.

5. Think about what problems you could potentially solve with the data.

Example exploratory data analysis project: This data analyst took an existing data set on American universities from Kaggle in 2013 and used it to explore what makes students prefer one university over another.

10 free public datasets for EDA

An EDA project is an excellent time to take advantage of the wealth of public datasets available online. Here are 10 fun and free datasets to get you started in your explorations.

1. National Centers for Environmental Information: Dig into the world’s largest provider of weather and climate data.

2. World Happiness Report 2025: What makes the world’s happiest countries so happy? 

3. NASA: If you’re interested in space and earth science, see what you can find among the tens of thousands of public datasets made available by NASA.

4. US Census: Learn more about the people and economy of the United States with the latest Census data from 2020.

5. FBI Crime Data Explorer (CDE): Explore crime data collected by more than 18,000 law enforcement agencies.

6. World Health Organization COVID-19 Dashboard: Track the latest coronavirus numbers by country or WHO region.

7. Latest Netflix Data: This Kaggle dataset (updated in April 2021) includes movie data broken down into 26 attributes.

8. Google Books Ngram: Download the raw data from the Google Books Ngram to explore phrase trends in books published from 1800 to 2022.

9. NYC Open Data: Discover New York City through its many publicly available datasets on topics like the Central Park squirrel population and motor vehicle collisions.

10. Yelp Open Dataset: See what you can find while exploring this collection of Yelp user reviews, check-ins, and business attributes.

4. Sentiment analysis

Sentiment analysis, typically performed on textual data, is a technique in natural language processing (NLP) for determining whether data is neutral, positive, or negative. It may also be used to detect a particular emotion based on a list of words and their corresponding emotions (known as a lexicon). 

This type of analysis works well with public review sites and social media platforms, where people are likely to offer public opinions on various subjects.

To get started exploring what people feel about a certain topic, you can start with sites like:

• Amazon (product reviews)

• Rotten Tomato (movie reviews)

• Facebook

• Twitter

• News sites

Example sentiment analysis project: This blog post on Medium details how one business analyst used Python to perform a sentiment analysis of product reviews using NLP.

Read more: What Is Sentiment Analysis in Python?

Learn how to use Google Cloud for sentiment analysis from Google itself in their short, interactive project, Entity and Sentiment Analysis with the Natural Language API.

5. Data visualization

Humans are visual creatures, which makes data visualization a powerful tool for transforming data into a compelling story to encourage action. Great visualizations are not only fun to create, but they also have the power to make your portfolio look beautiful.

Example data visualization project: Data analyst Hannah Yan Han visualizes the skill level required for 60 different sports to determine which are the toughest.

Five free data visualization tools

You don’t need to pay for advanced visualization software to start creating stellar visuals, either. These are just a few of the free visualization tools you can use to start telling a story with data:

1. Tableau Public: Tableau ranks among the most popular visualization tools. Use the free version to transform spreadsheets or files into interactive visualizations (here are some examples from April 2021).

2. Google Charts: This gallery of interactive charts and data visualization tools makes it easy to embed visualizations within your portfolio using HTML and JavaScript code. A robust Guides section walks you through the creation process.

3. Datawrapper: Copy and paste your data from a spreadsheet or upload a CSV file to generate charts, maps, or tables—no coding required. The free version allows you to create unlimited visualizations to export as PNG files.

4. D3 (Data-Driven Documents): With a bit of technical know-how, you can do a ton with this JavaScript library.

5. RAWGraphs: This open-source web app makes it easy to turn spreadsheets or CSV files into a range of chart types that might otherwise be difficult to produce. The app even provides sample data sets for you to experiment with.

Bonus: End-to-end data analytics project

There’s nothing wrong with populating your portfolio with mini-projects highlighting individual skills. But if you’ve scraped the web for your own data, you might also consider using that same data to complete an end-to-end project. To do this, take the data you scraped and apply the main steps of data analysis to it—clean, analyze, and interpret. 

This can show a potential employer that you have the essential skills of a data analyst and know how they fit together.

Subscribe to Career Chat on LinkedIn

We published a newsletter about becoming a data analyst. Subscribe to keep up with the latest career tips with Career Chat.

Discover data analytics resources

Learn more about the field of data analytics by subscribing to our YouTube channel. Then, check out these helpful resources:

• Bookmark this page: Data Analysis Terms and Definitions

• Build your skills: How to Use For Loops in Python: Step by Step

• Learn from an expert: 8 Questions with an Expert: Google Financial Data Analyst

Accelerate your career growth with a Coursera Plus subscription. When you enroll in either the monthly or annual option, you’ll get access to over 10,000 courses. 

订阅 Coursera Plus，培养就业技能

开始为期 7 天的免费试用

• 
• 
• 
• 

开始为期 7 天的免费试用

Frequently asked questions (FAQ)