-

Project 19: Exploring evolution of Linux
1. Introduction Version control repositories like CVS, Subversion or Git can be a real gold mine for software developers. They contain every change to the source code including the date (the “when”), the responsible developer (the “who”), as well as a little message that describes the intention (the “what”) of a change. In this notebook,…
-

Project 17: Generating Keywords for Google Ads: Low cost furniture store
1. The brief Imagine working for a digital marketing agency, and the agency is approached by a massive online retailer of furniture. They want to test our skills at creating large campaigns for all of their website. We are tasked with creating a prototype set of keywords for search campaigns for their sofas section. The…
-

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 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…

