Hello.<p>I've made a transfer from freelance programming (good tools, but culture is not for me) to corporate analytics (better culture, atrocious tooling).<p>There's lot of spreadsheet maintenance, some of them are getting slowly ported to ancient OBIEE 10, but process is slow and on top of that we're migrating ETL DB and there's whole lot of 500 cols table filled with logic and complete ignorance of datatypes (90% storage are strings). Have I told you about lack of docs?<p>I can see lots of issues with that but maybe that's inexperience with intelligence tech. Nonetheless, I expressed my concerns to the superiors and they said they're really happy to look into ideas for improvement.<p>That's what lead me here, could you tell me what can be though of as THE modern workflow in this area?