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 »
Author: pivotteam
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 »
Pivot Billions Docker Release Announced
Pivot Billions (PB) is now officially available for download via Docker Hub. See our Press Release on PRWeb. With PB on Docker, anyone can try it out for Free! Just install Docker, if you don’t already have it, and then follow the install instructions for PB found here. When you are finished, access locally on […] continue reading »