Latest
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 insights…
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 given…
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 queries…
Colin Beran 