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

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

HTML5 support for PowerView and the rest of the Microsoft BI stack

Had a long conversation with a senior Microsoft executive few days ago.  It appears that HTML5 support for PowerView will be released with the Service Pack 1 for SQL Server 2012 by the end of this calendar year.  A little too late for my taste, but I will take what I can get.  My prognostication is … Continue reading HTML5 support for PowerView and the rest of the Microsoft BI stack