N0CRF – IBM Cognos Analytics Report Authoring Fundamentals

Overview of Cognos Analytics

• What is Cognos Analytics?
• Launching Cognos Analytics
• Cognos Analytics Layout & Panes
• Existing Reports
• Cognos Analytics Report Types

Building List Reports

• Report Templates
• Data Panel Source, Data Items, and Toolbox
• Relational Package Objects
• Adding Data Items to a Report
• Reorganizing Report Data Items
• Remove, Re-Order, Add columns
• Navigate Query Explorer
• Grouping and Group Spans
• Formatting Report Objects
• Adding a Title to a Report
• Naming Report Objects
• Saving and Running Reports

Filtering and Sorting Reports

• Sorting a Report
• Layout Sorting
• List Headers and Footers
• Filtering Data
• Advanced Filters

Using Prompts in Reports

• What are Prompts?
• Creating prompts
• Build a Prompt Page Tool
• Create a Parameter in a Filter
• Prompts directly in a Report Page
• Cascading Prompts

Creating Crosstab Reports

• Crosstab Reports
• Swap Rows and Columns
• Format Measures in Crosstab
• Pivot a List to a Crosstab

Creating Advanced Crosstabs

• Nesting and Stacking Crosstabs
• Creating an Asymmetric Crosstab
• Crosstab Spaces
• Crosstab Default Measure

Adding Calculations to your Report

• Adding Calculated Data Items
• Query Calculations
• Layout Calculations
• Functions

Reporting with Charts

• Adding Charts
• Chart Formatting
• Visualizations

Enhancing your Report

• Enhancing Reports
• Text Objects and Images
• Table Styles
• Report Style References
• Formatting Objects
• Custom Grouping
• No Data Property
• Visual Aids
• Layout Component Reference
• Templates

Applying Conditional Formatting

• Apply Conditional Formatting
• Conditional Formatting Steps
• Variable Types
• Conditional Rendering
• Unlocking Report Objects

Drill Through Reports

• Drill Through
• Benefits of Drill-Through
• Drill-Through Process

Integrating External Data

• Working with External Data
• Upload Data File Wizard
• Data Modules

Workshops

Audience

• Professional Report Authors

Prerequisites

• There are no prerequisites for this course

Instructor Led In Classroom

Newcomp can directly deliver  IBM Business Analytics courses for Business Intelligence, Performance Management, and IBM Advanced Analytics through the use of in-class training facilities.

Currently,  in-class courses are offered in Markham, Ottawa, Vancouver, Halifax, and Edmonton. Please note that classes can be added to new areas based on demand.

Instructor Led Online

Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples

ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.