BUSINESS ANALYST

Business Analysts understand not only their organisation’s data, but also the tools they need to use to create reports and analyses. Business Analysts use a range of tools, including Microsoft Office applications, SAS Enterprise Guide 4 and OLAP. They may even write some SAS programs and create stored processes.

Advanced and Specialty Courses:

• Advanced Querying UsingSAS® Enterprise Guide

Querying and Reporting Using SAS® Enterprise Guide®

This course is designed for analysts and statisticians who are not programmers but need to access, manage, and summarize data from different sources, and present results in tables and graphs. This course focuses on using the menu-driven tasks in SAS Enterprise Guide, the point-and-click interface to SAS, to create queries and reports. To learn SAS programming techniques, you should attend the
SAS® Programming I: Essentials course.

Learn how to:

• access and manipulate local and remote data
• create simple and advanced queries
• create frequency and tabular reports
• create static and interactive graphs
• automate and schedule tasks.

Who should attend: Analysts and statisticians who want to use the menu-driven tasks in SAS Enterprise Guide

Level I: Getting Started

Duration: 2 days

Learn more: support.sas.com/courses/egqr4.html

Creating and Exploiting OLAP Using the SAS® System

This course teaches you how to understand, create, and exploit Online Analytical Processing (OLAP) using SAS. This course requires the SAS Intelligence Platform.

Learn how to:

• create SAS OLAP cubes derived from detail tables and star schemas
• generate aggregations using crossdimensional tuning and ARM analysis
• set access permissions for SAS OLAP cubes
• exploit SAS OLAP cubes
• use MDX in SAS Enterprise Guide to perform basic queries and create named sets.

Who should attend: Data modelers and system experts

Level II: Fundamentals

Duration: 2 days

Certification: This course is suggested preparation for the SAS Warehouse Technology exam and the SAS Warehouse Development Specialist Concepts exam.

Learn more: support.sas.com/courses/sbiolap.html

Creating, Distributing, and Using SAS® Stored Processes

This course teaches you how to create SAS programs that can be distributed to many users and run within many applications. This course requires the SAS Intelligence Platform.

Learn how to:

• use the SAS Management Console or SAS Enterprise Guide to create and register stored processes
• design stored processes to use input parameters and set parameter constraints
• execute stored processes within the SAS Add-In for Microsoft Office, SAS Enterprise Guide, and SAS Web Report Studio
• create transient and permanent result packages.

Who should attend: Business analysts, report designers, and programmers

Level III: Intermediate

Duration: 2 days
Learn more: support.sas.com/courses/sbisp.html