Chapter 20

Analyzing Multidimensional and Tabular BISMs In Excel

What's in this chapter?

  • Analyzing data using pivot tables
  • Filtering data in pivot tables
  • Grouping data in pivot tables
  • Formatting data in Excel
  • Sorting data with Excel
  • KPIs, perspectives and translations
  • Cube functions in Excel
  • Pivot charts
  • Local cubes
  • Excel Services

You spend a good deal of time in this book exploring design and implementation options, but you haven't spent much time on the end-user experience — until now. In this chapter you learn about the many ways to present your aggregated data to the end user for analysis. You can slice the cube data, meaning that you present the data so that it can be looked at across some axis, or you can dice the data, which means that you drill down into the data by breaking it into smaller and smaller cubes.

In Chapter 1 you learned about the overall business intelligence stack from Microsoft. You learned that SQL Server Analysis Services (SSAS) is the business intelligence server that is the core of the business intelligence platform offering from Microsoft. As a developer, SQL Server Data Tools (SSDT) and SQL Server Management Studio (SSMS) help you to analyze the SSAS data, but these are not suitable tools for end users making decisions based on SSAS data.

Various Microsoft Office products are available that leverage SSAS and present the SSAS data to end users in an effective way. One of the most widely used products to analyze data from SSAS is Microsoft Excel. Most ...

Get Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.