List of interview questions to define the user requirements for the new EDW

What data will go in the warehouse?

How will they use that data?

What Type of Data is needed?:

What information is important to access?

Sources of Data: What data is needed from excel format, etc.

What type of reporting is needed? 

What is the method of accessibility?

Technical Questions:

What questions/problems you would like to be answered by mining in EDW?

How many years of information would you like to store?

How often the data should be refreshed in the EDW?  How often to load data, weekly, monthly?

What kind of reports you would like to see?  What kind of information is needed? i.e.  HR data- turnover from start date to end date.

What format you would like to see your reports? Pie chart, bar chart, etc.