Skip to main content
HomeSQLAnalyzing American Baby Name Trends
Premium project

Analyzing American Baby Name Trends

Use categorization and ranking techniques to explore 101 years of American baby name tastes.

Start Project
8 Tasks1,500 XP

Loved by learners at thousands of companies


Project Description

What makes a name timeless or trendy? In this project, you'll use data published by the U.S. Social Security Administration spanning over a hundred years to understand American baby name tastes.

The ranking, grouping, joining, ordering, and pattern matching skills you'll use in this project are broadly applicable: understanding changing tastes is a key competency for businesses as well as parents searching for a baby name!

Project Tasks

  1. 1
    Classic American names
  2. 2
    Timeless or trendy?
  3. 3
    Top-ranked female names since 1920
  4. 4
    Picking a baby name
  5. 5
    The Olivia expansion
  6. 6
    Many males with the same name
  7. 7
    Top male names over the years
  8. 8
    The most years at number one

Technologies

SQL SQL

Topics

Data Manipulation
Izzy Weber HeadshotIzzy Weber

Data Coach at iO-Sphere

Izzy is a Data Coach at iO-Sphere. She discovered a love for data during her seven years as an accounting professor at the University of Washington. She holds a masters degree in Taxation and is a Certified Public Accountant. Her passion is making learning technical topics fun.
See More

FAQs

What do other learners have to say?