Overview
In this project, you'll take on the role of a data professional at a marine biology research organization. Your task is to prepare a raw dataset on shark attacks so the analysis team can study trends in attack location and frequency over time.
You'll import the dataset into Excel, plan your preparation approach, and work through a systematic cleaning process. This includes removing duplicate records and unneeded columns, handling missing values, resolving inconsistent data types, and consolidating the results into a single, analysis-ready table. Along the way, you'll build practical habits for tackling the messy data that is common in real-world projects.
Objective: Use Excel to import, organize, and clean a real-world shark attack dataset, delivering a structured file ready for the analysis team.
What You'll Learn
- ✓ Import data into a spreadsheet from more than one data source
- ✓ Organize data into a spreadsheet using worksheets and tables
- ✓ Clean data by removing duplicates and irrelevant data
- ✓ Work with missing data and inconsistent data types
- ✓ Consolidate the data for analysis
Project Steps
10 steps
- 1 Introduction
- 2 Your Scenario
- 3 Planning Your Approach
- 4 Cleaning Your Data
- 5 Data Cleaning Continued
- 6 Data Cleaning Final Steps
- 7 Verifying That Your Data is Clean
- 8 Use Visualizations
- 9 Handling Issues
- 10 Next Steps
Join 1M+ data learners on Dataquest.
- 1
Create a free account
- 2
Choose a learning path
- 3
Complete exercises and projects
- 4
Advance your career