workfintechMoving pipelines off Excel macros2022

Dagster on our own server

Everything ran on Excel macros, stored procedures and Python scripts that someone had to kick off by hand. I got us an on-site server, set up Dagster connected to GitHub, and started moving the pipelines over. Now there’s version control, one place to see what ran, easier teamwork, and a foundation for ML to come next.

How it works

Tap a step for the details.

  1. Excel macros, stored procedures and Python scripts, all run by hand.

  2. I asked for an on-site server to give the pipelines a home.

  3. Dagster (a tool that runs data jobs) set up and connected to GitHub.

  4. Pipelines moved across one at a time.

  5. See what ran, work together, and lay the ground for ML later.

← Back to my journey