O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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

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 ...

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