I've recently started doing the round-up for IT Web's BI newsletter ( http://www.itweb.co.za/index.php?option=com_content&view=article&id=34797&Itemid=219 ), and (with permission), I'm cross-posting the content here for those who don't subcribe: As a tumultuous 2010 comes to a close, this is a good time to take a look at what is expected in business intelligence in 2011. The biggest growth trend, coming on the back of the explosion in tablets, will be in mobile BI. Since the release ...
Read More
I've recently started doing the round-up for IT Web's BI newsletter, and (with permission), I'm cross-posting the content here for those who don't subcribe: The Business Intelligence community needs to become more aware of real world data, based on sensor feeds. Business Intelligence has traditionally been used on pure IT systems - starting with financial systems, growing through ERP, and expanding into new fields all the time, such as clickstream analysis. Until recently, data sources in BI sys...
With Sharepoint rapidly becoming the data store of choice for user driven and user built data capture systems, getting this data into your warehouse is becoming more and more important. There are three primary methods of doing this from SSIS. 1. Install 3rd party Sharepoint List Adapters. CodePlex even has a free version at http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652 2. Write your own adapter. Again, the CodePlex project is a great start 3. Create a script component to query Sha...