Database Reference
In-Depth Information
Figure 3-18.
The employee table
Here are the steps to open the dbo.Employee table:
1.
locate the dbo.Employee table in the treeview list and right-click this table to access
the context menu.
2.
Choose Select Top 1000 Rows from the context menu. SQl Management Studio will
create a query window, execute the query, and show you the results (Figure
3-18
).
Although it may be important to have a list of employee contacts who can be reached by Publication
Industries, it is not relevant to the sales of individual titles to individual stores. One wonders how this
information was even collected.
Deciding to Continue with the Solution
At this point, it seems obvious that we have sufficient data to create a BI solution that will provide reporting
information on sales. We may not have every single detail, but we have enough to make an initial prototype.
Once the prototype is created, we can get additional feedback and start working on the next version of the BI
solution that will provide even greater functionality and benefit to the customer.
In this exercise, you examined the data available to you and decided what was going to be included in the BI
solution and what was going to be excluded. For that matter, you also decided whether the BI solution could
even be accomplished. Because it was decided that it can be accomplished, your next step is to define the
roles required to create the solution and acquire the team members that will implement these roles.
