SQL Basics using DuckDB

tutorial
I’ve been wanting to put together a simple resource for learning the basics of querying data with SQL for some time now. However, one of the…
Aug 20, 2023

Configuring Pandas with Yaml Files

tutorial
Reading data from files into pandas dataframes is largely straight-forward and easy to do. Choose the right input function depending on the file type, pass in the filepath, and add a few…
Aug 19, 2023

Treating Diagrams Like Code

blog
There is a common saying in software development that “code should speak for itself” and while I agree with the ideas…
Jun 19, 2023

Goodbye Pelican, Hello Quarto

blog
Seven years ago, I first published a Jekyll blog…
Feb 20, 2023

I Can Python, So Can You

tutorial
Before I left Aspire, I had started an internal training on…
Feb 11, 2023

Parsing Texas Assessment Data

tutorial
Data files available here on the TEA website.
Jan 29, 2022

Creating WordClouds

tutorial
Text analysis is hard, but one simple visual tool for extracting insights from dense text are word clouds. Word clouds help identify…
Feb 4, 2021

Auto-generated REST API for MS SQL database

blog
Suppose you have a database with tables and views that you want to…
Jan 16, 2021

Virtual K-12 Tableau User Group - 14 January 2021

projects
In the wake of COVID19, we needed to provide our schools with a way to identify students who would most benefit from additional supports to access distance learning.
Jan 14, 2021

How I Teach Git

blog
When I first learned to use Git, it supercharged my development and I was quickly sold on its value, but I had no real…
Jan 13, 2021

Normalize JSON with Pandas

tutorial
When processing nested JSON data into a flat structure for importing into a relational database, it can be tricky to structure the data into the right shape. Pandas has a great tool for doing…
Jan 12, 2021

InnovateEDU Webinar - 19 November 2020

projects
In the wake of COVID19, we needed to provide our schools with visibility into student engagement with distance learning. The majority of our schools were using Google Classroom as their LMS (Learning…
Nov 19, 2020

My Manager README

blog
When I transitioned from being primarily a software…
Aug 8, 2018

Automating Developer Environment Setup

blog
I develop on Linux. Ubuntu to be specific.…
Feb 18, 2018

Resolutions for the New Year

blog
Well, it’s 2018 and it’s been two years since I last made an update to my blog. I originally published it to test out Jekyll and to put something basic on my personal domain. I was working with Ruby on…
Jan 21, 2018

How Memes Inform My Work

blog
I remember fondly how excited I was the first time I understood an obscure coding joke on r/programmerhumor. It felt…
Jan 21, 2018

Student Email Sync

projects
To pull automatically generated student email addresses from our MS SQL data warehouse and push into production PowerSchool instances in multiple states.
May 31, 2016
No matching items