O'Reilly logo

Pro SQL Server 2008 Analytics: Delivering Sales and Marketing Dashboards by Jeff Finken, Brian Paulen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required