Introduction to Reporting against a Relational data source ( IBM Cognos Analytics )

Introduction to Reporting against a Relational data source ( IBM Cognos Analytics )


This course is for users who are required to develop Business reports within IBM Cognos Analytics Reporting, against a relational data source.


None, however background with using a web browser and ability to use laptops/PC’s and a mouse would be beneficial.


3 days. Hands on.

Course Objectives

This course covers content equivalent to IBM's IBM Cognos Analytics: Author Reports Fundamentals (v11.0.x) - B6158G course.

Course objectives include:

  • An Introduction to Business Intelligence/Analytics
  • An overview of Cognos Analytics (Cognos 11)
  • An overview of the Reporting interface
  • To develop authoring skills within the Reporting Interface to allow users to create reports
  • To obtain an overview of the Cognos portal, including Navigation and running reports

Course Content

Discuss and provide an overview of Business Analytics.

Overview of IBM Cognos Analytics, covering the user Portal, Dashboards, Data Modules and Stories.

Introduction to the Reporting interface and overview of workshops.

Creation of basic reports, introduction to lists, crosstabs and charts.

Utilising and discussing various methods that can be used whilst building your reports.

Creation of queries, sql overview and understanding queries.

Grouping and sorting your data.

Creating hard coded and parameterised filters.

Setting up variables and conditional formatting.

Utilising insert-able objects in your report and usage of various tools from within the toolbox.

Creation of query calculations.

Working with Comparison & Logical operators.

Creation of prompt pages and utilising various types of prompt, alignment of your report and formatting techniques.

Making use of functions and examples of how to aggregate and total your reports.

Creation of crosstab, visualizations and associated properties.

Creating drill-through reports and using cascading prompts.

Advanced formatting, report output options, working with headers/footers, advanced sorting and page breaks.

Understanding aggregation and more complex calculations and functions.

General presentation and making reports more effective.

Discussions and overview/introduction to more complex tools within the reporting interface.

Consolidation Workshops and if available working with customer data using report specifications.

Course Review and Feedback.

Virtual Courses

ALL of our courses can be delivered virtually! Our Bath public schedule courses are available as live virtual sessions, using the popular Zoom Virtual Classroom and remote labs. Delegates can test their access at:

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...