I’m delighted to share the projects I've completed!😊
My goal is to provide solutions for business challenges and objectives while enhancing my SQL querying skills.
Please note that this repository may be updated periodically as I add new completed projects.
- Introduction to Notebook Projects
- Analyzing Baby Name Trends
- When Was the Golden Era of Video Games
- Analyze International Debt Statistics
- Analyzing Electric Vehicle Charging Habits
- Analyzing Industry Carbon Emissions
- Analyzing Students Mental Health
- What and Where are the World's Oldest Businesses
PROJECT DESCRIPTION:
This introductory project taught me how to work with DataLab notebooks and utilize them to solve DataCamp projects. I learned about notebooks and cells and how to use them to address problems in Python, SQL, and R projects. This prepared me to tackle my first real notebook-based project!
👨💻 do the project here
💡 view my solution here
PROJECT DESCRIPTION:
What makes a name timeless or trendy? In this project, I analyzed data from the U.S. Social Security Administration, covering over a century, to explore American baby name preferences. The skills I utilized—ranking, grouping, joining, ordering, and pattern matching—are widely applicable. Understanding evolving tastes is crucial not only for businesses but also for parents selecting a baby name!
👨💻 do the project here
💡 view my solution here
PROJECT DESCRIPTION:
According to Mordor Intelligence, video games are big business: the global gaming market is projected to be worth more than $300 billion by 2027. With so much money at stake, the major game publishers are hugely incentivized to create the next big hit. But are games getting better, or has the golden age of video games already passed?
In this project, I analyzed video game critic and user scores, in addition to sales data for the top 400 video games released since 1977. I searched for a golden age of video games by identifying release years that users and critics liked best, and I explored the business side of gaming by looking at game sales data.
👨💻 do the project here
💡 view my solution here
PROJECT DESCRIPTION:
In this project, I analyze international debt data collected by The World Bank. The dataset contains information about the amount of debt (in USD) owed by developing countries across several categories. I used my data manipulation skills to find out which countries have the highest and lowest amounts of debt.
👨💻 do the project here
💡 view my solution here
PROJECT DESCRIPTION:
As electronic vehicles (EVs) become more popular, there is an increasing need for access to charging stations. I used a dataset containing information on station usage to help apartment building managers better understand their tenants’ EV charging habits.
👨💻 do the project here
💡 view my solution here
PROJECT DESCRIPTION:
Product emissions make up more than 75% of global emissions. But which industries are the worst offenders? I used my SQL skills to investigate!
👨💻 do the project here
💡 view my solution here
PROJECT DESCRIPTION:
Studying abroad can be both exciting and difficult. But what might be contributing to this? One Japanese international university decided to find out! I used my data manipulation skills to explore the data from a study on the mental health of international students, and found out which factors may have the greatest impact.
👨💻 do the project here
💡 view my solution here
PROJECT DESCRIPTION:
An important part of business is planning for the future and ensuring that the business survives changing market conditions. Some businesses do this remarkably well and last for hundreds of years. In this project, I explored data from BusinessFinancing.co.uk on the world's oldest businesses.
👨💻 do the project here
💡 view my solution here