O'Reilly logo

Business Intelligence by Jerzy Surma

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

2.5. Designing a Data Warehouse: Basic Facts

A data warehouse should be precisely designed to satisfy specific business needs. Usually, business requirements are specified by determining what information is necessary to manage a given business area. This allows you to select an appropriate logical model of a warehouse (see the star model) and then the necessary source data. This top-down approach was formulated by Ralph Kimball as a dimensional design model.12 Kimball is widely recognized as one of the first architects of data warehouse logical models. According to this paradigm, there are four steps to design a data warehouse:

  1. Specify business requirements. To understand business aims and needs in the context of existing source data, one must ...

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