About Impromptu

This Course is designed for those who will be involved in the administrative development, support and maintenance of Impromptu. It will provide you with IBM Cognos 7.4 Impromptu administration capability, which will enable you to effectively plan, develop and deploy effective Impromptu reports within your organization.
The course builds a catalog from scratch using a data source. You will review the role of Impromptu within your environment and be able to identify when it is the correct tool to deploy.

Who should attend?

Professional report authors.

Prerequisites

Knowledge of common industry standard data structures and design.

Course Content

1: Overview the Basic Components

Review the terminology that surrounds ‘Business Intelligence’ (BI).

Identify the BI application components available.

Review the relationship between the various components.

Identify the key components for this BI development Administrator course.

Have a first look at Cognos Impromptu Administrator and PowerPlay Transformer.

2: Database Connectivity

Review Impromptu Administrator Connectivity.

Connect Impromptu to Access database via ODBC.

3: Impromptu Catalogs

Learn what an Impromptu Catalog is.

Create a Catalog.

Review Catalog components.

Review Catalog content overview report.

4: Folders and Columns

How to ADD, MOVE (cut and paste) and REMOVE Folders and Columns.

How to RENAME Folders and Columns.

How to use GENERATE to create reports and additional tables.

Review the training Catalog Folders.

5: Tables and Joins

Remove Tables, limit the Tables retrieved and review Table qualification.

Create ALIAS Tables.

Create Joins and understand the difference

Between Inner and Outer Joins and Complex and Non-Complex Joins.

6: Tables and Joins

Work with Catalog Conditions.

Work With Catalog Calculations.

Work with Catalog Prompts.

7: Maintenance, Performance and Security

Work with user classes.

Control the user environment.

Manage the impact on database and network.

Troubleshoot Impromptu problems.

8: Impromptu Reporting

Learn to open and close a Catalog, and create, save and open a Basic Report.

Filters.

Sorting.

Grouping.

Summaries.

Calculations and Functions.

Report Formatting and Titles.

Call Now- +91-921-276-0556

Send a Query









Tai Infotech Pvt Ltd, 2017 All Rights Reserved