The cumulative update 4 for the SQL Server 2012 Service Pack 1 has now been released. This update enables PowerView to connect to Multidimensional models and also to have global filters across multiple views (pages) in a PowerView report. Please follow this link for more details http://blogs.msdn.com/b/sqlrsteamblog/archive/2013/05/31/power-view-for-multidimensional-models-released.aspx
Category: Excel and Excel Services
Unpivot data using Microsoft Data Explorer
I have been really impressed with Microsoft Data Explorer the minute I had a chance to play with it as I was able to turn formatted Excel reports into legitimate data sources available for analysis. Fairly recently, an update to the tool delivered an uber critical feature that makes a huge impact on the world … Continue reading Unpivot data using Microsoft Data Explorer
GeoFlow is going public
The public preview of GeoFlow is now available here http://office.microsoft.com/en-us/download-geoflow-for-excel-FX104036784.aspx I would definitely grab the "Data Explorer" plug in while I were there...(also available here http://office.microsoft.com/en-us/excel/download-data-explorer-for-excel-FX104018616.aspx) There are plenty of reviews and good tutorials of both products available elsewhere, but in the coming few days I will try to write about where I think these … Continue reading GeoFlow is going public
PowerPivot File Size Limit in Excel 2013
This is more of a note to self as I am constantly self-confusing myself with how much data can be loaded into a PowerPivot model. Basically, there are two things to consider, version of office one is running and whether a SharePoint deployment option is required. First, whether one is running a 32 or a 64 … Continue reading PowerPivot File Size Limit in Excel 2013
SAP vs. Microsoft, Information Assets vs. End User Experience positioning
If your company runs SAP, chances are the picture below represents your environment pretty well The black colors represent the existing investments/business processes and the size of the bubbles represents the effort/investment $$$. Your company has made a very large investment in the SAP back-end (ERP, BW, etc.) which is represented by a large black circle … Continue reading SAP vs. Microsoft, Information Assets vs. End User Experience positioning
SAP Visual Intelligence vs. Microsoft PowerPivot and PowerView
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
Some comments on the CTP of the Microsoft SQL Server 2012 With PowerView For Multidimensional Models
I have had a pretty frustrating experience with it so far. I think that the only way get it to work is to have it deployed as a SSRS Service Application inside SharePoint and then configure PowerView. In other words, if you are planning to install a multidemensional instance of the CTP, install your OLAP cube … Continue reading Some comments on the CTP of the Microsoft SQL Server 2012 With PowerView For Multidimensional Models
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
business intelligist 