About this course:
 

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the SAS.
 

Course Syllabus:

This 5 day course will give delegates a thorough study on using Cognos BI.

Day 1

Overview of IBM Cognos BI.

• Discuss IBM Cognos BI and Performance Management
• Describe IBM Cognos BI components
• Describe IBM Cognos BI architecture at a high level
• Define IBM Cognos BI groups and roles
• Explain how to extend IBM Cognos BI

Introduction to the Reporting Application

• Examine Report Studio and its interface
• Explore different report types
• Create a simple, sorted, and formatted report
• Explore how data items are added to queries

Create List Reports

• Format, group, and sort list reports
• Describe options for aggregating data
• Create a multi-fact query
• Create a report with repeated data

Focus Reports Using Filters

• Create filters to narrow the focus of reports
• Examine detail and summary filters
• Determine when to apply filters on aggregate data

Day 2

Create Crosstab Reports

• Format and sort crosstab reports
• Convert a list to a crosstab
• Create complex crosstabs using drag and drop functionality
• Create crosstabs using unrelated data items

Present Data Graphically

• Create charts containing peer and nested items
• Add context to charts
• Create and reuse custom chart palettes
• Present key data in a single dashboard report

Focus Reports Using Prompts

• Identify various prompt types
• Use parameters and prompts to focus data
• Search for prompt items
• Customize prompts to facilitate users’ choices
• Navigate between pages
• Display users’ prompt selections in the report

Extend Reports Using Calculations

• Create calculations based on data in the data source
• Add run-time information to the reports
• Create expressions using functions

Day 3

Customize Reports with Conditional Formatting

• Create multi-lingual reports
• Highlight exceptional data
• Show and hide data
• Conditionally render objects in reports

Drill-Through From One Report to Another

• Let users navigate from a specific report to a target report
• Pass parameter values to filter the data in drill-through targets

Identify Common Data Structures

• Define the metadata modeling role in IBM Cognos BI
• Identify a transactional data structure
• Distinguish between normalized and de-normalized data
• Identify a star schema data structure
• Identify common reporting traps (overview then detail slides)
• Define OLAP data structures
• Decide on the appropriate data access strategy

Gather Requirements

• Modeling recommendations overview
• Analyze BI and data requirements
• Interview and view samples
• Identify required business areas
• Work in stages (use a phased approach to importing and modeling)

Day 4

Create a Baseline Project

• What is Framework Manager?
• Define an FM project and its high level objects (namespace, data sources, packages, etc.)
• Query Subject Types (data source, model, and stored procedure)
• Define Query items.
• Examine the model in Cognos BI (what do authors see)

Prepare Reusable Metadata

• Verify and Modify Query Item Properties
• Verify Query Subject Relationships
• Ensure efficient filters by configuring prompt properties

Model for Predictable Results: Identify Reporting Issues

• Describe multi-fact queries and when full outer joins are appropriate
• Describe how IBM Cognos uses cardinality
• Identify reporting traps
• Use tools to analyze the model

Model for Predictable Results: Virtual Star Schemas

• Identify the advantages of modeling metadata as a star schema
• Model in layers
• Create aliases to avoid ambiguous joins
• Merge query subjects to create as view behavior

Model for Predictable Results: Consolidate Metadata

• Create virtual facts to simplify writing queries
• Create virtual dimensions to resolve fact-to-fact joins
• Create a consolidated modeling layer for presentation purposes
• Consolidate snowflake dimensions with model query subjects
• Simplify facts by hiding unnecessary codes

Calculations and Filters

• Use calculations to create commonly-needed query items for authors
• Use static filters to reduce the data returned
• Use macros and parameters in calculations and filters to dynamically control the data returned

Implement a Time Dimension

• Make time-based queries simple to author by implementing a time dimension
• Resolve confusion caused by multiple relationships between a time dimension and another table
• Specify Determinants
• Use determinants to specify multiple levels of granularity and prevent double-counting

Create the Presentation View

• Identify the dimensions associated with a fact table
• Identify conformed vs. non-conformed dimensions
• Create star schema groupings to provide authors with logical groupings of query subjects
• Rapidly create a model using the Model Design Accelerator

Work with Different Query Subject Types

• Identify key differences and make recommendations for using data source, model, and stored procedure query subjects
• Identify the effects on generated SQL when modifying query subjects, SQL settings and relationships

Set Security in Framework Manager

• Examine the IBM Cognos security environment
• Restrict access to packages
• Create and apply security filters
• Restrict access to objects in the model

Day 5

Identify IBM Cognos BI Architecture

• The features of the IBM Cognos BI architecture
• The three architectural tiers
• IBM Cognos BI servlets and services
• The default servlet container and alternatives to its use
• An example of IBM Cognos BI request processing
• Installation options
• Load balancing mechanisms
• Configuration options
• The IBM Cognos Application Firewall

Manage Content in IBM Cognos Administration

• Add a data source
• Distribute data and create a distribution list
• Plan a deployment
• Create deployment folders
• Export and import entries
• Identify how to maintain the IBM Cognos BI content store
• Configure saving content to the file system
• Customize the appearance of IBM Cognos BI using styles
• Use portlets to display custom Web content

Secure the IBM Cognos BI Environment

• Identify the IBM Cognos BI security model
• Define authentication in IBM Cognos BI
• Define authorization in IBM Cognos BI
• Identify security policies
• Secure the IBM Cognos BI environment

Our international certified trainers have highly experienced Cognos BI practitioners who have real-world expertise.

I – Laptops will be provided for all candidates with pre-installed Cognos.

II – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of a place on the course).

For more information on our training, please enquire using the form above or call +2348103382376