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

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.

Report Authors and Business Analysts

You should have:

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

• 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