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.

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.

http://www.ibm.com/training/terms

Please refer to the Course Overview for description information.

This 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