Microsoft BI ranks highest in ability to execute by Gartner

Microsoft once again is ranked the highest in its ability to execute by Gartner in its magic quadrant for Business Intelligence.  The report is pretty long and boring, but if I were distill it down to a few salient points, I would choose the following: Companies see a dramatic improvement in BI capabilities going from … Continue reading Microsoft BI ranks highest in ability to execute by Gartner

Some comments on the CTP of the Microsoft SQL Server 2012 With PowerView For Multidimensional Models

I have had a pretty frustrating experience with it so far.  I think that the only way get it to work is to have it deployed as a SSRS Service Application inside SharePoint and then configure PowerView.  In other words, if you are planning to install a multidemensional instance of the CTP, install your OLAP cube … Continue reading Some comments on the CTP of the Microsoft SQL Server 2012 With PowerView For Multidimensional Models

PowerView Feature Comparisons

PowerView experience will be delivered across several Microsoft products: Excel (fat client) Excel Services (SharePoint) SharePoint – SQL Edition Office 365 PowerPoint I get a lot of questions as to what features are supported across all these deployment scenarios. Luckily Microsoft shared a slide that I will attempt to reproduce here that explains what features … Continue reading PowerView Feature Comparisons

Microsoft makes big announcements at SQL PASS

I will have a more detailed write-up of everything later but still wanted to give a quick summary of the new announcements: Updateable Column store – Project Hekaton will be released in the next major release of SQL Server and will allow us create updateable clustered column store indexes. This is huge, 20-50 performance increases … Continue reading Microsoft makes big announcements at SQL PASS