Enhanced intermediate data-warehouse syndicate turn-key functionalities