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

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.

IBM Cognos