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
Tag: PowerPivot
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
Microsoft Surface RT review, sort of in a context of Microsoft BI
First, I have to explain why I am writing this review when so many websites have already covered the product – the only thing that I will cover that others haven't is what features of Microsoft BI stack run on Surface and what don't. Let's get through the bad stuff first. I don't know if … Continue reading Microsoft Surface RT review, sort of in a context of Microsoft BI
Slew of important SQL Server announcements is expected at SQL Pass conference in Seattle this year
Microsoft is expected to make a number of very important announcements at the upcoming SQL Pass conference in Seattle… If you are on the fence about attending it this year, I would definitely recommend attending this event.
How to connect Excel PowerView to Analysis Services cube
There are several UI gotchas related to building PowerView visualizations that I wanted to address with this post. First, PowerView is not available in the Ribbon out of the box, in order to enable it, one needs to go to File->Options->Add-ins. Then find Manage Add-Ins drop down box, select "COM Ad-ins" and click Go. That … Continue reading How to connect Excel PowerView to Analysis Services cube
PowerView in Excel 2013 – Business Intelligence – Second Impression
Well, the more time passes, the more I like it... Somehow I have figured out, subconsciously, how not to make it crash quite as often and also how to work around things that don't work very well. So, in no particular order, here are few more observations... Map - like it a lot. There is … Continue reading PowerView in Excel 2013 – Business Intelligence – Second Impression
More on new features of PowerView in Excel 2013
I started the list of changes here, at some point I will consolidate everything into a single nice master list, but for now I will just keep posing all the new things that I find in individual posts. So, a few other new features: Ability to drill on not only Matrix controls but also charts … Continue reading More on new features of PowerView in Excel 2013
Choosing a Tabular or Multidimensional model in SQL Server 2012 Analysis Services
Many great discussions are taking place about the future of the Multidimensional mode for the Analysis Services. It is very clear where the majority of the investment went for the 2012 version (hint... think rows and columns and not multidimensional). At the same time, one might argue that the traditional or Multidimensional set of features is already … Continue reading Choosing a Tabular or Multidimensional model in SQL Server 2012 Analysis Services
Next release of PowerView
Microsoft isn't great at prognosticating.. here is an interesting tidbit on when we might see the next release of PowerView. 2014??? I sure hope not....as much as I love this technology, there are several glaring holes in it that have to be addressed ASAP if Microsoft were to lead the Business Intelligence quadrant again like … Continue reading Next release of PowerView
business intelligist 