Tag: PowerPivot

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

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 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

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

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

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

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

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

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