Products & Solutions / SAS Office Analytics for Midsize Business

SAS® Office Analytics for Midsize Business

Transparently leverage the power of SAS® for data access, reporting and analytics directly from Microsoft Office environments

SAS Office Analytics for Midsize Business enables organizations that have invested deeply in Microsoft Office products (Excel, PowerPoint and Word) to obtain consistent views of data, automate report generation and add analytical insights while keeping information consumers within their interface comfort zone.

It revolutionizes the world of business intelligence for smaller organizations by enabling their business users to leverage the power of SAS for data access, reporting and analytics directly from Microsoft Office via integrated menus and toolbars.

Benefits

  • Makes consistent data from multiple sources easily available.
  • Provides business users with self-sufficient access to powerful SAS Analytics from within Microsoft Office.
  • Helps satisfy corporate and governmental compliance regulations.

Read more

Features

  • Data access and management
  • Powerful SAS® Analytics
  • Graphics and reporting
  • Guided analysis and model development for power users
  • Business metadata management for IT

Read more

How SAS® Is Different

  • SAS Office Analytics for Midsize Business provides real-time access to data, enabling users to refresh data automatically, as well as run any queries and apply relevant filters to ensure that the most up-to-date information is readily available.
  • SAS Office Analytics for Midsize Business allows users to access the market-leading statistical power of SAS. Advanced analytics are available to business users via SAS Enterprise Guide and SAS/STAT software, both included with this offering.
  • Business analysts and users do not need to leave the comfort and familiarity of Microsoft Office (Word, Excel or PowerPoint) to produce management reports or manipulate results.
  • Minimal training is required to produce information for fact-based decisions that can drive competitive advantage and increased profitability. Everyone has some familiarity with Microsoft Office tools, and it is natural for businesses to use this as their standard for management reports. SAS Office Analytics for Midsize Business enables users to go beyond the capabilities of Microsoft Office products to create data access paths and statistical routines to create greater analytical insights.
  • After arriving at the desired analytical or reporting results, users can publish the Microsoft Office documents to decision makers using native Office functionality, and the recipients can update the embedded results from the Office documents as needed. Users can reduce and organize results to acceptable sizes for their needs and identify the data that will be inserted in Microsoft Excel.

Benefits

  • Makes consistent data from multiple sources easily available. Instead of everyone building their own extracts of data and merging and managing that data in Microsoft Excel, users can take the most recent data from operational systems and populate Excel or PowerPoint applications. No longer will users have different versions of the same report.
  • Provides business users with self-sufficient access to powerful SAS Analytics from within Microsoft Office. SAS Office Analytics enables Excel users to access and view data sources and analyze the data with high-end analytics from SAS, meaning they get more than just summaries and basic graphs. An intuitive query interface returns analytic results directly into Excel spreadsheets, enabling users to preview and query large amounts of data. Business users can be assured they have the up-to-date data needed for accurate analysis and remove the problems associated with intermediate summarized data formats.
  • Helps satisfy corporate and governmental compliance regulations. With SAS, you can produce repeatable results using validated data and processes that are easily documented and verified for corporate and governmental compliance. Think how much time can be saved – no more tracking down which report is correct. 

Features

Data access and management
  • Access SAS capabilities for data access, reporting and analytics directly from Microsoft Office tools, including Word, Excel and PowerPoint.
  • Access data from any centrally IT-defined enterprise data source.
  • Easy data access and integration without detailed knowledge of the database or SQL.
  • Refresh data at the click of a button from any central enterprise data source defined by IT.
  • Cycle through data that exceeds row limitations of Microsoft Excel. (Server-side optimization ensures large data sources are never transferred as one to the client.)
  • Includes SAS/ACCESS® Interface to PC Files for access to Microsoft Excel, Microsoft Access, dBase, Lotus, SPSS, JMP® and Stata.
  • Includes SAS/ACCESS® Interface to ODBC for access to any ODBC-compliant data source.
Powerful SAS® Analytics

A wide range of powerful statistical analysis capabilities, including:

  • Analysis of variance for analyzing experimental data.
  • Regression to examine the relationship between a response variable and a set of explanatory variables.
  • Categorical data analysis for investigating the association of data categories and the strength of the relationships.
  • Multivariate analysis for modeling data with two or more response variables or for identifying relationships among variables.
  • Survival analysis for measuring lifetime or time until an event.
  • Cluster analysis, which places observations into groups based on similarity.
  • Multiple imputation that lets you fill in missing values to generate complete data sets.
Graphics and reporting
  • Wizard-driven report creation from within Microsoft Office tools.
  • Render reports created with SAS inside of Microsoft Office applications.
  • Refresh tables and charts automatically to get the latest view of information.
  • Manipulate pivot tables to illustrate multidimensional data from various sources.
  • Deliver graphics into Microsoft Word, Excel or PowerPoint as ActiveX, GIF, JPEG or PNG formats.
  • Enable distribution of embedded results on demand using native Microsoft Office functionality.
  • Provide the ability to add SAS dashboards and SAS Stored Processes to a SharePoint page.
Guided analysis and model development for power users
  • A .NET-based native Windows application for programmers, analysts or advanced users.
  • User interface includes context-sensitive menus, toolbars and role-based user definitions.
  • Provides a large number of prebuilt tasks and task templates covering a wide variety of topics.
  • Wizard-driven conditional flow logic capabilities for more rapid creation of complex conditional processing.
  • Enhanced complex query with computed columns creation, filtering options and preview of results brings efficiency to the query-building process.
  • View OLAP cubes from SAS or other vendors that support OLE DB for OLAP and the MDX standard.
  • Package results into SAS Stored Processes that can be used in all SAS Business Intelligence interfaces and Microsoft Office to gain access to anything SAS can do, allowing work to be distributed without IT involvement while maintaining security.
Business metadata management for IT
  • Map physical data structures to business terms in an easy-to-use interface.
  • Combine data from multiple sources.
  • Control the size of result sets that can be returned to avoid long-running queries.
  • Centrally manage metadata.
  • Create and manage prompts, including cascading prompts, that dynamically generate value lists and repositories, control the SAS Metadata Server, define access controls and register and manage users and groups through a single interface.

System Requirements

Client environment
  • Microsoft Windows (x86-32): Windows 2000 Professional, Windows XP Professional, Windows Server 2003 family, Windows Server 2008, Windows Vista*
Supported Web browsers
  • Internet Explorer 6 on Windows XP Pro
  • Internet Explorer 7 on Windows XP Pro, Microsoft Server 2008 and Windows Vista*
  • Firefox 2.0 on Windows XP Pro, Microsoft Server 2008, Windows Vista* and Linux for x86 (SuSE and RHEL)
Server environment
  • AIX: Version 5.3 and 6.1 on POWER architectures
  • HP-UX Itanium: HP-UX 11iv2 (11.23), 11iv3 (11.31)
  • HP-UX PA-RISC: HP-UX 11iv2 (11.23), 11iv3 (11.31)
  • Linux for x86 (x86-32): RHEL 4 and 5, SuSE SLES 9 and 10
  • Linux for x64 (EM64T/AMD64): RHEL 4 and 5, SuSE SLES 9 and 10
  • Microsoft Windows (x86-32): Windows XP Professional, Windows Server 2003, Windows Server 2008, Windows Vista*
  • Microsoft Windows (on Itanium): Windows Server 2003
  • Solaris on SPARC: Version 9, 10
  • Solaris on x64: Version 10

* NOTE: Windows Vista Editions that are supported include Enterprise, Business and Ultimate

NOTE: The required Microsoft .NET framework cannot be installed on 64-bit machines

NOTE: Includes MDAC 2.7 and the required Visual C++

Ready to learn more?

Call us at 01628 486 933 (UK) or request more information.