One of the strange functionality gaps in PowerView is lack of support of images. In other words, one can easily add a text box to the dashboard, but unfortunately there is no easy way to add a company logo to the dashboard, which means that yet again we have to resort to a work around. This … Continue reading How to add images or logos to a PowerView dashboard
Scorecards are not natively supported in PowerView, which is very unfortunate to say the least.. Fortunately there is a work around. Since I am writing this on a plane, I will just provide a high level description of how to get it done... First, one needs to implement add a calculated column that will have … Continue reading Scorecards in PowerView
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
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
Microsoft has just announced that Windows Azure SQL Reporting is Generally Available. A quick glance on the Guidelines and Limitations reveals that the released functionality is mainly based on the SQL Server 2008 R2 stack, which means that PowerView is not available in the cloud yet.
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
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 Improving performance of Excel reports against Analysis Services
I was eagerly awaiting the new Release Preview of Windows 8 as I was hoping it would address some of the shortcomings with respect to the Microsoft BI Stack and Windows 8 that I blogged about before. One of the new features introduced in to the IE 10 was Flash support. I have not read … Continue reading PowerView in Windows 8 Release Preview