Federated Query, Analysis and Write-Back for the Microsoft Office Desktop

arcplan Excel Analytics® extends arcplan's analytical power to the Microsoft Office desktop by providing a seamless integration of arcplan application content and functionality to Microsoft Excel. arcplan Excel Analytics extends the capabilities of arcplan Enterprise deployments by providing ad-hoc analysis capabilities across multiple data sources in a broadly available and familiar Microsoft Office environment.

Easily scalable across the enterprise, arcplan Excel Analytics empowers users to further analyze corporate data and write-back to the original data sources as needed, while maintaining the security and centralized control demanded by the IT organization.

Available Functions

Business users, analysts, IT staff and managers can easily ...

  • Export arcplan applications, queries, and objects directly to Microsoft Excel
  • Create centralized and secure Excel applications while conforming to IT governance and standards
  • Switch from an arcplan web client directly to a corresponding Excel analysis while maintaining connectivity to the arcplan application and source data
  • Perform offline analysis against arcplan application content
  • Access all major databases and BI systems via Excel
  • Perform ad-hoc analysis based on arcplan application content in an Excel spreadsheet environment

With arcplan Excel Analytics, business users take advantage of Excel's built-in functionalities to further query, analyze, and modify the data. arcplan Excel Analytics allows users to integrate data in Excel from multiple data sources, including systems from SAP, Oracle, IBM, Microsoft and others, serving as the Excel Add-In to data sources for which a native Excel Add-In does not exist.

Due to the pervasiveness of Excel within many organizations, users can now view and analyze corporate-wide performance data within a familiar Excel environment and make real-time business decisions based on a single version of the truth.

Click here to download the product FAQ or the product product brochure (PDF files).