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.

Please refer to Course Overview for description information

This intermediate course is for Business Authors.

You should have knowledge of your business requirements.

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

Prior to enrolling, IBM Employees must follow their Division/Department processes to obtain approval to attend this public training class. Failure to follow Division/Department approval processes may result in the IBM Employee being personally responsible for the class charges.

GBS practitioners that use the EViTA system for requesting external training should use that same process for this course. Go to the EViTA site to start this process: http://w3.ibm.com/services/gbs/evita/BCSVTEnrl.nsf

Once you enroll in a GTP class, you will receive a confirmation letter that should show:

• The current GTP list price
• The 20% discounted price is available to IBMers for GTP delivered courses only. This is the price you will be invoiced for the class.