support & services / Education

SAS Business Intelligence Reporting: Fast Track - YBUFT93

This course teaches how to access reports and analyze data using several of the business user applications in the platform for SAS Business Analytics.

Download course description as PDF   Register now  


4 days - Classroom

Learn how to

  • identify the various types of reports
  • work with SAS analyses
  • interact with multidimensional data
  • access SAS data sources
  • create reporting presentations
  • build and enhance SAS reports on the Web using advanced features
  • access different types of data sources and run advanced SAS analyses in Microsoft Office applications
  • share reports across your organisation.

Who should attend?

Business users and others who want to learn how to access, analyze, and create information using the SAS Add-In for Microsoft Office, SAS Information Delivery Portal, and SAS Web Report Studio


There are no formal prerequisites for this course.

Course Contents:

Reporting and the SAS Platform for Business Analytics

  • exploring the SAS Business user applications
  • discussing the course environment and scenario

Accessing Reports Using the SAS Information Delivery Portal

  • identifying report types
  • interacting with SAS BI Dashboards
  • working with SAS reports
  • running SAS Stored Processes

Building SAS Reports on the Web

  • exploring the SAS Web Report Studio roles
  • considering basic reporting concepts
  • creating a report with the report wizard
  • creating a report in edit mode
  • creating a report using a report template

Enhancing SAS Reports on the Web

  • working with summarization options
  • modifying the report layout
  • working with report sections
  • subsetting displayed data
  • modifying report objects
  • specifying report properties
  • printing and exporting reports

Working with Data Sources in Microsoft Excel

  • understanding SAS data
  • accessing data in the SAS Add-In for Microsoft Office
  • exploring data characteristics for a SAS table
  • running analyses using the SAS Add-In for Microsoft Office
  • using data writeback

Creating Report Presentations Using the SAS Add-In for Microsoft Office

  • controlling and managing the SAS Add-In output
  • working with templates and SAS favorites

Interacting with Multidimensional Reports

  • understanding Online Analytic Processing (OLAP) capabilities
  • working with OLAP reports on the Web
  • working with OLAP data in Microsoft Excel
  • Building and Sharing Report Presentations (Case Study)

Software Addressed

This course addresses Platform for SAS Business Analytics, SAS Add-In for Microsoft Office, SAS Information Delivery Portal, SAS Web Report Studio software.

Book Your Place Today