In 2017, I whipped up a quick post to summarize some reusable Extract Transform Load (ETL) functions using Python and Pandas. To my pleasant surprise, it still receives a steady stream of visitor traffic. That… Read More »ETL Using Python and Pandas: Part 2
Having rolled out Backstop last winter, life has been generally awesome. After an extensive Extract, Transform, and Load (ETL) effort, global end-user training sessions, and an ongoing pruning process, the data is close to a sparkling clean state.… Read More »Backstop CRM: Contact and Relationship Hacks
I was working on a CRM deployment and needed to migrate data from the old system to the new one. The 50k rows of dataset had fewer than a dozen columns and was straightforward by… Read More »ETL Using Python and Pandas