I recently learned about a (somewhat) new feature in MySQL called Window functions. From the perspective of an analyst, Window functions are fantastic: they allow you derive more information about your data without leaving the database. This reduces your need for custom statistical software such as R. Unfortunately, most of the tutorials that I read […]
Continue readingLast week I announced a new focus for my blog: codifying my thoughts around the new role of Analytics Engineering. The post led to some interesting exchanges with longtime readers. I thought that two of these questions, along with my responses, might interest a wider audience, so I am copying them here. Q1: How does […]
Continue readingI started this blog in 2015 to serve as reference material for Choroplethr, my open source R package for mapping demographic statistics. A lot has changed since then, and I’ve decided to start using this space for something else: to codify my thoughts on the new field of Analytics Engineering. As a software engineer, there […]
Continue readingI recently created a few datasets to facilitate analyzing the interaction between demographics and political party affiliations of US Congressional Districts. My goal was to create this graph: I added this data to Choroplethr and pushed the new version to CRAN. This post walks you through using these datasets, the analysis I did, and the […]
Continue readingChoroplethr v3.6.4 is now on CRAN. This is the first update to the package in two years, and was necessary because of a recent change to the tigris package, which choroplethr uses to make Census Tract maps. I also took this opportunity to add new example demographic data for Census Tracts. Quick Demo The first […]
Continue reading