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.

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.

Who should attend Power users Formats available Duration
: 8 half day sessions

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 course. You can gain SAS Enterprise Guide experience by attending the course.

This course addresses SAS Information Map Studio, SAS Analytics Platform, SAS OLAP Server, SAS Stored Process Server software.

Viewing Reports in the Platform for SAS Business Analytics

• exploring the platform for SAS Business Analytics
• discussing the course environment and scenario
• 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

Managing Data with the Platform for SAS Business Analytics

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

Creating Information Maps

• investigating SAS information maps
• using a single relational table
• working with multiple relational tables
• using a SAS OLAP cube
• implementing dynamic subsetting
• assigning prefilters to a relational data source

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

YBAFV2