Audience
This course is perfect for all those requiring an introduction to reporting with IBM's Cognos Business Intelligence
NOTE: The course can be run for either version 8 or 10, please specify when booking.
Prerequisites
There are no prerequisites for this course.
Duration
2 days. Hands on.
This course is available on site only. Please call for details.
Course Objectives
This course is designed to provide delegates with a basic overview of the key concepts required to build and use reports in IBM Cognos Business Intelligence. It covers the use of Cognos Connection for report management and access, the building of basic and intermediate reports in Report Studio and Query Studio, and a number of key techniques for creating professional reports for distribution to business users.
Course Content
Introduction to Cognos Connection
What is Cognos Connection?
Accessing Reports.
Managing Report Distribution.
Scheduling Reports.
Query Studio Basics
The Query Studio Interface.
Creating Ad Hoc Reports.
Lists and Crosstabs.
Using Charts.
Report Studio Introduction
The Report Studio Interface.
Report Types.
Adding Objects to Reports.
Viewing the results.
Properties and Layouts.
Creating List and Crosstab Reports
Understanding List Reports.
Creating Crosstabs.
Data Sets and Measures.
More Complex Data Layouts.
Grouping and Sorting.
Formatting Options.
Using Graphs
Creating a Chart Report.
Chart Types.
Formatting Charts.
Prompts and Filters
Setting up Parameters.
Using Prompts.
Prompt Types.
Prompt Pages.
Cascading Prompts.
Filtering Data.
Conditional Formatting
Changing displays based on Conditions.
Defining the conditions.
Highlighting Exceptions.
Conditional Formatting.
Report Design and Layout
Effective Report Design.
Using Tables.
Spacing Objects with Blocks.
Adding text and expressions.
Adding Pages, Headers and Footers.
Drill Through Reports.
Advanced Techniques
Calculations and Functions.
Bursting Reports.
Advanced Formatting.
Layouts and Templates.
Handling Queries.