Microsoft® SQL Server 2005 Unleashed

Chapter 39. SQL Server 2005 Analysis Services

IN THIS CHAPTER

• What’s New in SSAS

• Understanding SSAS and OLAP

• Understanding the SSAS Environment Wizards

• An Analytics Design Methodology

• An OLAP Requirements Example: CompSales International

SQL Server 2005 Analysis Services (SSAS) is jam-packed with numerous data warehousing, data mining, and online analytical processing (OLAP)–rich tools and technologies. A complete overhaul and redeployment of SSAS was delivered by Microsoft and has launched SSAS into a new dimension in the business intelligence (BI) space. SSAS also has the distinction of beating SQL Server 2005 (then known as Yukon) to the general availability point (in fact, nearly a year ahead of Yukon). Other more traditional (and much more expensive) ...