Chapter 1. Business Intelligence Basics

Many real-world business intelligence (BI) implementations have been delayed or even derailed because key decision makers involved in the projects lacked even a general understanding of the potential of the product stack. In this chapter, we provide you with a conceptual foundation for understanding the broad potential of the BI technologies within Microsoft SQL Server 2008 so that you won’t have to be in that position. We define some of the basic terminology of business intelligence, including OLTP and OLAP, and go over the components, both core and optional, of Microsoft BI solutions. We also introduce you to the development languages involved in BI projects, including MDX, DMX, XMLA, and RDL.

If you already ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.