IBM Cognos Analytics Training Courses

Self-service business intelligence with Cognos Analytics

IBM Cognos Analytics provides a powerful personal analytics experience, driven by AI. It’s built to help you find and share compelling stories that lie hidden in your data. Unlike analytics solutions that only show what’s happening across your business, IBM Cognos Analytics goes further, using AI to get to why it happened.  These game-changing insights enable businesses to respond efficiently to rapidly evolving business needs.

Our IBM certified trainers have years of experience and you will leave our courses confident and prepared. 

  • IBM Cognos Analytics - Reporting - Basics

    One Day Course

    £1250 for 1-3 delegates 

    £1550 for 3-6 delegates

    This course provides atttendees with the knowledge to start building their own reports in Cognos Analytics through practical hands on workshops.

    The workshops use our MegaBeatz model with data from the music industry that can be easily understood by a broad audience.  The course is full of best practice tips and Business Intelligence concepts.

    The aim of the course is for attendees to develop an understanding of Business Intelligence and reporting concepts and to come away with the skills required to analyse data, create reports and present data.

    1:  IBM Cognos Analytics - Getting Started

    • IBM Analytics architecture overview
    • IBM Cognos Analytics components
    • Legacy version comparison
    • How to access Reporting
    • Examine the interface
    • Run an existing report
    • Edit an existing report
    • Exploring interactivity mode
    • Create a new report
    • Templates and themes

     

    2:  Data Source Structures

    • Relational reporting structures
    • Dimensional reporting structures
    1. Dimensions
    2. Members and Hierarchies
    3. Levels
    4. Properties
    5. Cubes

     

    3:  Reporting Authoring Basics

    • Adding dimensional objects to a crosstab
    • Drill up / drill down / expand / collapse
    • Adding a total
    • Different crosstab layouts
    1. Nesting
    2. Stacking
    3. Asymmetric
    • Zero suppression
    • Default members
    • Page layers
    • Filtering and slicing
    • Sets
    • Create a top 10 report
    • Calculations
    • Tuples

     

    4:  Charts and Visualisations

    • Create a simple visualisation
    • Convert to a different visualisation
    • Suppressing chart axes
    • Customising the chart properties
    • Maps
    • Baselines and annotations
    • Adding a secondary axis
    • Selecting a palette
    • Customising the palette to a specific RGB colour
    • Background effects
    • Showing / hiding values

     

    5:  Improve the Report Presentation

    • Templates and themes
    • Copying content between reports
    • Extending rows per page
    • Resizing objects

     

    6:  Sharing Reports

    • Exporting to different formats
    • Running reports from the portal
    • Scheduling reports

     

     

  • IBM Cognos Analytics - Reporting - Advanced

    Two Day Course

    £3750 for 1-3 delegates 

    £3100 for 3-6 delegates

    Course Overview

    From building a multi-query report to bursting out reports by email, this course provides the skills and knowledge required for users to build and edit dynamic professional reports through practical hands on workshops. The workshops use our Megabeatz Model with Music Industry data that is easily understood by a broad audience laced with best practice tips and Business Intelligence concepts.

    The aim of the course is for attendees to develop an understanding of Queries, Prompts, Drilling and Advanced report functionality, in addition to an understanding of Dimensional and Dynamic time functions.  You will come away with the skills required to create and edit Professional Reports.

    1:  Queries

    • Queries overview
    • Building a multi-query report

     

    2:  Prompt Pages

    • Build a prompt page
    • Value prompts (from the data source)
    • Value prompts (from static values)
    • Inline prompts
    • Tree prompts
    • Creating a parameter in a slice
    • Layout calculations
    • Adapting prompt properties
    • Auto submit
    • Prompt header text
    • Variables and conditional blocks
    • Default selections

     

    3:  Drill Through Reports

    • Source vs target report
    • Creating drill through access
    • Applying drill through settings

     

    4:  Advanced Report Design

    • Sectioning
    • Conditional formatting
    • Master-detail relationships
    • Table of contents
    • Bursting reports
    • Running a burst report to email
    • Running a burst report and saving the output in the web
    • Checking the status of a running report

     

    5:  Dimensional Functions

    • Children
    • Descendants
    • Filter
    • Complex nested expressions
    • Dimensional function wizard
    • Exclude
    • Rank
    • If statements
    • Case statements
    • RAG icons / conditional images
    • Adding your own images / logos

     

    6:  Functions for Dynamic Time

    • Adding a prompted period
    • Ancestor (full year)
    • ParallelPeriod (last year)
    • PrevMember (prior period)
    • Lag (X periods ago)
    • PeriodsToDate (YTD)
    • Total currentMeasure within set (YTD Total)
    • LastPeriods (last x months, rolling x months)
    • Creating a dynamic current month

     

    7:  Advanced Techniques

    • Macro Prompts
    • Create your own template
    • Layout component references
    • Advanced conditional formatting

     

  • IBM Cognos Analytics – Relational Reporting

    Two Day Course

    £1250 for 1-3 delegates 

    £1550 for 3-6 delegates

    Course Overview

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

    • 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.
  • IBM Cognos Analytics – Relational and Dimensional

    Three Day Course

    £1250 for 1-3 delegates 

    £1550 for 3-6 delegates

    Course Overview

    • To provide an Introduction to Business Intelligence/Analytics.
    • To be able to describe how the various Cognos Analytical tools can be used against a typical BI requirement, overviews on Dashboards, Data Modules and Stories
    • To provide an overview of Reporting within Cognos Analytics
    • To develop a range of skills within Reporting that will enable the user to create/author reports, initially against a relational data source then more in-depth authoring against a cube/dimensional data.

     

    Course Outline

    • Discuss and provide an overview of Business Analytics
    • Overview of Cognos Analytics, covering the Connection Portal, general navigation and understanding of the interface and features available within the analytics tool, an overview of Framework Manager is also provided.
    • Introduction to the Reporting interface and overview of workshops.
    • Understanding the differences between Relational/Dimensional techniques, creation of sql/mdx
    • Utilising and discussing various methods that can be used whilst building your reports.
    • Creation of basic reports, introduction to lists, crosstabs and charts within Reporting.
    • Setting up Drill-through reports and building reports from queries and using repeaters
    • Using insertable objects in your report and usage of various tools from within the toolbox. Creation of calculations and review of aggregation methods
    • Grouping and sorting your data.
    • Dimensional Terminology and setting up the report context, filtering using dimensional techniques, including slicers and tuples
    • Utilising dimensional functions to assist with report development against a dimensional data source.
    • Creating hard coded and parameterised filters and the creation of prompts and prompt pages
    • Setting up variables, general formatting and conditional formatting.
    • Understanding hierarchies and drill down/up options, general navigation and intro to macro prompts
    • Overview of creating report templates and creating reports based on a specification
    • Course Review and Feedback, including recap and Q/A session