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
Tag: SharePoint
Customizing PowerView in PowerPoint
Although "customizing" may be too strong of a word, there are few things that we can tweak to improve the look and feel of PowerView slides that had just been exported from SharePoint. The first thing to do after the fresh export is to adjust the size of the exported image. For some reason as … Continue reading Customizing PowerView in PowerPoint
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
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 Apps for Office, specifically Office 2013
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 Excel Services 2013 and SharePoint 2013 – interact with Pivot Tables using Browser
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 More details on new PerformancePoint features in SharePoint 2013
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 What’s new in PerformancePoint services in SharePoint 2013?
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 How to limit values in PivotTable filters in Excel
SharePoint Chart Web Part
Here is a good introductory article for the SharePoint Chart Web part. I have not see this web part used that much, although, there is one feature that I think makes this data visualization vehicle critical for certain types of reporting. I am of course talking about being able to show a Sales Pipeline Funnel like this: Few pros … Continue reading SharePoint Chart Web Part
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 Bubble Charts in Excel and Excel Services
business intelligist 