My Courses are now Free
A few months ago I announced a change in direction: rather than continuing to focus on Choroplethr-related development and introductory R training, I was going to focus on the broader field of Analytics Engineering. Today I am happy to announce that that effort has resulted in a new job. I am joining a marketing analytics […]
Continue readingA Guide to SQL Window Functions for Data Analysts
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 readingReader Questions about Analytics Engineering
Last 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 readingSomething New: Analytics Engineering
I 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 readingExploring the Demographics of US Congressional Districts in R
I 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 reading