How to connect Excel PowerView to Analysis Services cube

There are several UI gotchas related to building PowerView visualizations that I wanted to address with this post. First, PowerView is not available in the Ribbon out of the box, in order to enable it, one needs to go to File->Options->Add-ins. Then find Manage Add-Ins drop down box, select "COM Ad-ins" and click Go. That … Continue reading How to connect Excel PowerView to Analysis Services cube

PowerView in Excel 2013 – Business Intelligence – Second Impression

Well, the more time passes, the more I like it... Somehow I have figured out, subconsciously, how not to make it crash quite as often and also how to work around things that don't work very well. So, in no particular order, here are few more observations... Map - like it a lot. There is … Continue reading PowerView in Excel 2013 – Business Intelligence – Second Impression

Choosing a Tabular or Multidimensional model in SQL Server 2012 Analysis Services

Many great discussions are taking place about the future of the Multidimensional mode for the Analysis Services.  It is very clear where the majority of the investment went for the 2012 version (hint... think rows and columns and not multidimensional).  At the same time, one might argue that the traditional or Multidimensional set of features is already … Continue reading Choosing a Tabular or Multidimensional model in SQL Server 2012 Analysis Services

PowerView in PerformancePoint

PowerView is getting a lot of good press lately. I personally love it because this is the first data visualization tool available from Microsoft that actually looks good... I don't mean in a functional sense, PerformancePoint is far superior in terms of functionality. PowerView looks good, esthetically pleasing, which is hard to say about PerformancePoint.  … Continue reading PowerView in PerformancePoint