Our business users already hired the consultant and I'm trying to make sense of his answers, but he does seem to be knowledgeable only on using a mouse. We want

Our business users already hired the consultant and I'm trying to make sense of his answers, but he does seem to be knowledgeable only on using a mouse. We want to create a template dashboard of visualisations, which would be duplicated for each of our customers, each one having its own data source and workspace. New customer creation should be automated through API calls and we would prefer centralize our resources on AWS. That's it. The consultant has been so fuzzy that it seemed utterly complex to set-up, but by reading all the answers things are starting to make sense. Redshift would be great, thanks for the pointer!