Chapter 42. Microsoft SQL Server Analysis Services
by Paul Bertucci
IN THIS CHAPTER
What Is Analysis Services and OLAP?
Understanding the Analysis Services Environment and the “Land of Wizards”
An Analytics Design Methodology
An Analytic Mini-Methodology
An OLAP Requirements Example
OLAP Cube Creation
Creating an OLAP Database
Working with a Relational Database
Files at the Operating System Level
This version of SQL Server is jam-packed with numerous data warehousing, data mining, and OLAP-rich tools and technology. A Data Warehouse manager from a prominent Silicon Valley company once said, “I can now build [using MS SQL Server 2000 Analysis Services] sound, extremely usable, OLAP cubes myself, faster and smarter than my whole department could do only ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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.
