Overview It’s been a few weeks since we posted something in our 5 Minute Analysis series, so we decided to do two quick analyses on two different datasets we found on Kaggle. Instead of doing the analysis locally using PivotBillions on Docker, we opted to run the analysis in the free cloud version available on […] continue reading »
Category: 5 Minute Analysis
Finding Underutilized Kaggle Data
Overview In this 5 Minute Analysis we are exploring a Kaggle dataset about Kaggle datasets. This dataset lets us see a list of the datasets on Kaggle, and shows which ones have the most engagement and activity. Our goal is to explore and filter the data to find popular datasets with many downloads but very […] 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 »
Getting the Whole Picture of Retail Sales
Overview It should be apparent that we like to use data sets found in Kaggle. If you are not familiar with Kaggle, you should check out their website to peruse the thousands of great datasets available for free to play around with. In this 5 Minute Analysis of the Kaggle Retail Data Analytics we explore historical […] continue reading »
Olympics Data Reveals Rising Gender Equality
Overview In this 5 Minute Analysis of the Kaggle historical Olympic athletic data we filtered and pivoted the data in various ways to understand the trends in participation by gender over time. Steps 1. Load the Data and View its Structure The steps for loading data was covered in a previous post. 2. View and Explore the […] continue reading »
Breaking Down Los Angeles Health Code Violations
This is the first in a series of practical application examples of Pivot Billions that we will be calling 5-Minute Analysis. Each week, we’ll take an interesting open data set and use Pivot Billions to find interesting insights within a five minute span. Overview Accessing and understanding the Kaggle LA Restaurant & Market Health Data in […] continue reading »