Essentials for IBM Cognos BI (V10.1) - ILO

Course Description

NOTE THAT FOR THIS COURSE, YOU DO NOT NEED TO TRAVEL AS THIS IS A VIRTUAL CLASSROOM.

IBM Cognos Education is now pleased to offer you our courses in an exciting new learning format, Instructor-led Online (ILO). You are offered a similar experience to live classroom training, with the convenience of having it delivered directly to your desktop.

Essentials for IBM Cognos BI (V10.1) is a blended offering consisting of five-days of instructor-led online training (ILO) and 21 hours of Web-based self-paced training. This accelerated offering is intended for core project team members wishing to acquire a broad understanding of a Business Intelligence platform implementation. During the ILT, you will perform hands-on demos and workshops that cover three essential topic areas: Report Authoring, Modeling, and Administration of a BI platform. Throughout the ILT, you will be guided to more-in depth training offerings and paths leading to certification.

Skills Gained

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 t 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 t queries
• Create a Simple Active Report Using Static and Data Controls

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 t narrow the focus of reports
• Examine detail and summary filters
• Determine when t apply filters on aggregate data

Create Crosstab Reports

• Format and sort crosstab reports
• Convert a list t 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 t 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 t focus data
• Search for prompt items
• Customize prompts t 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 t the reports
• Create expressions using functions

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

• Let users navigate from a specific report t a target report
• Pass parameter values t 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 t importing and modeling)

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 d 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 t 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 t avoid ambiguous joins
• merge query subjects t create as view behavior

Model for Predictable Results: Consolidate Metadata

• create virtual facts t simplify writing queries
• create virtual dimensions t 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 t create commonly-needed query items for authors
• use static filters t reduce the data returned
• use macros and parameters in calculations and filters t dynamically control the data returned

Implement a Time Dimension

• make time-based queries simple t author by implementing a time dimension
• resolve confusion caused by multiple relationships between a time dimension and another table

Specify Determinants

• Use determinants t 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 t 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 t packages
• Create and apply security filters
• Restrict access t objects in the model

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 t 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 t maintain the IBM Cognos BI content store
• configure saving content t the file system
• customize the appearance of IBM Cognos BI using styles
• use portlets t display custom Web content

Manage Run Activities

• Manage current, upcoming and past activities
• Manage schedules

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
• Set Security in Framework Manager

Post class e-Learning:

• IBM Cognos for Microsoft Office: Integrate with Microsoft Office (V10.1) - Web-Based Training (2 hrs.)
• IBM Cognos BI Event Studio: Create and Manage Agents (V10.1) - Web-Based Training (2 hrs)
• IBM Cognos Transformer: Create PowerCubes (V10.1) - Recording (1 hr)
• IBM Cognos Business Insight Advanced: Introduction (V10.1) - Web-Based Training (6 hrs)
• IBM Cognos Business Insight Advanced: Intermediate (V10.1) - Web-Based Training (5 hrs)
• IBM Cognos BI for Consumers (V10.1) - Web-Based Training (2 hrs)
• IBM Cognos Business Insight Create Dashboards (V10.1) - Web-Based Traininge (3 hrs)

Who Can Benefit

This intermediate course is for Project Managers, Technical Analysts, and Developers.

Prerequisites

Required Prerequisites:

• Experience using the Windows operating system
• Experience using a web browser

Recommended Prerequisites:

• Knowledge of your business requirements
• Recent completion of IBM Cognos BI for Consumers (V10.1) WBT or an equivalent
• Technical competency in at least one of three areas: Report Writing, Modeling, and/ or Administration of a Business Intelligence platform