-
Project 16: Analyzing Motercycle Part Sales
You’re working for a company that sells motorcycle parts, and they’ve asked with some help in analyzing their sales data! They operate three warehouses in the area, selling both retail and wholesale. They offer a variety of parts and accept credit card, cash, and bank transfer as payment methods. However, each payment type incurs a…
-
Project 15: Analyzing Industry Carbon Emissions
Photo by Maxim Tolchinskiy on Unsplash Greenhouse gas emissions attributable to products—from food to sneakers to appliances—make up more than 75% of global emissions. –The Carbon Catalogue Our data, which is publicly availably on nature.com, contains product carbon footprints (PCFs) for various companies. PCFs are the greenhouse gas emissions attributable to a given product, measured in CO2 (carbon…
-
Project 14: Analyzing Student’s Mental Health using SQL
Does going to university in a different country affect your mental health? A Japanese international university surveyed its students in 2018 and published a study the following year that was approved by several ethical and regulatory boards. The study found that international students have a higher risk of mental health difficulties than the general population.…
-
Project 13: Analyzing Unicorn Companies
Did you know that the average return from investing in stocks is 10% yearly! But who wants to be average?! You have been asked to support an investment firm by analyzing trends in high-growth companies. They are interested in understanding which industries produce the highest valuations and the rate at which new high-value companies emerge.…
-
Project 12: Optimizing Online Sports Retail Revenue
1. Counting missing values Sports clothing and athleisure attire is a huge industry, worth approximately $193 billion in 2021 with a strong growth forecast over the next decade! In this notebook, we play the role of a product analyst for an online sports clothing company. The company is specifically interested in how it can improve revenue. We…
-
Project 11: Analyzing American baby name trends over 100 years
1. Classic American names Photo by Travis Wise on Wikimedia. How have American baby name tastes changed since 1920? Which names have remained popular for over 100 years, and how do those names compare to more recent top baby names? These are considerations for many new parents, but the skills we’ll practice while answering these queries…
-
Project 10: Golden Age of Video Games
1. The ten best-selling video games Photo by Dan Schleusser on Unsplash. Video games are big business: the global gaming market is projected to be worth more than $300 billion by 2027 according to Mordor Intelligence. With so much money at stake, the major game publishers are hugely incentivized to create the next big hit. But are games getting…
-
Project 9: Analysis of NYC Public School Test Results for SAT
1. Inspecting the data Photo by Jannis Lucas on Unsplash. Every year, American high school students take SATs, which are standardized tests intended to measure literacy, numeracy, and writing skills. There are three sections – reading, math, and writing, each with a maximum score of 800 points. These tests are extremely important for students and colleges, as they…
-
Project 1: The World Bank’s international debt data
It’s not that we humans only take debts to manage our necessities. A country may also take debt to manage its economy. For example, infrastructure spending is one costly ingredient required for a country’s citizens to lead comfortable lives. The World Bank is the organization that provides debt to countries. In this notebook, we are going to…
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Ram Rallabandi 