About this course

Course code TPZL1_B5A81
Duration 2 Days

This course will develop the skills participants will need to use IBM Cognos Workspace Advanced to create effective reports with relational and dimensional data. Through interactive demos and workshops, this course will present topics related to creating reports with IBM Cognos Workspace Advanced for the business author.

Prerequisites

This intermediate course is for Business Authors.

You should have knowledge of your business requirements.

Delegates will learn how to

Please refer to Course Overview for description information

Outline

Examine IBM Cognos Workspace Advanced

  • Identify the user interface components of IBM Cognos Workspace Advanced
  • Launch IBM Cognos Workspace Advanced
  • Examine report templates
  • 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

  • Define Dimensional Data
  • Define Dimensionally-Modeled Relational (DMR) data
  • Explore hierarchies with drill down and drill up
  • Identify sets
  • Define a Financial Report layout

Sort and Group Your Data

  • Define sorting
  • Explain aggregated data
  • Discuss grouping data
  • Discuss dividing data into sections

Filter Your Data+B20

  • Â Discuss suppression options
  • Discuss filtering data
  • Discuss filtering aggregated data

Highlight and Visualize Report Data

  • Explain query item properties
  • Discuss formatting objects
  • Discuss conditional styles
  • Explain RAVE visualizations

Integrate External Data

  • Define external data
  • Discuss security permissions for user access to external data capability
  • Discuss steps to integrate external data
  • Discuss mapping data
  • Explain how to link external data
  • Discuss data attributes Â

Analyze Data Using Charts and Graphs

  • Discuss data analysis processes
  • Explain types of reports and best practice for report analysis

Integrate Cognos Workspace Advanced with other BI Tools

  • Discuss Report Studio functionality that can add additional value to meet business needs
  • Discuss integration of Cognos Workspace Advanced within Cognos Workspace

Appendix A. Â Overview of IBM Cognos BI (Optional)

  • Describe IBM Cognos BI and Financial Performance Management
  • Describe IBM Cognos BI components
  • Describe IBM Cognos BI architecture at a high level
  • Define IBM Cognos  groups and roles
  • Explain how to extend IBM Cognos

2 Days

Duration
Training delivered by an IBM Global Training Provider
Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0345 074 7998 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.