The spaghetti we call Microsoft BI stack

We have many many many BI productsLassard

The Microsoft BI stack is a reference to Microsoft products which make up the “Business Intelligence” and “Business Analytics” offering.

From cubes to tabular models and from standard reports to ad hoc reports. In Between lies a spectrum of reporting and data modeling alternatives. For instance, you can choose Excel for ad hoc reporting tool but you could also use it for standard reporting (something you can share with the rest of the organization).

Having options is a good thing but taking in account the latest developments around Excel (think Data explorer, PowerPivot and PowerView) things have become somewhat …. well overwhelming.

The growth in functionality overlap between these different products have made it confusing and .. well .. downright inefficient.

During the keynote Amir Netz gave on the first BA conference back in April 2013 he explained how chaotic things have become and announced a new goal, simplicity…

However, shortly after this invigorating speech he announced yet another Excel add in “Geoflow”.

Which, I’d like to add, on its own is quit nifty. But looks remarkably like something you should create in PowerView.

I will have to give this some more thought but my humble suggestion would be to start with Geoflow and Data Explorer. I think Data Explorer belongs in PowerPivot (although I like the name Data Explorer better .. come on PowerPivot !? It sounds like a special Power Ranger). Geoflow should be part of PowerView.

So much for my “ranting’s”. Note that I like the Microsoft BI stack, but I see room for improvement :).


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s