locked
Does BI work with Office 2007? RRS feed

  • Question

  • Hi

    Our users have office 2007. Does business intelligence work with office 2007?  Our SharePoint server is 2010.

    Thank you

    Thursday, January 19, 2012 9:39 PM

Answers

  • It is difficult to answer your question is business intelligence is a term used to describe a set of technologies, philosophies, and methologies surrouding the analysis, evaluation, and synthesis of business related data for the purposes of improved decision making, reduction time wasted, and increased transparency of business related data.

    In SharePoint Server 2010, many of the business intelligence related solutions are browser-based and do not require any office application. These services include Excel Calculation services, Visio Services, Business Connectivity Services, and Performance Point.

    Excel Calcuation Services can leverage xls and xlsx files author in Excel 2007 and render them as a web page. This is not a replace for Excel and not all functionality is support, but likely 99% of what your users do with Excel can be successfully rendered in SharePoint 2010 using Excel Calculation Services.

    Visio Services can render visio files authored in Visio 2007......successfully render in SharePoint 2010 using Visio Services.

    Business Connectivity Services connect to line of business application and create content types, lists, and library with information stored in LOB databases. Many of these same connection can be configured into an ODC file (office data connection) and leveraged in Excel using the data tab.

    PerformancePoint is a robust, interactive dashboard authoring tool that using it's own .NET application call "PerformancePoint Dashboard Creator". This application can run along side Office 2007 without issue and is available through SharePoint when you have an Enterprise License.

    Finally, SharePoint Designer 2010 is a great tool for Power Users to gain the most from SharePoint. SP Designer 2010 can run along side Office 2007 products without issue.

    • Proposed as answer by Andrew_Hutson Thursday, January 19, 2012 9:58 PM
    • Marked as answer by GuYuming Saturday, January 21, 2012 9:25 AM
    Thursday, January 19, 2012 9:57 PM
  • Dora,

    indeed Excel 2007 allows you to create powerfull dashboards (based or not on PivotTable) that will give a meaning to your data and can be published to the server where calculation can be done if you have the Enterprise version of SharePoint 2010.

    Now, one of the new BI Tool in Office is PowerPivot for Excel, which only works with Office 2010.

    http://msdn.microsoft.com/en-us/library/ee210644.aspx 

    On SharePoint the BI functionality (KPI lists, Chart webPart, PerformancePoint) doesn't always require Office but always requires SharePoint Enterprise (the only exception is Reporting Services).

     

     


    Serge Luca; SharePoint MVP ; blog: http://sergeluca.wordpress.com/ Devoteam Belgium. http://twitter.com/sergeluca
    • Marked as answer by GuYuming Saturday, January 21, 2012 9:25 AM
    Thursday, January 19, 2012 10:24 PM

All replies

  • It is difficult to answer your question is business intelligence is a term used to describe a set of technologies, philosophies, and methologies surrouding the analysis, evaluation, and synthesis of business related data for the purposes of improved decision making, reduction time wasted, and increased transparency of business related data.

    In SharePoint Server 2010, many of the business intelligence related solutions are browser-based and do not require any office application. These services include Excel Calculation services, Visio Services, Business Connectivity Services, and Performance Point.

    Excel Calcuation Services can leverage xls and xlsx files author in Excel 2007 and render them as a web page. This is not a replace for Excel and not all functionality is support, but likely 99% of what your users do with Excel can be successfully rendered in SharePoint 2010 using Excel Calculation Services.

    Visio Services can render visio files authored in Visio 2007......successfully render in SharePoint 2010 using Visio Services.

    Business Connectivity Services connect to line of business application and create content types, lists, and library with information stored in LOB databases. Many of these same connection can be configured into an ODC file (office data connection) and leveraged in Excel using the data tab.

    PerformancePoint is a robust, interactive dashboard authoring tool that using it's own .NET application call "PerformancePoint Dashboard Creator". This application can run along side Office 2007 without issue and is available through SharePoint when you have an Enterprise License.

    Finally, SharePoint Designer 2010 is a great tool for Power Users to gain the most from SharePoint. SP Designer 2010 can run along side Office 2007 products without issue.

    • Proposed as answer by Andrew_Hutson Thursday, January 19, 2012 9:58 PM
    • Marked as answer by GuYuming Saturday, January 21, 2012 9:25 AM
    Thursday, January 19, 2012 9:57 PM
  • Dora,

    indeed Excel 2007 allows you to create powerfull dashboards (based or not on PivotTable) that will give a meaning to your data and can be published to the server where calculation can be done if you have the Enterprise version of SharePoint 2010.

    Now, one of the new BI Tool in Office is PowerPivot for Excel, which only works with Office 2010.

    http://msdn.microsoft.com/en-us/library/ee210644.aspx 

    On SharePoint the BI functionality (KPI lists, Chart webPart, PerformancePoint) doesn't always require Office but always requires SharePoint Enterprise (the only exception is Reporting Services).

     

     


    Serge Luca; SharePoint MVP ; blog: http://sergeluca.wordpress.com/ Devoteam Belgium. http://twitter.com/sergeluca
    • Marked as answer by GuYuming Saturday, January 21, 2012 9:25 AM
    Thursday, January 19, 2012 10:24 PM