Create, Access, and View Data – All the tools you need!

This post was kindly contributed by SAS BI Books - go there to comment and to read the full post.

SAS EBI is comprised of several applications.  Here is a quick overview:

Make Data

  • SAS OLAP Cube Studio
    • Build OLAP cube using SAS datasets.
  • SAS Information Map Studio
    • Build information maps from SAS datasets and OLAP cubes.
  • SAS Enterprise Guide
    • Connect to SAS datasets, RDBMS, and even Excel spreadsheets
  • SAS Add-In for Microsoft Office
    • Possible to create data in MS Excel that you can save to the server and then use in other BI Tools.  This would be an option for smaller datasets that are updated infrequently and not centrally stored, for instance, an department organization structure.

Use Data

  • Web Report Studio
    • Create reports from OLAP Cubes, Info Maps, or SAS datasets.
  • SAS Enterprise Guide
    • Create reports and more from OLAP Cubes, Info Maps, or SAS datasets.
    • Also create reports that can be shared as a stored process for the other SAS
  • SAS Add-In for Microsoft Office
    • In MS Excel – Create reports from OLAP Cubes, information maps, or SAS datasets.  Mix SAS data with the data from Excel spreadsheets.
    • In MS Office/PowerPoint – create reports from cubes, information maps, or datasets.  Not as much flexibility as with MS Excel, but you can easily create report that you can share with other applications.
  • SAS Dashboard
    • Use the summarized data to create dials, maps, and other indicators.

Display Data

  • SAS Add-In for Microsoft Office
    • MS Outlook allows you to see and share reports from Web Report Studio.
  • SAS Portal
    • Combine all your Web Report Studio reporting, stored processes, and publication channels, and even external web sites in one location.

This post was kindly contributed by SAS BI Books - go there to comment and to read the full post.