Tag: Microsoft Office

Unpivot data using Microsoft Data Explorer

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

How to think strategic about Business Intelligence

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

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

No material differences with respect to BI found between the RTM and Preview versions of Microsoft Office 2013

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).

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

PowerView in Excel 2013

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

Office 15 unveiled by Steve Ballmer… Available for preview…

Steve Ballmer just unveiled the new version of Microsoft office available for preview here..  The two most salient points of his presentation are touch support and windows 8 integration.  The new version of office appears a lot friendlier for content creation on a tablet.  SkyDrive also becomes a more prominent feature that allows content creation

Continue reading

Bubble Charts in Excel and Excel Services

Creating Bubble Charts is one of the biggest challenges in Excel and Excel Services with respect to data visualization.  Microsoft made it very intuitive in PowerView and very not intuitive in Excel.  Frankly, the way this functionality is implemented in Excel makes it practically unusable.  Rumor has it that this area is getting a lot

Continue reading

Improving performance of Excel reports against Analysis Services

I will start this post with a bit of a rant. There are two types of people in the Business Intelligence world: Those who do not like Excel Those who do Most of the right-click-hating low tech users belong to the first category (they are also usually the same people who like bubble gum and

Continue reading