Database Reference
In-Depth Information
Defining the Roles
Now comes the point of defining the roles needed for the team. At a minimum, you need one team member to
build the data warehouse, one team member to fill up the data warehouse, and one team member to make the
initial reports. The solution must be documented as well, so you need somebody to build the documentation. In
addition, the solution you come up with needs to be tested. Therefore, add a tester role to the list. They asked for a
cube as well, so you need somebody to build one.
You could make a formal document describing the role and which task they are to perform; however, let's
just add an additional worksheet to our Excel spreadsheet and then make a simple list.
Not
■
You can find this Excel file in the
C:\BookFiles\Chapter03Files
folder. We called it
StarterBISolutionWorksheets.xslx
.
You may not necessarily know who your team members are in the beginning, but we can make a blank
column where their names can be entered as the roles are filled (Figure
3-19
).
Figure 3-19.
Listing the roles
Defining the Team
For learning purposes, you are fullling each role in this topic, and it is your task to create each of the various
elements of your BI solution. In real life, you would likely want an entire team to work on your BI solution. The
old adage about two heads being better than one really does apply when you are trying to work on something as
complex as a BI solution. One individual may miss seeing a possible problem that is quite obvious to another.
