Tag: SharePoint

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

Apps for Office, specifically Office 2013

Those who have been looking for new features in Microsoft Office 2013 have probably found the new Insert->Apps for Office button on the Ribbon. I have played around with these a little bit and have a few things to report. To get an idea of what Apps for Office are available, please check out this

Continue reading

Excel Services 2013 and SharePoint 2013 – interact with Pivot Tables using Browser

One of the nice new features of Excel Services now available in SharePoint 2013 is ability to interact with pivot tables directly from the browser without having to open the workbook in Excel. Here we have a PivotTable report deployed in SharePoint. Before, if we wanted to change a layout of the pivot table, we had to

Continue reading

More details on new PerformancePoint features in SharePoint 2013

Additional details are coming out on the new features that will be available in PerformancePoint 2013. Here is a list of new stuff: Themes – SharePoint has traditionally been somewhat of a challenge with respect to look and feel configuration and PerformancePoint Services was an even bigger challenge yet. Microsoft has simplified the CSS challenges

Continue reading

What’s new in PerformancePoint services in SharePoint 2013?

This is going to be a very short post… yup, there is almost nothing new. In fact, I did not see anything new. Deep sigh…. Now, there are some changes in PerformancePoint services according to this article, but I sincerely doubt that dashboard migration, filter enhancements and search, BI Center updates, iPad support and security

Continue reading

How to limit values in PivotTable filters in Excel

Excel 2010 is tightly integrated with SharePoint which allows users to author their reports in Excel and then simply save them in SharePoint so that they can be subsequently rendered to everybody else as a web page using Excel Services.  Unfortunately, not all features of Excel can be rendered; some of them generate warnings but

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