IBM Cognos

logo

Tailored to Needs

Call Us: 01225 339705 Email: This email address is being protected from spambots. You need JavaScript enabled to view it. Address: Verhoef Training, 11 Kingsmead Square, Bath, BA1 2AB

  • Register


Audience

This intermediate course is intended for Business Authors.


Prerequisites

Delegates should have a knowledge of basic Windows and Web functionality, as well as their business requirements. Additionally, they should have taken the Essentials for IBM Cognos BI (V10.2) - B5270G or have knowledge of IBM Cognos Connection, and have experience with Microsoft Excel or Microsoft Access.


Duration

2 days.


Objectives

This course will teach delegates the skills needed to use IBM Cognos Workspace Advanced to create effective reports with relational and dimensional data.

Interactive demos and workshops will cover topics related to creating reports with IBM Cognos Workspace Advanced.

Course objectives include:

    • Gain an overview of IBM Cognos BI.
    • Examine IBM Cognos Workspace Advanced.
    • Create a Report using Relational Data.
    • Create a Report using Dimensional Data.
    • Learn to Group and Sort Data.
    • Learn to Filter Data.
    • Highlight Report Data.
    • Integrate External Data.
    • Analyze Data Using Charts and Graphs.
    • Extend IBM Cognos Workspace Advanced Reports with Report Studio.
    • Use the Report Development Processes to Design Effective Reports.


Topics

Overview of IBM Cognos BI
Describe IBM Cognos BI and FPM.
Describe IBM Cognos BI components.
Describe IBM Cognos architecture at a high level.
Define IBM Cognos groups and roles.
Explain how to extend IBM Cognos BI.

Examine IBM Cognos Workspace Advanced
Identify the user interface components of IBM Cognos Workspace Advanced.
Launch IBM Cognos Workspace Advanced through different methods.
Determine browser options.

Create a Report using Relational Data
Explain Relational Data.
Explain object types.
Define report layouts.
Add data query items.
Use calculations.

Create a Report using Dimensional Data
Explain Dimensional Data.
Explore drill down and drill up with hierarchies.
Identify sets.
Define Financial reports.

Group and Sort Data
Define sorting (relational and dimensional).
Explain aggregated data.
Explore grouping data.
Explore dividing data into sections.

Filter Data
Understand suppression options.
Explore filtering data (relational and dimensional).
Explore filtering aggregated data.

Highlight Report Data
Explain query item properties.
Use formatting to improve the visual effectiveness of reports.
Use conditional styles to highlight query items on a report.

Integrate External Data
Examine the use of external data in reports.
Map query subject from an enterprise report to external data.

Analyze Data Using Charts and Graphs
Review multiple data analysis processes.
Implement a report for each process.

Extend IBM Cognos Workspace Advanced Reports with Report Studio
Identify IBM Cognos Workspace Advanced reports that can benefit from Report Studio capabilities.
Create a report in Report Studio and open it in IBM Cognos Workspace Advanced.
Create a report in IBM Cognos Workspace Advanced and extend it in Report Studio.

Use the Report Development Processes to Design Effective Reports
Discuss phases of report development for business authors.
Discuss elements of effective reports.

S5 Box

Login

Register