In this post I will review the latest version of SAP Visual Intelligence – 1.08 – and see how it stacks up against the Microsoft self-service BI tools, Excel, PowerPivot and PowerView. In the initial release, Visual Intelligence only supported SAP Hana, but in its latest iteration few other data sources are supported: CSV File … Continue reading SAP Visual Intelligence vs. Microsoft PowerPivot and PowerView
Tag: Excel Services
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
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
Improving performance of Excel reports against Analysis 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
PowerView in Windows 8 Release Preview
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
Office 15 beta
Looks like we only have a month or two before the next version of Microsoft Office (commonly known as Office 15) becomes available for beta testing. Not surprising, SharePoint, Visio and Project will be released in a beta form around the same time.
SharePoint on iPad
Microsoft has recently released a Cumulative Update 2011-12 for Microsoft SharePoint that enables consuming Microsoft BI data visualizations on Apple iPad running iOS 5 Safari browser. Not all visualizations are supported: Visualization Type Renders on iPad Dashboards (filters, linked elements) YES Excel Services (including PPS webpart) YES Reporting Services (including PPS webpart) NO PerformancePoint ScoreCards YES … Continue reading SharePoint on iPad
business intelligist 