I have a client who wants to set up a data warehouse in his company. His question is "Which provider should I use?"
What I need from you is in the next 1h30 is an analysis grid which will help to assess the company's situation and later allow me to recommend him a provider over the other.
The grid should be a list of question to ask employees of the company. The answers to these questions will then allow me to understand the current situation of the company and which data warehouse provider would be best for them to use.
The situation of the company is the following: they have multiple on-prem databases, they want to use their data with a BI tool but they realised that the quality of their data is poor. They now need a place to centralize and manage all the data coming from different sources. To do that, they want a Data warehouse.
The delivrable required from you is the list of questions.
Here is the kind of questions I would expect from you:
- Which data type are you using?
- What is the size of the data you want to store?
- How quickly do you need the data when you query it?
- How much are you willing to spend on the data warehouse?
- How connected do you want your warehouse to be to your other critical tools and services.
Of course, I expect the list of question to cover every aspect that has to be analyzed before recommending a solution.
Thank you in advance for your offers.