Database Reference
In-Depth Information
in this exercise, you reviewed the data warehouse design created by the authors. now it's time to move on to
creating the database using sQL server 2012. As we do so, we revisit this spreadsheet in more detail
(Figure
4-24
).
Moving On
In this chapter, you learned techniques for designing a data warehouse. You also reviewed an example of an
OLAP database created by the authors and compared it to its OLTP counterpart. Finally, you reviewed a design
for a data warehouse built upon the Pubs OLTP database. Now it's time to implement that design by building a
data warehouse in the next chapter.
LearN BY DOING
in this “Learn by Doing” exercise, you perform the processes defined in this chapter using the northwind
database. We have included an outline of the steps you performed in this chapter and an example of how the
authors handled them in two Word documents. These documents are found in the folder
C:\_BISolutionsBookFiles\_LearnByDoing\Chapter04Files
. Please see the
ReadMe.doc
file
for detailed instructions.
What's Next?
We just gave you quite a bit of information on designing a data warehouse, but there is always more to tell. In this
chapter, we focused only on core concepts that you can anticipate seeing on a regular basis. Because of this, you
may be interested in researching more on the subject.
For more information, articles and videos on this subject can be found at
www.NorthwestTech.org/
ProBISolutons
.
Design tips posted by the Kimball Group can be found on its website at
www.kimballgroup.com/
We also recommend the following books:
The Data Warehouse Toolkit
and
The Data Warehouse ETL Toolkit
,
both by Ralph Kimball (Wiley).
