Brock Johnson

Logo

Hi, nice to meet you. My name is Brock

I love the outdoors, sports, and books

View My LinkedIn Profile

View My GitHub Profile

Welcome to My Portfolio


Explore My Projects

Capstone: Europe’s Top 5 Football Leagues

In this capstone project for Data Analytics Accelerator, I wanted to analyze football data. The main focuses were: Which players are the top performing in Goals and Assists? What is the expected Goals % and why is that important? What is the peak age for scoring goals? Which Competition has the most Yellow and Red Cards? Does the Attendance in a Home game affect the outcome of the Match?


DoorDash Project with Excel

In this case study from Data Analytics Accelerator, I was prompted to analyze the effect of food delivery data. The main focuses were: What is the average and total amount of money spent by each customer? Does the income of customer affect the money spent? What is the age range of customers using DoorDash®? Does the amount of children in the home affect DoorDash® usage?


Education Project with Tableau

In this case study from Data Analytics Accelerator, I was prompted to analyze the State of Massachusetts education data. The main focuses were: What schools are struggling the most? How does class size affect college admission? What are the top math schools in the state?


World Bank Project with SQL

In this case study from Data Analytics Accelerator, I was prompted to analyze the World Bank data. The main focuses were: What do the transactions and loans amount look like? Which countries are borrowing the most and for what purpose? How has Ukraine been affected in recent times with the World Bank?


SQL Healthcare Project

In this case study from Data Analytics Accelerator, I was prompted to analyze hospital data by using SQL queries. The main focuses were: Which medical specialities are the most important for optimizing hospital operations? Does the time in the hospital affect how many procedures a patient has? Does race play a role in hospital treatment?


NBA Tableau Project

In this case study from Data Analytics Accelerator, I was prompted to analyze NBA data from 2022-2023. The main focuses were: What position is most efficient at shooting 3-pointers for each team? How did individual players perform last season in terms of points, assists, and total rebounds? What were the total points for each team and how much did each player contribute? What players had the most assists in every position?


Python Processing Project

In this case study from Data Analytics Accelerator, I was prompted to analyze data from a manufacturing company that specializes in Froth flotation process. The main focuses were: Understanding how Python is used to help triangulate and clean data. If there were any anomalies found and what they mean.


R Attrition HR Project

In this case study from Data Analytics Accelerator, I was prompted to analyze data from IBM to look into their Attrition rates through HR. The main focuses were: Looking at correlations between age and other factors. Proving wrong false claims about ageism and longevity.