IBM Cognos Analytics: Author Reports Fundamentals (v11.1.x)

COURSE OUTLINE:

Description

This course provides you with an introduction to report building techniques using relational data models. You�ll learn techniques to enhance, customize, and manage professional reports. Hands-on activities will illustrate and reinforce key concepts and skills.

Audience

Report Authors and Business Analysts

Prerequisites

You should have:

  • Knowledge of your business requirements
  • Experience using the Windows operating system
  • Experience using a Web browser

Learning Objectives

  • Dimensionally modeled relational data
  • How to use personal data sources and data modules
  • Examining list reports
  • Aggregating fact data
  • Using multiple facts and repeated information
  • Add repeated information to reports
  • Create crosstab reports
  • Complex crosstab report creation
  • Work with crosstab data
  • How to create discontinuous crosstab reports
  • Visualization report creation
  • How to use filter and prompts
  • Use calculations
  • How to customize reports using conditional formatting
  • Drill-through definitions
  • How to enhance report layouts

�

While class exercises are performed within a Cognos Analytics v11.1 environment, our expert instructors can provide guidance on previous Cognos versions and their differences.

What is IBM Cognos Analytics Reporting?

  • The Welcome page
  • Consume report content
  • Interactive filtering
  • Working with reports

�

Dimensionally modeled relational data

�

Use personal data sources and data modules

  • Upload personal data
  • Upload custom images
  • Using navigation paths in a data module

�

Examine list reports

  • Group data
  • Format columns
  • Include headers and footers

�

Aggregate fact data

  • Identify differences in aggregation

�

Multiple facts and repeated information

  • Use shared dimensions to create multi-fact queries
  • Present repeated information

�

Add repeated information to reports

  • Create a mailing list report

�

Create crosstab reports

  • Add measures to a crosstab
  • Data sources for a crosstab

�

Create complex crosstab reports

  • Add items as peers
  • Create crosstab nodes and crosstab members

�

Work with crosstab data

  • Format, sort, and aggregate a crosstab

�

Create discontinuous crosstab reports

�

Create visualization reports

  • Visualization categories
  • Customize visualizations
  • Client side visualizations
  • Enhanced map visualizations

�

Focus reports using filters

  • Create filters to narrow the focus
  • Use advanced detail filters
  • Apply a filter with aggregation
  • Use summary filters

�

Focus reports using prompts

  • Examine parameters and prompts
  • Create a parameter for a report item
  • Add a prompt page
  • Add a prompt item to a report
  • Identify a prompt type
  • Create a cascading prompt

�

Using calculations

  • What are calculations?
  • Add Date and Time functions
  • Add string functions
  • Display prompt selections in report titles

�

Customize reports with conditional formatting

  • Three steps for conditional formatting
  • Create a variable
  • Assign the variable to a report object
  • Format based on the conditional value
  • Conditionally render report objects

�

Drill-through definitions

  • Navigate to related data

�

Enhance report layouts

  • View the structure of a report
  • Use Guided report layout
  • Force page breaks
  • Create horizontal pagination
  • Modify the report structure
  • Format objects across reports

�

Additional report-building techniques

  • Enhance a report design
  • Add objects to reports
  • Convert a list to a crosstab
  • Explore reuse