Database Reference
In-Depth Information
If you are like us, you want to make your own decisions about something you are creating. nevertheless,
because these exercises do not have a real team or client and because all the chapters in this topic have to work
together from start to finish, we make the decisions for you. We include information from the fictitious client as we
go along, as though you were in communication with them.
Note
We are sorry for the inconvenience and know that you may not agree with some of our decisions or thought process-
es, but we think you will agree that it is still helpful to see how someone else approaches these tasks. In addition, it
will help you understand what we are doing in future exercises of this topic.
In a real situation, it is best to meet with pertinent members of your team, as well as the client for the review pro-
cess. Each will often see things that the others do not, and the client will have more perspectives on what is neces-
sary to include than you will without them.
EXERCISE 3-3. REFINING THE PLAN
In this exercise, you take on the role of a solution planner and data warehouse developer. You examine the
data currently available and decide whether you will be able to create an effective data warehouse from
the data. You further refine the current definition of the BI solution by removing requirements that cannot be
accomplished during this iteration of the development cycle.
Reviewing the Current Plan
1.
Open SQl Server Management Studio and run as administrator. This is done by
clicking the Start button at the bottom left of your screen and navigating to All
Programs ➤ Microsoft SQl Server 2011. Then right-click SQl Server Management
Studio and select Run as Administrator from the context menu. (You will always run
these programs as administrator, because of the permissions required to access
databases, and so on.)
2.
When SQl Server Management Studio opens, connect to your computer's database
engine, and type in the name of your SQl Server. Then click the Connect button to
connect to the database engine (Figure 3-7 ).
 
 
Search WWH ::




Custom Search