CHAPTER 16Design and Business Intelligence

A good dimensional design maximizes the potential value of your data warehouse. If it is not easy to access the information, however, even the best dimensional schema becomes a black hole. Luckily, there are a wide variety of software products available that can help make sure this does not happen.

Tools that are used to provide information to end users range in functionality from simple report writers to sophisticated business intelligence software products. They can provide information in a numerous formats (charts, tables, dashboard widgets), over a variety of channels (computers, mobile devices, telephones), and according to varied access paradigms (on demand, scheduled, exception alerts). For the ...

Get Star Schema The Complete Reference now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.