• Is it over kill to go through the process creating staging and live tables and building etl packages to populate StoreUsers, AppointmentTypes and FittingRooms dimensions?

    No, it's not overkill. The ETL package(s) [some might disagree, but all three could be part of the same package] might not all have the same features that one for daily use would have, but you need something. It doesn't even have to be part of the automated download.