Finance numbers that are never out of date.
Financial reports were assembled by hand and always a little stale. I built a pipeline that moves accounting data into a data warehouse and live dashboards, close to real time.
Languages
Tools & platforms
AI & LLM
Skills
The thinking behind it
- 01 · What I noticed
People didn't need prettier reports. They needed numbers they didn't have to ask for.
- 02 · What I decided
Move the data automatically into one warehouse and point every dashboard at it.
- 03 · What I delivered
Finance numbers the whole company can open, synced every minute.
Old system vs new system
- Export from accounting
- Clean it in spreadsheets
- Build the report
- Email it around
- Sync runs every minute
- Data lands in the warehouse
- Dashboards update live
Watch it run
Click through the four steps. In step 3, click any box to see what it does.
Fresh numbers without anyone pressing refresh.
Reports go stale the moment someone has to export them. The pipeline syncs accounting data every minute into one warehouse, so every dashboard reads the same, current numbers.
Why it's built this way
One warehouse as the source of truth
Every dashboard reads from BigQuery instead of its own export.
Sync every minute
Close enough to real time for finance, cheap enough to run all day.
Dashboards stay separate from the data
Charts can change without touching the pipeline.
What made it work
- 01
Fix the data, not the report
Most reporting pain comes from how data moves, not how it looks.
- 02
One source of truth ends arguments
When everyone reads the same numbers, meetings move faster.
- 03
Automate the boring refresh
If people refresh it by hand, it will be out of date.
Have a similar mess? Tell me the step you hate.