Statistical Analysis in Excel and SQL Server Analysis Services: An Example using Boxplot

Summary: To offset the lack of commonly-used statistical calculations in Analysis Services, the author describes an approach for creating statistical calculations in SSAS and visualizing the results using Excel pivot tables, to combine slice-and-dice filtering with statistical functions in customizable charts. The boxplot is used as an example to demonstrate the technique, and tips are provided for how to extend the technique to other statistical functions, such as the probability density function.

Authors: David He, Senior Program Manager, Microsoft

Contributors: Chris Lucas, Michael Murstein, Jon Klein

Published: October, 2013

Applies to: SQL Server 2012, SQL Server 2008 R2

To review the document, please download the Statistical Analysis in Excel and SQL Server Analysis Services: An Example using Boxplot Word document.

Ask a question in the SQL Server Forums
Send Feedback