I don’t know what was first: customer relationship management or collaboration – the fact is both is based on information which is stored in any system – locally or on server or in the minds of your staff. Most important is that many companies are using software to improve their processes along CRM, Collaboration and other issues (document management). And on top they are using different software for different subjects. You can imagine what comes next? Right – How can we bring those data together? At the moment they are separated by systems. Or most employees are not able to see all data due to licencing problems and therefore don’t have all information on their board.
If your company uses SharePoint and other systems, it might be interesting to integrate them. SharePoint offers a lot of possibilities to extend it, integrate other systems, different sources, etc (e.g.: Business Connectivity Services, Excel Services, Performance Point Services, InfoPath via Webservices, Custom Code). Let’s assume that the CRM System is Microsoft Dynamics CRM. What scenarios might make an integration necessary or interesting? (more…)
As appendix for the European SharePoint Conference 2011 in Berlin, i would like to provide some interesting links for the use of BI with SharePoint and Office 2010.
If you like to download the add-in for Powerpivot in Excel 2010 with some great additional features, you should go to www.powerpivot.com.
Another interesting Portal for BI is the Microsoft BI Labs: http://www.microsoft.com/BI/en-us/pages/home.aspx.
Or if you like to connect Data with Bing Maps in SharePoint or with SharePoint you should look at the solution from codeplex: http://dataconnector.codeplex.com/.
Information about SQL Server and BI possibilities you’ll find some videos on http://projectbotticelli.com/, which might be helpful.
If you have some more helpful links, i would like to hear and will add them in this post.
..:: I LIKE SHAREPOINT ::..
Session from Rafal Lukawiecki. Register projectbotticelli.com for trainings and webcasts for use of BI with SQL Server and SharePoint.
Business Intelligence for Everyone Everywhere – but How? (more…)
That was the best session today. Rafal Lukawiecki was really enthusiasm with jokes and really nice demos and only a few but enough slides.All in all it was one of my favorite session today,
“Build on what you already have”
Rafal talked about using tools which you already have for BI. SQL Server Reporting Services as wellas SharePoint Power Pivot, Performance Point Services, Excel, etc. With these tools you can visualize the meaning and knowledge which are in the data and you can offer
- The right information
- At the right time
- In the right format
- To the right people
Using the Excel Services, Power Pivot Galleries, Performance Point Services, Pivot Tools, Bing Data Connector, SQL Server Reporting Tools had been shown in small demos.