SAS IT Resource Management: Administration and Reporting
Duration: 4.0 days CEU: 2.4
This course provides an introduction to SAS IT Resource Management 3.1. The course uses SAS IT Resource Management to build and maintain an IT data mart and explores the use of this solution to create the jobs that extract, transform, load, and summarize IT performance and usage data. SAS Enterprise Intelligence is used to create and deliver reports from the IT data mart.
Learn how to
- define and build an IT data mart
- use an IT data mart to deliver analysis- and report-ready data to members of your organization
- use components of SAS Enterprise Intelligence to create report definitions and to produce and deliver reports via the SAS Mid-Tier Server to the Web.
Who should attend
IT professionals who are responsible for the performance and capacity management of their IT resources.
Prerequisites
Before attending this course, you should identify the IT services that your enterprise wants to analyze, as well as the sources of data (such as logs) about these services. You should have knowledge of your native operating system environment and data sources. In addition, you should complete the following courses or have equivalent experience:
- Overview of SAS Business Intelligence and Data Integration Applications
- Using SAS Data Integration Studio to Build Data Marts from Enterprise Data Sources
- Querying and Reporting Using SAS Enterprise Guide
Course Contents
Introduction to SAS IT Resource Management
- introduction to SAS IT Resource Management 3.1
- overview of SAS Intelligence Architecture
- introduction to the SAS components underlying SAS IT Resource Management
- introduction to the course data
Defining and Building an IT Data Mart
- introduction to the ITMS Repository and the IT data mart
- SAS Data Integration Studio with SAS IT Resource Management plug-ins
- creating an IT data mart
- introduction to the data model
SAS IT Resource Management Data Flow
- the SAS IT Resource Management job
- staging transformations and tables
- aggregation transformations and tables
- information map transformations and information maps
- job deployment
Staging
- the staging transformation
- adding staged tables
- staged tables: the data model and user customization
Aggregation
- introduction to aggregation jobs and tables
- defining summarized aggregation tables
- data structure
- aggregation filters
- statistics
- ranking
- aggregation computed columns
The Information Map
- adding an information map transformation
- using SAS Information Map Studio
The Aggregation Data Model
- introduction to the data model
- aggregations
- information maps
- adapter report groups
User-Written Adapter Support
- user-written staging
- staging with MXG
- the aggregation jobs
Reporting with SAS Enterprise Guide
- introduction to reporting
- using SAS Enterprise Guide
- basic reporting
- analytics
- deploying SAS Enterprise Guide report jobs
SAS Add-In for Microsoft Office and Web-based Tools
- SAS Add-In for Microsoft Office
- SAS Web Report Studio
- SAS Information Delivery Portal
Software Addressed
This course addresses the following software product(s): SAS IT Management Solutions, SAS IT Resource Management.
Course Materials
Students receive a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.
U.S. Schedule
20OCT2008 Phoenix, AZ
| 17NOV2008 Chicago, IL
| |
Check for additional and updated schedule information online at
support.sas.com/courses/itrm3.html.
Registration
To register for this course in the US, call 800-333-7660 or visit
support.sas.com/training.
This course is also available for on-site training, or you can create a custom course by combining material from several courses. For more details, contact SAS Education in Cary, NC at 919-531-7321 or send e-mail to
training@sas.com.