Report Studio:  Fundamentals - Course Outline

Overview of IBM Cognos

  • Discuss IBM Cognos and Performance Management

  • Describe IBM Cognos components

  • Describe IBM Cognos architecture at a high level

  • Define IBM Cognos groups and roles

 

Introduction to the Reporting Application

  • Examine Report Studio and its interface

  • Explore different report types

  • Create a simple, sorted, and formatted report

  • Explore how data items are added to queries

 

Create List Reports

  • Format, group, and sort list reports

  • Describe options for aggregating data

  • Create a multi-fact query

  • Create a report with repeated data

 

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

 

Create Crosstab Reports

  • Format and sort crosstab reports

  • Convert a list to a crosstab

  • Create complex crosstabs using drag and drop functionality

  • Create crosstabs using unrelated data items

 

Present Data Graphically

  • Create charts containing peer and nested items

  • Add context to charts

  • Create and reuse custom chart palettes

  • Present key data in a single dashboard report

 

Focus Reports Using Prompts

  • Identify various prompt types

  • Use parameters and prompts to focus data

  • Search for prompt items

  • Customize prompts to facilitate users' choices

  • Navigate between pages

  • Display users' prompt selections in the report

 

Extend Reports Using Calculations

  • Create calculations based on data in the data source

  • Add run-time information to the reports

  • Create expressions using functions

 

Present Data Using Maps

  • Present data using map reports

  • Navigate to another level within a map

 

Analyze Data Using Statistical Reports

  • Discuss statistical report types

  • Examine descriptive statistics

  • Explore statistical charts

 

Use Additional Report Building Techniques

  • Reuse objects within the same report

  • Share layout components among separate reports

  • Discuss report templates

  • Add pages to a report

  • Choose options to handle reports with no available data

 

Customize Reports with Conditional Formatting

  • Highlight exceptional data

  • Show and hide data

  • Conditionally render objects in reports

 

Drill-Through From One Report to Another

  • Let users navigate from a specific report to a target report

  • Pass parameter values to filter the data in drill-through targets

 

Drill-through Definitions

  • Enable users to navigate to related data in IBM Cognos BI

  • Parameter-driven drill through vs. dynamic drill through

  • Steps to enable drill-through access for a package

  • Limit the items that users ca drill through from (set scope)

  • Set a measure as the scope

  • Drill Through Assistant

 

Enhance Report Layout

  • Force page breaks in reports

  • Modify existing report structures

  • Apply horizontal formatting

  • Specify print options for PDF reports

  • Combine data containers displaying data from different queries

  • Format data and report objects

Custom and Standard TRAINING

Instructor-led Onsite and Instructor-led Online

CONSULTING
MENTORING

Onsite and Online

EMAIL

Cognos@LoneStarBI.com

PHONE

281-507-1615

© 2014 by LSBI  Houston, TX

created with Wix.com