Ben Ahnen

St. Paul to Minneapolis Traffic Analysis - 2022

In this project, I analyzed west bound traffic data between St. Paul and Minneapolis, looking at what weather patterns contributed to the amount of traffic.

Situation: St. Paul to Minneapolis west bound traffic from 2012 until 2018.

Data: This project will use data that is publicly available from the UCI Machine repository website. I downloaded data from the specified time period and loaded it into R. The CSV files contain data pertaining to the date the traffic was captured.

Question: I wanted to explore and answer, “Does certain weather types or time of the year cause traffic levels to increase or decrease?”

Hypothesis: I suspect that weather types will have some impact on the average traffic, however I believe clear skies will have the highest average traffic volume because more people will want to be outside and traveling.

MLB Lineup Web Scrape - 2022

In this project, I created a script in python to web scrape the predicted MLB lineups according to rotowire. The data frame then gets exported into an excel file with the following fields: Batting Order, Player Name, Position, Team, Opponent, Home/Away, Handedness, and the Lineup Status. Check out the example output from 8/17/22, located in the project repository.

Supply Chain Crisis: Reddit Analysis - 2021

In this project, my team and I analyzed reddit threads pertaining to the supply chain crisis, looking to see how the public perceived the lasting impacts of the crisis.

Situation: Reddit posts pertaining to the supply chain crisis from November 2021.

Data: This project will use data that is webscraped from reddit. We downloaded data from the specified time period and loaded it into R. The CSV files contain data pertaining to the date the reddit threads were posted.

Question: we wanted to explore and answer, “How are reddit users feeling about the supply chain crisis?”

Hypothesis: We suspect that individuals will largely have a negative outlook due to the holiday season coming up and people worrying about ordering/receiving their gifts on time.

Liquor Sales In The State of Iowa Post Spring 2020 - 2020

In this project, my team and I analyzed how the COVID-19 pandemic impacted liquor sales in the state of Iowa. Our preliminary research showed that liquor sales had increased by nearly 40% at the beginning of the pandemic, but we wanted to see what was specifically driving that increase.

Situation: Iowa liquor sales from the beginning of 2019 until 2021, provided by the state of Iowa.

Data: Due to the size of the file, only a subset of the data is included in the repository. This project uses data that is publically available from the data.iowa.gov website. We downloaded data from teh specified time period and loaded it into SQL and Tableau.

Question: Our group would like to explore and answer multiple questions: 1) What is the size and make up of Iowa's liquor retial market? 2) Who are the largest liquor vendors in the state by sales? 3) Which retailors have the strongest market position? 4) Which liquor products are the most popular? 5) Which regions purchase the most liquor?

Hypothesis: We suspect that various grocery stores will be the largest sellers of liquor. Our initial thought would be that the Des Moines metro would have the largest sales volume by region due to having the largest population, however because they are not home to any of the state universities we believe that could cause our hypothesis to fail.

How Do Iowans Purchase Liquor - 2020

In this project, my team and I created an analysis of how, when, and where Iowans buy liquor.

Situation: Iowa liquor sales from the beginning of 2019 until 2021.

Data: Due to the size of the file, only a subset of the data is included in the repository. This project uses data that is publicly available from the data.iowa.gov website. We downloaded data from the specified time period and loaded it into R. The CSV files contain data pertaining to the date the liquor was sold, regional information on the sale, quantity sold, and total sales amount in dollars from January 2019 until 2021.

Question: Our group would like to explore and answer, “Did the pandemic cause liquor sales to increase or decrease?”

Hypothesis: We suspect that there will be a large increase in the sale of liquor prior to the initial closing of businesses due to public hysteria. However, once the public realizes that the pandemic is here to stay, we expect there to be increased liquor sales overall.

Hidden Statistics in College Football - 2020

In this project, my team and I compared the 2019 college football season by region and conference to see which areas of the country were most dominate.

Situation: 2019 college football season.

Data: This project uses data that is publicly available from the Kaggle, Sports Reference, and the US Census Bureau. We downloaded data from the 2019 college football season and loaded it into R. The CSV file contains data pertaining to the 2019 season, delineated by teams. Within R we further broke down the data by conference and region data through data manipulation.

Question: Our group would like to explore and answer, “Are the south and SEC really the best region and conference in college football?”

Hypothesis: We suspect that the south and SEC will be up there for the top region and conference but believe the midwest and Big 10 will be close, if not better.

Video Game Data Analysis - 2019

In this project, my team and I compared historic video game sales data to see if what genre of game sold the best, as well as if platform or critic score impacted these results.

Situation: Historic video game sales through 2016.

Data: This project uses data that is publicly available from the Kaggle. We downloaded historic video game sales data and loaded it into Python. The CSV file contains historical video game data such as sales, platform, and critic score. We were able to manipulate the data to get summary statistics of the data.

Question: Our group would like to explore and answer, “What video game genre sold the best?”

Hypothesis: We suspect that shooter games will sell the best due to the franchise success of both Call of Duty and Grand Theft Auto.

AT&T - Time Warner Merger Deck - 2019

In this deck, my team and I analyzed the 2016 AT&T and Time Warner merger.

Situation: 2016 AT&T and Time Warner Merger.

Data: This project uses various publically available data and articles to analyze the information and formulate a conclusion on the merger and the stance our hypothetical political candidate should take.