Chapter 1. Understanding Business Intelligence and Data Warehousing
After completing this chapter, you will be able to:
Understand the purpose of business intelligence and data warehousing.
Distinguish between a data warehouse and a transaction database.
Understand dimensional database design principles.
Microsoft SQL Server 2005 Analysis Services is a tool to help you implement business intelligence (BI) in your organization. BI makes use of a data warehouse, often taking advantage of online analytical processing (OLAP) tools. How exactly do BI, data warehousing, OLAP, and Analysis Services relate to each other? In this chapter, you’ll learn the purpose of BI in general, and also some basic concepts of data warehousing in a relational database. In ...
Get Microsoft® SQL Server™ 2005 Analysis Services Step by Step 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.
