O'Reilly logo

The Data Warehouse Lifecycle Toolkit by Bob Becker, Joy Mundy, Warren Thornthwaite, Margy Ross, Ralph Kimball

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Program/Project Management
BI
Application
Development
Physical
Design
ETL
Design &
Development
Dimensional
Modeling
Product
Selection &
Installation
Business
Requirements
Definition
Technical
Architecture
Design
Program/
Project
Planning
Deployment
Growth
Maintenance
BI
Application
Design
CHAPTER 7
Designing the
Dimensional Model
I
n Chapter 6 we discussed the dimensional modeling approach and outlined
common dimensional design patterns. Now it’s time to turn our attention to
a process for building dimensional models.
We begin with a practical discussion of initial preparation activities that
involve organizing the modeling team, reviewing the business requirements,
determining naming conventions, setting up the modeling and data research
environment, and scheduling facilities. The modeling process itself actually

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required