PinnedAndrew DossinThe Inner JoinThe NFL Combine in Two DimensionsExploring data with Principal Component Analysis11 min read·Jun 8, 2021--1--1
PinnedAndrew DossinThe Inner JoinWhat Makes Simone Biles the GOAT?An analysis of elite women’s all-around gymnastics scores8 min read·Jul 20, 2021--3--3
PinnedAndrew DossinThe Inner JoinMaking a Simple Data Pipeline Part 1: The ETL PatternSchedule Python and SQL scripts to keep your dataset clean and up-to-date in a Postgres database7 min read·Aug 19, 2021----
Andrew DossinThe Inner JoinHow Our Interests Changed During the PandemicHere’s how U.S. Google searches for 350+ common hobbies diverged from pre-pandemic expectations6 min read·Dec 2, 2021----
Andrew DossinThe Inner JoinMaking a Simple Data Pipeline Part 4: CI/CD with GitHub ActionsUse Github Actions to automatically integrate ETL changes and republish your datasets10 min read·Oct 5, 2021----
Andrew DossinThe Inner JoinMaking a Simple Data Pipeline Part 3: Testing ETLMaintain data quality and catch bugs before your stakeholders8 min read·Sep 28, 2021----
Andrew DossinThe Inner JoinMake Your Own Air Quality LoggerLog IoT data to a cloud database using Python on a Raspberry Pi8 min read·Sep 7, 2021----
Andrew DossinThe Inner JoinIs West Coast Air Getting Dirtier?Analyzing particulate matter trends in three major Pacific metros8 min read·Aug 31, 2021----
Andrew DossinThe Inner JoinMaking a Simple Data Pipeline Part 2: Automating ETLSchedule Python and SQL scripts to keep your dataset clean and up-to-date in a Postgres database7 min read·Aug 24, 2021----
Andrew DossinThe Inner JoinDecathletes: The Track and Field GeneralistsComparing Rio Olympic Decathletes to their specialist counterparts5 min read·Jul 27, 2021----