Everyone wants to be healthy but there are many competing claims as to how you can achieve this. With so many contradictory diets, exercise routines that take enormous amounts of time and dedication, and many other perceived paths to a healthy body and mind; tying these claims to actual data becomes very necessary and useful. […] continue reading »
Category: ETL
Completing the Picture: Who is the Fantasy Football GOAT for Offense?
Fantasy football can be a relaxing past time but for anyone who takes the competition seriously, data immediately becomes very necessary. While many people track their favorite players from their favorite teams, to truly put together a winning team you need to be able to explore and understand large amounts of data. Moreover, the data […] continue reading »
Completing the Picture: Uncovering NHL MVP’s in a pile of data
Data is rarely consistent. The most consistent attribute of data is that it is usually dispersed across many files and needs to be put back together again to truly understand it. Pivot Billions dramatically improves this process and makes it easy to merge your data and start to analyze it. As an example of this […] continue reading »
Simplifying Iowa Liquor Sales Data for Loading to Tableau
Overview In this 5 minute analysis, we pre-process, map, and explore complicated public sales data for liquor stores in Iowa to extract relevant latitude and longitude from a problematic column in the data. We want to filter the data for the city with the most sales and prepare it for easy loading into the […] continue reading »