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
Microsoft once again is ranked the highest in its ability to execute by Gartner in its magic quadrant for Business Intelligence. The report is pretty long and boring, but if I were distill it down to a few salient points, I would choose the following: Companies see a dramatic improvement in BI capabilities going from … Continue reading Microsoft BI ranks highest in ability to execute by Gartner
and the Germans are making the first move... I have written two posts about Hana vs. xVelocity (Part I and Part II) making the basic point that there is nothing truly visionary or revolutionary in SAP Hana from the technology perspective and that a customer can get all the benefits (or rather alleged benefits as … Continue reading SAP Hana vs Microsoft SQL Server, the war is on…
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.
Not surprisingly, my original post generated huge traffic to my blog as well as a couple of good comments. I am sorry that it took me a while to respond, but now that it is Saturday and I am at Starbucks,I don't really have any excuse not to respond anymore… Before I jump into a … Continue reading SAP HANA versus Microsoft Business Intelligence and xVelocity, take two…
This will be in a long rant format as I am still trying to organize my thoughts around this subject. Before I start comparing and contrasting the two vendors, I just wanted to make a quick statement to get something off my chest: Generally speaking, HANA is a good business decision for SAP as it … Continue reading SAP HANA versus Microsoft Business Intelligence and xVelocity
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
Microsoft recently published a Using DirectQuery in the Tabular BI Semantic Model white paper. The white paper provides a great introduction for the DirectQuery technology, xVelocity and columnstore indexes. It also covers security, capacity planning and deployment best practices.
I have been trying to wrap my brain around the various options that Microsoft offers around near real-time analytical experience for the end users. Clearly, a semantic model is needed to isolate the end from the complexity of SQL/Relational Data Warehouse. So I see three options to explore: traditional MOLAP model for Analysis Services New … Continue reading Columnstore index vs MOLAP
Today I decided to take xVelocity and columnstore indexes for a spin and see whether this technology lives up to all the hype. I tested it on a 2Gb fact table with about 21M rows. First I wrote a query that joined the fact table with a Customer dimension and returned the total revenue grouped … Continue reading xVelocity and Columnstore Indexes review