Related Posts
More Posts
Lume shot as I walked into a parking garage
What kind of shoes do you guys rock at work?
Additional Posts in Excel Genius
Best pdf to excel converter?
What are the most typical models you all build
Google Sheets vs Excel - pros? cons? differences?
New to Fishbowl?
unlock all discussions on Fishbowl.
Definitely a risk, but very common. Are you looking for improvement recommendations or just concurrence?
-edit it doesn't inherently require rework if there are sufficient controls (process flow maps, checks, sign offs, etc.)
Ideally I would have everything in a data warehouse that would reference, so only one link. But this is a small company entrenched in doing it this way with minimal controls, nightmare to even fix a bit of it
Ummm sounds like they need a RDBMS to me. Need help with the proposal?
102 external links to other files?.... Jesus Lord
Not including the links from the files they link to…
Rename/move a file to show them what can go wrong and how bad it’ll be.
/s
Agree with EY1. That’s definitely not good. Files should be self-contained without links
You can bring it all in a powerquery model to speed things up
Kind of, but it’s pretty flexible with what you can do. Ideally data should be a tabular format
Alteryx? But doesn’t really help with the untangling, just the future management - but maybe some opportunity