IBM Cognos Analytics 12.1

Modelling data is at the heart of all your analytics. Providing a user-friendly representation of your business data lets you create meaningful reports, dashboards, explorations and stories. 

In this 2 day hands-on course, you will master the steps you need to create a data module from start to finish, including:  

• Joins/Relationships 

• Enriching your data module with data cleaning, calculations, custom sorting, filters and folders. 

• Creating Data Groups and Navigation Paths 

• Adding relative dates 

• Creating Custom Tables and Tables using SQL 

• Setting up Column dependencies 

• Data module Relinking, Sharing and Security 

• Caching for Performance Optimisation 

• Build dynamic, interactive dashboards using drag-and-drop tools 

• Explore data relationships and uncover insights with AI-assisted visualisations 

• Craft compelling data stories that communicate findings clearly 

There is so much you can do with IBM Cognos Analytics report authoring! This industry-leading professional report authoring capability allows you to build pixel-perfect reports such as prompted reports, invoices,  multi-page briefing books, annual reports and more.  

In this 2 day hands-on workshop, we will cover:  

• An overview of the Cognos interface and the Report authoring capability 

• Creating a basic list report 

• Groups, totals, filters & formatting 

• Calculations 

• Prompt Pages 

• Report presentation 

• Queries, lists, visualisations & crosstabs 

• Report to report drill-through 

Building on the skills learnt in the Relational Reporting Workshop, this 2 day hands-on workshop will teach you how to create reports using multidimensional sources such as IBM Planning Analytics. Topics include:  

• Dimensional objects including hierarchies, levels, members, sets, and tuples 

• Building a multi-query report 

• Prompts 

• Variables and conditional blocks 

• Dimensional functions such as children, descendants, exclude, rank, etc. 

• If and Case statements

• RAG Icons and conditional images 

• Functions for dynamic time e.g. Prompted period, Ancestor etc.  

• Advanced techniques using macro prompts, layout component references and advanced conditional formatting. 

• Report design with page layers and context filters 

• Master-detail relationships 

• Creating a Table of Contents