Tag Archives: Microsoft Office

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 to just about every major

Read more

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 work where and how. Feature

Read more

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 brings a window up that

Read more

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 and consumption across multiple computers

Read more

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 of love and attention in

Read more
« Older Entries