Microsoft Office integration

SAS Enterprise BI Server enables users to transparently leverage the power of SAS data access, reporting and analytics directly from Microsoft Office. After arriving at the desired results, they can easily distribute the Office documents to relevant decision makers using native Microsoft Office functionality. Because the data is maintained centrally, IT can oversee and validate the data used for analyses and reports for confident decision making.

• Allows all Microsoft Word, Excel and PowerPoint users access to approved enterprise data for extended analysis capabilities.
• Provides greater consistency in decision making by delivering standard data and SAS Analytics capabilities to more users in the organization.

Features

• Integration with Microsoft Word, Excel and PowerPoint.
• Access and view data in any centrally IT-defined enterprise data source.
• View and modify existing analytic reports offline with native Office functionality.
• Refresh data at the click of a button from any central enterprise data source defined by IT.
• Reduce the data source being viewed via an intuitive Filter dialog, so users only browse pertinent data. 
• Cycle through data that exceeds the row limitations of Excel.
• Embed SAS derived intelligence and information into Word, Excel and PowerPoint.
• Use Excel capabilities on the data displayed but have the ability to always access the latest view of information.
• Run multiple tasks with different data sources within one worksheet or document.
• Manipulate pivot tables to illustrate multidimensional data from various sources.
• Deliver results as RTF (Rich Text Format), HTML with Word, raw data (CSV), or HTML into Microsoft Office for native functionality.
• Deliver graphics results directly into Word, Excel or PowerPoint in ActiveX, GIF, JPEG or PNG formats.
• Refresh tables and charts automatically (and rerun any queries and apply relevant filters) to ensure the most up-to-date information is available. 
• Enable distribution of embedded results on demand using native Microsoft Office functionality.
• Users can control the size of report to be returned. An intuitive prompt is presented whenever the result set is over the size limit that has been specified by the user.
  

For a complete list of key benefits and features, refer to the SAS Add-In for Microsoft Office fact sheet.