colinberan92

Exploratory Data Analysis of Magic: The Gathering Cards

I’ve been a pretty avid Magic: The Gathering fan since high school and I recently came upon a great source of JSON files of what appears to be every single MTG card and set ever printed (here) so I couldn’t help but do an exploratory analysis of this data to see what kind of insightsContinue reading “Exploratory Data Analysis of Magic: The Gathering Cards”

Exploratory Data Analysis of NYC Taxi Data

Another quick exploratory analysis of NYC Taxi data. Once again a project from the 3rd course of the Google Advanced Data Analytics Professional Certificate. In this one I was asked to create a map of New York City taxi trips in Tableau which was a fairly interesting endeavor. I didn’t have any geographic data givenContinue reading “Exploratory Data Analysis of NYC Taxi Data”

The Omega Protocol (Ultimate) Damage Done Dashboard

Back with another Final Fantasy XIV dashboard, this time for the most recent (and quite difficult) encounter, The Omega Protocol (Ultimate). I started out this one by using GraphQL to collect data through the FFLogs API and imported the data into Google BigQuery. I ran a few SQL queries to preprocess the data (the queriesContinue reading “The Omega Protocol (Ultimate) Damage Done Dashboard”

Dragonsong’s Reprise Damage Taken Exploration

Hello! What I have here today is another look at the same Dragonsong’s Reprise (Ultimate) clear from Final Fantasy XIV, but this time it’s damage taken. Rather than just clone the same boring dashboard from before, I wanted to do a bit of Python work so I did a bit of a dive into theContinue reading “Dragonsong’s Reprise Damage Taken Exploration”

Final Fantasy XIV Data Studio Dashboard

Dashboard created using Google’s Data Studio tool for the purposes of visualizing data gathered through my group’s clear of the Final Fantasy XIV raid Dragonsong’s Reprise (Ultimate).Data was gathered through the use of the FFLogs API and uploaded onto a Microsoft SQL Server. I took the relevant data from there and uploaded it to Google’sContinue reading “Final Fantasy XIV Data Studio Dashboard”

Old School Runescape Hiscores

Python exploration of Old School Runescape Hiscores data gathered on July 21st, 2022. Two small projects here: 1. Boss kill count tracking for one particular username. When executing the code, the user is prompted for a case-sensitive OSRS username and then they are given a table of information including all bosses and that user’s killContinue reading “Old School Runescape Hiscores”

LastFM Customer Value Scoring

Using the sampled dataset found here, I created a simple customer scoring model based on an RFM (Recency, Frequency, Monetary) model, replacing the monetary value with a “uses per day” value. This information was created with the intent of hypothetically implementing a monetization system into LastFM’s service. Check out the GitHub repository for more info.

COVID-19 Vaccination Progress Analysis (Python)

This is a short analysis of the COVID-19 World Vaccination Progress dataset by Gabriel Preda over on Kaggle. (A follow-up of the R version I posted.) I used Python to analyze this dataset and generated plots that show the progress we’ve been making in vaccinating against COVID-19. Check out the full notebook on Kaggle or the outputs on GitHub.

COVID-19 Vaccination Progress Analysis (R)

This is a short analysis of the COVID-19 World Vaccination Progress dataset by Gabriel Preda over on Kaggle. I used R to analyze this dataset and generated plots that show the progress we’ve been making in vaccinating against COVID-19. Check out the full notebook on Kaggle or the outputs on GitHub.

Data Exploration of Video Game Sales (Python)

This is a follow-up on the exploration of the Video Game Sales dataset by GregorySmith on Kaggle, this time using Python. It’s essentially the same information as before, this time there’s a bit more regional comparison. Take a look at the full exploration on Kaggle or the outputs on GitHub.