Database Reference
In-Depth Information
Q. What must be in the solution?
A. Our database is a mess. We need to get it cleaned up and make it consistent.
Q. What would be nice to have in the solution?
A. We know that other companies are using cubes for their reports. We would like to have a cube also.
Q. What will
not
be in the solution?
A. We don't want anything that costs a lot of money to develop or maintain.
Q. How will we build it?
A. We already have a SQl Server that hosts our current database. We would like to use the existing server for
all items.
Q. Can we release it in increments?
A. That will be acceptable as long as we start seeing a practical outcome as soon as possible.
In this exercise, you imagined having the role of an interviewer asking questions about the nature of the BI
solution you are proposing to create. In the next exercise, we look at defining what will be included in and
excluded from the BI solution.
Documenting the Requirements
With the interview process complete, it is time to make some notes about what you found. A simple Word
document is sufficient to record these findings. You could simply start by making an itemized list, or you could
use a document with tables, diagrams, and section headings. Let's look at an example of this more complex type
of document, which you can see in Figure
3-3
.
