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

PowerView in PerformancePoint

PowerView is getting a lot of good press lately. I personally love it because this is the first data visualization tool available from Microsoft that actually looks good... I don't mean in a functional sense, PerformancePoint is far superior in terms of functionality. PowerView looks good, esthetically pleasing, which is hard to say about PerformancePoint.  … Continue reading PowerView in PerformancePoint