Overview

Students will explore IBM Cognos Analytics report authoring and different report object types (list, crosstab, chart, visualization, etc.). They will also create and format reports using grouping, headers, footers, and other formatting options. Also covered is the ability to focus reports by filtering data and using prompts. Students will learn to add value to reports using calculations and additional report-building techniques as well as how to enhance reports with advanced formatting and exceptional data highlighting.

Audience

Report Authors

Prerequisites

• Knowledge of your business requirements
• Experience using IBM Cognos Analytics as a consumer

Objective

Introduction to IBM Cognos Analytics – Reporting 

• Examine IBM Cognos Analytics
• Reporting and its interface
• Explore different report types
• Create reports in preview or design mode
• Create a simple, sorted, and formatted report
• Examine dimensionally modeled and dimensional data sources
• Explore how data items are added queries
• Examine personal data sources and data modules

Examine data tables and list reports

• Create a data table
• Group, format, and sort list reports
• Describe options for aggregating data
• Create a multi-fact query
• Create a report with repeated data

Create crosstab reports

• Format and sort crosstab reports
• Create complex crosstabs using drag and drop functionality
• Create crosstabs using unrelated data items

Create visualization reports

• Understand visualization categories
• Create and customize visualizations
• Understand client-side visualizations
• Create enhanced map visualizations

Focus reports using filters

• Create filters to narrow the focus of reports
• Examine detail and summary filters
• Determine when to apply filters on aggregate data

Focus reports using prompts

• Identify various prompt types
• Use parameters and prompts to focus data
• Search for prompt types
• Navigate between pages

Extend reports using calculations

• Create calculations based on data in the data source
• Add run-time information to the reports
• Create expressions using functions

Customize reports with conditional formatting

• Create multilingual reports
• Highlight exceptional data
• Show and hide data
• Conditionally render objects in reports

Drill-through definitions  

• Introduction to drill-through definitions
• Navigating to related data
• Introduction to bookmark references

Enhance report layout

• Force page breaks in reports
• Format data and report objects
• Modify existing report structures

Use additional report building techniques

• Enhance report design with report objects
• Add objects to reports
• Convert a list to a crosstab
• Reuse objects within the same report
• Share layout components among separate reports
• Choose options to handle reports with no available data

Course Outline

Introduction to IBM Cognos Analytics – Reporting 

• Examine IBM Cognos Analytics
• Reporting and its interface
• Explore different report types
• Create reports in preview or design mode
• Create a simple, sorted, and formatted report
• Examine dimensionally modeled and dimensional data sources
• Explore how data items are added queries
• Examine personal data sources and data modules  

Examine data tables and list reports

• Create a data table
• Group, format, and sort list reports
• Describe options for aggregating data
• Create a multi-fact query
• Create a report with repeated data  

Create crosstab reports

• Format and sort crosstab reports
• Create complex crosstabs using drag and drop functionality
• Create crosstabs using unrelated data items  

Create visualization reports

• Understand visualization categories
• Create and customize visualizations
• Understand client-side visualizations
• Create enhanced map visualizations  

Focus reports using filters

• Create filters to narrow the focus of reports
• Examine detail and summary filters
• Determine when to apply filters on aggregate data  

Focus reports using prompts

• Identify various prompt types
• Use parameters and prompts to focus data
• Search for prompt types
• Navigate between pages  

Extend reports using calculations

• Create calculations based on data in the data source
• Add run-time information to the reports
• Create expressions using functions  

Customize reports with conditional formatting

• Create multilingual reports
• Highlight exceptional data
• Show and hide data
• Conditionally render objects in reports

Drill-through definitions  

• Introduction to drill-through definitions
• Navigating to related data
• Introduction to bookmark references  

Enhance report layout

• Force page breaks in reports
• Format data and report objects
• Modify existing report structures  

Use additional report building techniques

• Enhance report design with report objects
• Add objects to reports
• Convert a list to a crosstab
• Reuse objects within the same report
• Share layout components among separate reports
• Choose options to handle reports with no available data