Chapter 6. SQL Server Analysis Services
In Chapter 4, we walked through the development of a basic SQL Server Analysis Services (SSAS) cube as a way to allow for increased ad hoc exploration of key business data via Excel. In this chapter, we'll explore a couple of key scenarios that dive deeper into using SSAS to look at how data is changing over time and to look for deeper patterns in the data that are critical for sales and marketing analytical programs. The goal remains to allow key business users to explore the data and answer their own questions. But, the methods get more sophisticated as we use more of the tool set built into SQL Server and look at business questions that go beyond asking, "What is our current state?" Being able to go beyond ...
Get Pro SQL Server 2008 Analytics: Delivering Sales and Marketing Dashboards 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.
