SQL Server Analysis Services

Abstract

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 overtime 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 looking at the current state of the organization represents movement up our analytics pyramid (see Figure 6-1) to the intermediate level, where users engage in more detailed analysis.KeywordsSales RepresentativeSales TeamData MartPivot TableMarketing TeamThese keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Cite this paper

@incollection{anon2009server,
  title = {{SQL Server Analysis Services}},
  booktitle = {Apress eBooks},
  pages = {143--170},
  year = {2009},
  doi = {10.1007/978-1-4302-1929-3_6}
}

Made from the index record. Check names, capitalisation and page numbers against the paper. Need another style? AI for Research has over 10,000.

Related papers