210 likes | 370 Views
SharePoint 2010 Business Intelligence Overview. John Gamble 12 th April 2011. Contents. Introduction Business Intelligence – v.quick recap SharePoint 2010 Data Analytical Features Data Presentation Features Collaboration Features Demos along the way .. .
E N D
SharePoint 2010Business Intelligence Overview John Gamble 12th April 2011
Contents • Introduction • Business Intelligence – v.quick recap • SharePoint 2010 • Data Analytical Features • Data Presentation Features • Collaboration Features Demos along the way ..
Business Intelligence Groups Community Individual Organisation All with their own data needs …
PerformancePoint Services • Interactive dashboards • Now integrated into SharePoint • Authentication through SharePoint • Decomposition Tree
Excel Services • First introduced in MOSS 2007 • Server-side calculation and browser based rendering of workbooks • Distribution of all or part of a workbook for analysis by multiple users. • Hosts PowerPivotapplications.
Visio Services • Lets users share and view Visio Web drawings • Data connections with auto refresh • Don’t need Visio installed on clients to view • Data Sources: • SQL Server (7, 2000, 2005, 2008, 2008 R2) • Excel workbooks • SharePoint Lists • OLE DB / ODBC • Custom .NET data providers • So pretty much everything …. • Requires Visio 2010 …
Demo Visio Services / New Visualisation Tools
SharePoint Workspaces • Succeeds Microsoft Office Groove 2007 • Client which enables real-time synchronisation of desktop content with SharePoint document libraries or lists • Regular synchronisation when on-line • Can edit off-line, re-sync when possible. • Windows authentication • Lync integration. Presence and communication features.
Lync’ing it all together Microsoft Office Lync • Facilitating different communication options • Instant Messaging • Voice Over IP • Video Conferencing • Desktop sharing • “Presence information” • Federation with other organisations
Collaboration and Social Networks • Reports, documents and information can be ‘liked’ and ‘shared’ • Report commentary added on social site (intranet) • Intranet used for report distribution, versioning and sign off • Use of ‘search’ facility • SharePoint 2010 provides all this
Conclusions SharePoint 2010 BI – what have we seen? • Workspaces • PerformancePoint Services • Excel Services • Visio Services • Office 2010 / Exchange Integration • Collaborative tools and real time communication • BI tools for the me, my social group and my organisation, all in the same place Creating an Intelligent Business?
Thank youAny Questions? john.gamble@altiusconsulting.com