Common BI Terminology

A number of other conceptual terms are important to understand when you’re planning a BI solution. In this section, we’ll talk about several of these: data warehouses; data marts; cubes; decision support systems; data mining systems; extract, transform, and load systems; report processing systems; and key performance indicators.

Data Warehouses

A data warehouse is a single structure that usually consists of one or more cubes. Figure 1-7 shows the various data sources that contribute to an OLAP cube. Data warehouses are used to hold an aggregated, or rolled-up (and most commonly) read-only, view of the majority of an organization’s data. This structure includes client query tools. When planning and implementing your company’s ...

Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with O’Reilly online learning.

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