HTML5 support for PowerView and the rest of the Microsoft BI stack

Had a long conversation with a senior Microsoft executive few days ago.  It appears that HTML5 support for PowerView will be released with the Service Pack 1 for SQL Server 2012 by the end of this calendar year.  A little too late for my taste, but I will take what I can get.  My prognostication is … Continue reading HTML5 support for PowerView and the rest of the Microsoft BI stack

Reading and Loading SharePoint Data using SSIS

Lists are one of the cornerstones of SharePoint and many companies have a wealth of information stored and managed using this SharePoint feature.  I sometimes get questions whether it is possible to extract that data (or load that data) into a data warehouse or a cube elsewhere.  The answer is yes, using the SharePoint SSIS Adapters.  … Continue reading Reading and Loading SharePoint Data using SSIS

SharePoint on iPad

Microsoft has recently released a Cumulative Update 2011-12 for Microsoft SharePoint that enables consuming Microsoft BI data visualizations on Apple iPad running iOS 5 Safari browser.  Not all visualizations are supported: Visualization Type Renders on iPad Dashboards (filters, linked elements) YES Excel Services (including PPS webpart) YES Reporting Services (including PPS webpart) NO PerformancePoint ScoreCards YES … Continue reading SharePoint on iPad

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

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 … Continue reading Using Reporting Services Charts with PerformancePoint reports in a SharePoint Dashboard

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 … Continue reading Choosing between PerformancePoint, PowerView, Excel Services and Reporting Services for your data visualizations