Centralized data

Never ever keep the same data in two separate places. Meaning, if you somehow have two or more different databases where you keep a table of your customers / offices / equipment, make absolutely sure there is automated synchronization between the two. I’ve worked with data sources where there are upto five different locations (cloud services, different SQL databases)  for the “same” data. In the end nobody really knows which is the most accurate source, nor which one is truly up to date. KISS works here the best: One source of data per dimension.