Analysis Services and EXCEL 2010 for Business Analysis

Microsoft office riched Office Excel 2010 for analytical purpose.
Using Sparkline, Slicers, Conditional formating made dashboards much faster and attractive.

Easy to establish connection with SSAS 2008 over HTTP.
See link to configure your SSAS 2008 over HTTP,
http://ghufrangreat.blogspot.com/2010/07/configuring-http-access-to-sql-server.html


Connection Establishment and Step to be followed:

Figure 1

Figure 2

Figure 3

Figure 4

Connection is established, just click and use cube measures and dimensions.
Pretty cool reports and dashboards if you have well designed cube.


Now this file can be shared with any one. Data > Refresh All will refresh the data.

Thanks.