Introduction to Reporting Against a Relational Data Source

Introduction to Reporting Against a Relational Data Source

Audience

Users who are required to develop Business reports within IBM Cognos Analytics Reporting, against a relational data source.

Prerequisites

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

Duration

2 days.

Course Objectives

  • An Introduction to Business Intelligence/Analytics
  • Introduction to the Cognos Analytics (Cognos 11)
  • An overview of the Reporting interface is provided
  • 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 and chart reports
Creating drill-through reports and using cascading prompts
Discussions and overview/introduction to more complex tools within the reporting interface
Working to report specifications
Course Review and Feedback

Virtual Courses

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

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...