ServicesServicesTrainingCourse Outlines
Advanced Impromptu

Duration: 1 Day

Audience: Experienced Impromptu Users

Brief:
The course is geared to Impromptu users who want to enhance their skills to handle more complex reporting requirements by exploiting the full potential of Impromptu’s advanced features. Attendees will learn how to customize their environment, set standards, create drill-through and sub-reports and build templates. In addition, workshops will provide techniques to enhance presentations, build complex calculations and automate procedures.

Course Notes:
This course can be delivered using an Impromptu demo database, or upon request your instructor will utilize your own database and catalogs as the basis for the workshops, examples, and class discussion. There is an additional fee for customization.

Recommended Prerequisites:
Introduction to Impromptu or equivalent experience (several months working with Impromptu – ability to add data, filter, sort, group, format and add calculations is assumed).

Glasses
Topics:

Setting up the Impromptu Environment
• Customizing Impromptu
• The startup process
• Defaults and preferences

Optimization
• Using Hot files and Smart Hot files
• Modifying data access

Presentation
• Frame-based reporting
• Types of frames and their uses
• Frame properties and formatting
• Conditional formatting

Analyzing Data
• Filters and conditions including summary filters
• Functions
• Date techniques
• Smart summaries

Sub-Reports
• Use sub reports with multiple queries to create
complex reports

Drill Through Reports
• Link summary reports to detail reports using
drill through technique

Advanced Prompt Usage
• Cascading prompts and various Pick list styles

Improving Performance
• Analyzing SQL
• Making the most of the database engine

Templates
• Using templates
• Adding advanced features to templates

Integrating and Automating
• Understanding OLE
• Importing and exporting
• Integrating with other Windows applications
including PowerPlay
• Creating macros
• Using the IBM Cognos Scheduler

Copyright 2009 © Creative Computing, Inc. All rights reserved | Privacy policy & Copyright
Services | Consulting | Staff Augmentation | IBM Cognos Training | Software: IBM Cognos, SAS, Microsoft |
Performance Management | Business Intelligence | Metrics Management | Office of Finance | Analytical Applications |
Data Integration | Data Marts | Data Cleansing | Data Federation | Data Management |
Predictive Analytics | Medical Analytics | Predictive Modeling | Forecasting | Optimization
Home | About CCI | Careers | Contact Us | Case Studies | Site Map