About this course

Course code TPYBAFTM3
Duration 4 Days

This intensive training course provides accelerated learning for those students who will build reports, analyses, and dashboards for consumption by business users and other information consumers in their organization. This course is for individuals who are comfortable with learning large amounts of information in a short period of time.

Prerequisites

No SAS experience or programming experience is required, although you should have some computer experience. Specifically, you should

  • be able to log on and off a computer and use a keyboard or mouse
  • have some experience using Microsoft Word and Microsoft Excel (specifically, you should be able to open and save documents, use the menus and toolbars to accomplish tasks, and navigate Word documents and Excel spreadsheets)
  • know how to use a Web browser to access information.

Experience with SAS programming and/or SAS Enterprise Guide is helpful but not required. You can gain SAS programming experience by attending the SAS Programming 1: Essentials course. You can gain SAS Enterprise Guide experience by attending the SAS Enterprise Guide 1: Querying and Reporting course.

This course addresses SAS Information Map Studio, Platform for SAS Business Analytics, SAS OLAP Server, SAS Stored Processes software.

Who should attend

Power users

Delegates will learn how to

  • use the information consumer applications in the platform for SAS Business Analytics
  • explore the basic data management functionality available in the SAS platform
  • explore the basic online analytical processing capabilities available in the SAS platform
  • create and exploit dynamic value selection
  • build advanced information maps using SAS Information Map Studio
  • produce advanced stored processes
  • create advanced SAS BI Dashboard applications
  • examine the types of metadata created in the SAS platform
  • consolidate information into a business reporting application.

Outline

Introduction

  • exploring the platform for SAS Business Analytics
  • introducing the SAS Education job roles
  • introducing the course environment and scenario

Overview of the Information Consumer Reporting Applications

  • examining the SAS reporting applications
  • accessing reports using the SAS Information Delivery Portal
  • working with reports using SAS Web Report Studio
  • presenting information using the SAS Add-In for Microsoft Office

Overview of Data Management

  • understanding SAS data integration capabilities
  • creating data sources using SAS Enterprise Guide
  • creating data sources using SAS Data Integration Studio
  • building an OLAP cube

Creating Information Maps

  • understanding SAS information maps
  • using different data sources
  • exploiting dynamic subsetting of data
  • creating prefilters to subset the information map data
  • building an information map from a SAS OLAP cube

Creating Stored Processes

  • understanding SAS Stored Process concepts
  • creating a stored process from a SAS Enterprise Guide project
  • adding prompts to a stored process
  • using cascading prompts
  • working with prompt groups
  • creating a stored process from a SAS program

Creating Dashboards

  • SAS BI Dashboard terminology and interfaces
  • designing SAS BI Dashboard components
  • creating indicator data
  • creating ranges
  • creating indicators
  • creating dashboards and defining interactions

Examining the Environment Metadata

  • reviewing the platform for SAS Business Analytics
  • reviewing the course environment and metadata

Building an Information Consumer Reporting Application

  • building an information consumer reporting application
  • SAS Web Report Studio reference topic: creating a report in edit mode
  • SAS Information Map Studio reference topic: creating information maps from multiple tables
  • SAS Information Map Studio reference topic: creating identity-driven prefilters
  • SAS BI Dashboard reference topic: using a stored process data source
  • SAS BI Dashboard reference topic: using a table data source

Learning More

  • SAS resources
  • beyond this course

4 Days

Duration

This is a QA approved partner course

Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0345 074 7998 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.