SAS business intelligence and data integration tools
Aims
The course covers all business intelligence applications as provided for by SAS version 9.1.3, from SAS platform management and administration to preparing and distributing information.
Who should attend
End users, Business users.
Prerequisites
Familiarity with individual computing tools; this course does not require knowledge of SAS.
Course outline
Introduction to SAS Enterprise Intelligence Platform
- SAS Business Intelligence: Overview and Security
- Java, Windows and Web Browser Applications
Overview of SAS Management Console
- Interface organisation
- User management and security
- SAS Management Console Plug-In
Use of SAS Data Integration Studio
- Overview and application areas
- Interface organisation
- Library management
- Main tools: Source Designer, Target Designer, Processes Designer
Use of SAS OLAP Cube Studio
- Overview, user interface and main functions
- OLAP Cubes definition, management and analysis
Use of SAS Add-in for Microsoft Office
- SAS data and functions management from MS Excel
Use of SAS Enterprise Guide
- Organisation, interface and main functions
- EG Projects organisation and management
- Management of Stored Process by Enterprise Guide tools
- Use of OLAP cubes in SAS Enterprise Guide
Use of SAS Stored Processes
- Overview and application areas
- Stored Process creation, registration, distribution
Use of SAS Web Report Studio
- Functions for construction of Web reporting
- Main types of available reports
Use of SAS Information Delivery Portal
- Overview and main portal features
- Publication and distribution techniques.
Duration
The duration of the course is 3 days.