It’s perhaps not so much Excel, as much as it’s just the symptom of a lot of bigger issues: working without version control, without column validation or access control, limited documentation (not necessarily better in data warehouse but at least the functionality is easily accessible), limited automated testing, etc etc.
If only they could keep their data for themselves, then ok. but no no, we have to ingest it, and do work on top of it in dwh, and it just breaks so often due to a variety of different stuff.
Yep, that’s true haha.
It’s perhaps not so much Excel, as much as it’s just the symptom of a lot of bigger issues: working without version control, without column validation or access control, limited documentation (not necessarily better in data warehouse but at least the functionality is easily accessible), limited automated testing, etc etc.
If only they could keep their data for themselves, then ok. but no no, we have to ingest it, and do work on top of it in dwh, and it just breaks so often due to a variety of different stuff.