When it comes to names, what makes one timeless and another trendy? Join me in this exciting data exploration project, where we dive into data provided by the U.S. Social Security Administration, covering over a century of American baby name trends.
In this project, I leveraged my SQL skills for data manipulation and joins to gain insights. I explored various aspects such as ranking, grouping, ordering, and pattern matching, all within the SQL framework. These SQL skills are incredibly versatile and have wide-ranging applications. Understanding how preferences and trends change over time is not only a valuable skill for businesses but also for parents seeking that perfect baby name!
- Classic American names
- Timeless or trendy?
- Top-ranked female names since 1920
- Picking a baby name
- The Olivia expansion
- Many males with the same name
- Top male names over the years
- The most years at number one