I have been really impressed with Microsoft Data Explorer the minute I had a chance to play with it as I was able to turn formatted Excel reports into legitimate data sources available for analysis. Fairly recently, an update to the tool delivered an uber critical feature that makes a huge impact on the world … Continue reading Unpivot data using Microsoft Data Explorer
Many people reach out to me asking for advice in helping them evaluate various BI platforms for their companies. In my mind I am obviously the wrong guy to ask as I am not shy to admit my fairly heavy bias towards Microsoft. However, over the course of the last twenty years, I have been exposed … Continue reading How to think strategic about Business Intelligence
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
Having gone through the RTM version of Microsoft Office 2013 RTM I cannot find any material differences from the Preview version. The two major (although not really feature related) differences are speed and stability (both revised significantly upwards).
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
I have been playing around with the newly released Office 2013. I cannot seem to find that many tangible Business Intelligence features in it, other than the PowerView feature that is now available in Excel. This feature has been flaky at best; I am getting all kinds of errors trying to build some visualizations against … Continue reading PowerView in Excel 2013
It seems like the demand for the two products is simply insane, lots of links do not work. I have found a couple of links that have been pretty reliable for me so I will share them here: Download SharePoint 2013 here Download Office 2013 (aka Office 365 Preview) here Download Project Professional 2013 here … Continue reading How to get SharePoint 2013 and Office 2013