next excersise

from Gordon to All Participants:tuesday morn review agenda
from Gordon to All Participants:changes to data model in
from Gordon to All Participants:DimTerminal scd, ?connector?
from Gordon to All Participants:DimDoctor scd
from Gordon to All Participants:FPC, name of id, fk to dims date, time, many diag
from Gordon to All Participants:dimdate, yyyymmdd
from Gordon to All Participants:dimtime, hhmm
from Gordon to All Participants:FactPrescrption, id?, FKs to date, time, doctor, ?
from Gordon to All Participants:description of BP for FPC, FPresc
from Gordon to All Participants:DimInsured, as exercise scd?
from Gordon to All Participants:DimDiag

#1: What are some reasons that we need a data warehouse to query against, rather than just running reports against the OLTP system?

#2. Explain the three types of fact granularity.

#3. What are the benefits of conformance in the enterprise?

#4. Describe how the Enterprise Data Warehouse Bus Matrix and prioritization work in the building of a DW.

#5 What is a degenerate dimension?

assignment is to compare qfd with kimball's quadrants

up to Saturday

Book

download link of 1st edition http://rs77l32.rapidshare.com/files/66692373/the_data_warehouse_life_cycle_toolkit_ralph_kimball.pdf

chapter 4 is equal to 1st chapter of 2nd edition

First asignment

assignment: what is the vision of the enterprise you are doing the DW for. What are some questions that the users need answered. Then analyze those questions by using the 5 why technique to find the root requirement for the question. That is, the 5 why technique leads you to the REAL reason that the user wants that particular question answered. Of course, as Mehrdad pointed out last time, the 5 whys can only elicit as much wisdom as the person knows. for example, the janitor will give different answers than the CIO.

six sigma

http://www.isixsigma.com/library/content/c020610a.asp

sample topic