IBM Cognos 8 Query Studio Training Course Outline

Duration: 1 day

Audience: Business Users with Query Needs

Brief:
This course is geared towards non-technical business users who need a web-based vehicle to access and report data which resides in corporate data bases. It is designed to teach the basic reporting techniques needed to quickly extract relevant information in a meaningful format and layout. Basic techniques include query creation, sorting, grouping, calculations, etc.

Course Notes:
This course is delivered using a general IBM Cognos 8 demo application as the basis for the workshops, examples, and class discussion. If desired, custom courseware using client’s data may also be created. There is an additional fee for customization of the course materials.

Recommended Prerequisites:
None. However, familiarity with Windows, use of a web browser, and experience with the core MicroSoft Office suite of tools (Word, Excel, Access, etc) is desirable.

Training materials are copyrighted proprietary materials owned exclusively by Applied Business Systems, Inc.

Topics:

Introduction
• Review class objectives

IBM Cognos Connection Overview
• Logon procedures
• Capabilities
• Overview of portal
• Using folders
• Report objects

Query Studio Overview
• The basic functionality
• Creating a new report
• Data icons

Data and Report Formatting
• Modifying and formatting your report
• Grouping data; collapsing/expanding
your report; and sections
• Creating a custom group
• Page breaks; Page size
• Sorting data
• Drill up and drill down
• Navigate to a new report
• Best practices

Data Selection & Calculations
• Data selection
• Combining filters
• Data calculations

Crosstab Reports and Charts
• Crosstab reports
• Charts