Monthly Archives: April 2012

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 it did last year… HTML5,

Read more

Columnstore index vs MOLAP

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 Tabular mode for Analysis Services

Read more

How to expose Master Data Services in SharePoint

I have been hacking around this for a while trying to expose MDS web application in SharePoint.  Apparently, the trick to remove the non-functional UI elements is to use hosted=true query parameter as in http://MDSWebAPP:PortNumber/MDS/Explorer/AttributeSL.aspx?MID=10&VID=23&EID=44&hosted=true#/ExplorerEntity?MID=10&VID=23&EID=44&hosted=true you can find more details on how to do it here

Read more

Using Reporting Services Charts with PerformancePoint reports in a SharePoint Dashboard

One of the greatest strengths of SharePoint as it pertains to the world of Microsoft Business Intelligence is its ability to bring together various components of the Microsoft BI stack into a seemless user experience. When it works, it works great, however, when it does not quite work, it gets very annoying.. Recently, I was working on a dashboard mixing

Read more

Choosing between PerformancePoint, PowerView, Excel Services and Reporting Services for your data visualizations

Even though PowerView is the only Microsoft Data Visualization tool that is new on that list, it appears that there is some confusion as to how these four options compare with each other.  The topic is pretty big, so it will probably take me a few tries to get it done right, but here is the first shot at the comparison. There

Read more