Code
B5A81GRO
Duration
2 days
Tags
Online Offline

DescriptionWhat we offer

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.

ObjectivesWhat you learn

Please refer to Course Overview for description information

TopicsThe best for you

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

PrerequisitesWhat should you know

You should have knowledge of your business requirements.

AudienceWho should attend

This intermediate course is for Business Authors.