IBM Cognos Business Intelligence Courses

BSG Training - delivering ICT Training Solutions for you

This course has been designed to give maximum learning and development capabilities to Developers who are responsible for designing and maintaining metadata models in Framework Manager. This two-day course will enable trainees to get hands-on using a pre-defined database to learn how to connect and create packages ready for end user reporting and analysis. Throughout the course you will learn the design tools, techniques and security of modelling metadata from initial requirement gathering to publishing a package to the Web.

• Overview of the IBM Cognos component structure
• Examine and discuss operational and reporting databases
• Examine relational and dimensional data sources

• Import data and additional metadata
• Explore the Framework Manager interface
• Recognise Facts and Dimensions and change data types

• Define relationships between Query subjects
• Understand cardinality

• Merge query subjects
• Hide, rename and move objects
• Add calculations
• Auto layout and launch Content Explorer
• Create a Reporting Layer Namespace

• Create stand alone and embedded filters to a model
• Add a parameterised filter to a model
 

• Create a dimensional layer
• Use DMR to create Regular and Measure Dimensions
• Define members and unique names
• Identify changes that impact a MUN

• Add package security
• Add object security
• Add data security

• Define package contents
• Analyse Publish impact
• Vendor specific functions

BSG Training - delivering ICT Training Solutions for you

This course has been designed to give maximum learning and development capabilities to Professional Report Authors of IBM Cognos Query and Analysis Studio 10.2.1. This one-day course is based on a pre-defined data package enabling trainees to learn report building techniques using relational and dimensional models. Trainees will work through hands-on demos and exercises in both studios to gain understanding of techniques for enhancing, customising and managing reports.

Prerequisites: An understanding of your business requirements.

• Introduction to IBM Cognos component structure
• IBM Cognos Connection
• Personalise your portal
• IBM Cognos Query Studio
• IBM Cognos Analysis Studio
• IBM Cognos for Office
• IBM Cognos CAFE

BSG Training - delivering ICT Training Solutions for you

This course has been designed to give maximum learning and development capabilities to Professional Report Authors of IBM Cognos Query, Analysis and Report Studio 10.2.1. This three-day course is based on a pre-defined data package enabling trainees to learn report building techniques using relational and dimensional models. Trainees will work through hands-on demos and exercises in all studios to gain understanding of techniques for enhancing, customising and managing reports, charts and dashboards. The course will also introduce trainees to IBM Cognos Insight.

• Introduction to IBM Cognos component structure
• IBM Cognos Connection
• Personalise your portal
• Introduction to IBM Cognos Query Studio
• Introduction to IBM Cognos Analysis Studio
• IBM Cognos for Office
• IBM Cognos CAFÉ
• Introduction to IBM Cognos Insight IBM Cognos Report Studio
• Examine the Report Studio interface
• Examine a pre-built report
• Build List & Crosstab Reports using Relational Data
• Create Charts & Visualizations
• Filter Data
• Build Calculations
• Improve your report presentation
• Build Crosstab Reports using Dimensional Data
• Dimensional Functions
• Mobile Analytics using Active Reports
• External Data
• IBM Cognos Workspace
• IBM Cognos Workspace Advanced

BSG Training - delivering ICT Training Solutions for you

This course has been designed to give maximum learning and development capabilities to Professional Report Authors of Multi-Dimensional Data using Report Studio 10.2.1. This two-day course is based on a pre-defined data package enabling trainees to build on their experience of report building techniques using dimensional datasets. Trainees will work through hands-on demos and exercises to gain understanding of authoring reports using dimensional data structures using the dimensional techniques and functions of Report Studio.

• Introduction to IBM Cognos component structure.
• IBM Cognos Report Studio
• Dimensional data package contents
• Examine Dimensional & Relational Packages
• Define Sets and use Members in reports
• Create Crosstab reports
• Understand drop zones in a Crosstab
• Context of Dimensional data in reports
• Dimensional data and prompting
• Focus data in a report using various functions
• Focus data in a report using a Slicer
• Filter the report using a tree prompt
• Advanced report techniques
• Understand Master-Detail Relationships
• Dividing a report into sections
• Create page layers with context filters
• Functions and Calculations
• Navigate hierarchies using functions
• Drill-through reports
• Understand time-based functions

BSG Training - delivering ICT Training Solutions for you

This course has been designed to give maximum learning and development capabilities to Professional Report Authors of IBM Cognos Report Studio Active Reports 10.2.1. This advanced two-day course will enable trainees to get hands-on using a pre-defined data package to build highly interactive reports that can be consumed on mobile devices, iPad and tablets. Throughout the two days you will learn the design tools and techniques to create and connect manually and automatically to controls such as, Data Button Bars and Decks. Learn the difference between Filter and Selection methods, and Master-Detail relationships with charts and multiple tabs to change how data is displayed.

Prerequisites: An understanding of your business requirements.

• Introduction to IBM Cognos Active Reports
• Understand the purpose of Active Reports
• Examine an existing report
• Convert existing report to an Active Report
• Learn about the various types of Static and Dynamic
controls available
• Build a basic report
• Understand why renaming objects and reusing queries improves performance
• Create Connections using Filter and Select
• Learn about the various types of Controls available
• Create Report Variables to link Controls to Report Objects
• Create connections automatically and manually
• Amend Interactive Behaviour and Variables
• Convert Controls
• Use Decks to create a multi-page Active Report
• Use Data Decks
• Understand Master - Detail relationships with Charts
• Understand how to enable a Control based on
another
• Toggle Conditional Formatting to highlight exceptional data
• Build stunning dashboards using multiple controls and objects
• Set Default Values for Active Report Variables
• Run and Download an Active Report offline

• Create cascading prompts
• Use Visualizations to present data graphically
• Learn how to access and download new Visualisations
• Add animations and dynamic sorting
• Interact with images to select/filter areas of a report
• Understand how to use Images, Blocks and Tables
• Dashboard Style Presentation
• Explode Chart Slices dynamically
• Build Active Reports for Mobile devices
• Drill down reports
• Considerations when designing for iPad
• Do's and Don'ts
• Tips and trick such as Creating Scrolling Marquees

BSG Training - delivering ICT Training Solutions for you

This course has been designed to give maximum learning and development capabilities to Business Authors of Workspace Advanced 10.2.1. This intensive one-day course is based on a pre-defined data package enabling trainees to develop their skills of report building techniques using relational and dimensional datasets. Trainees will work through hands-on demos and exercises to gain understanding of design techniques for authoring reports with IBM Cognos Workspace Advanced.

• Introduction to IBM Cognos component structure.

• Build report using relational data sources
• Build a list report
• Add calculations and summaries
• Group and sort data

• Explore drill through on a hierarchy
• Filter dimensional data
• Define and analyse sets of data

• Context filters
• Prompt filters
• Create page layers
• Sorting data
• Aggregated values

• Ancestor button
• Conditionally formatted data
• Create charts and visualisations

• When to use external data
• External data considerations

• Overview
• Build a dashboard
• Display widgets
• Charts
• Prompts

BSG Training - delivering ICT Training Solutions for you

This course has been designed to give maximum learning and development capabilities to Professional users of IBM Cognos Cube Designer (V10.2.2). It provides delegates with introductory to advanced knowledge of how to model metadata for predictable reporting and analysis results using IBM Cognos Cube Designer. Delegates will learn the full scope of the metadata modeling process, from initial project creation, to publishing dynamic cubes, and enabling end users to easily author reports and analyze data.

Prerequisites: Knowledge of dimensional modeling and design. Experience using IBM Cognos Connection and Administration

• Introduction to IBM Cognos Dynamic Cubes
• Define and Differentiate Dynamic Cubes
• Identify the Challenges of Very Large Data and how Dynamic Cubes resolves those issues
• Examine dynamic cube characteristics
• Examine dynamic cube requirements
• Examine high-level architecture
• IBM Cognos Dynamic Query
• Review Dimensional Data Structures
• Describe the dynamic cube process flow and lifecycle
• Examine how dynamic cubes use caching
• Create and Design a Dynamic Cube
• Explore the IBM Cognos Cube Designer
• Review the cube development process
• Examine the automatic cube generator
• The Manual Development Process
• Examine Modelling Strategies
• Deploy and Configure a Dynamic Cube
• Deploy and publish a dynamic cube
• Use the Hardware Sizing Wizard
• Configuration and management of a published cube
• Assign an Access Account
• Examine query service administration tasks
• Explore dynamic cube properties
• Configure a dynamic cube to trigger a report
• Run Administrative Commands with the DCAdmin Command Line Tool
• Advanced Dynamic Cube Modelling
• Identify advanced modelling techniques and caveats
• Examine calculated members and measures
• Model a relative time dimension
• Explore Custom Relative Time
• Explore the Current Period Property
• Define Period Aggregation Rules for Measures
• Create and Use Named Sets
• Examine the Shared Dimension Property 
• Advanced Features of Cube Designer
• Examine Multilingual Support
• Define Parent-Child Dimensions (ragged hierarchies)
• Refresh Metadata in an Existing Cube
• Import Framework Manager packages into Cube Designer
• Filter measures and dimensions
• Optimize Performance with Aggregates
• Examine aggregation in dynamic cubes
• Identify types of aggregates (database and in-memory)
• Examine user-defined, in-memory aggregates
• Use Aggregate Advisor to identify aggregates
• Use Automatic In-Memory Aggregate Optimization
• Allocate memory for cache and aggregates
• Explore the aggregate workflow
• Explore the aggregate advisor
• Use Slicers
• Define Security
• Overview of dynamic cube security
• Types of Security
• Add animations and dynamic sorting
• Examine Security Scope
• Identify roles and capability requirements
• Define Security Using Relational Database Tables
• Use security filters to define hierarchy security views
• Assign users and groups to security views
• Model a Virtual Cube
• Examine the benefits, requirements, and build process of virtual cubes
• Explore virtual cube objects: dimensions and hierarchies
• Examine virtual levels in merged hierarchies
• Explore Currency Conversion Using a Virtual Cube
• Apply security to virtual cubes
• Publish a virtual cube