COGNOS BI

• Introduce Cognos 10 BI
• Examine the different studios in Cognos 10 BI
• Identify the different data sources within the studios

Cognos 10 Installation and Configuration

• Components used by Cognos 10
• Server Components
• Modeling Components
• Installing Cognos 10
• Uninstalling Cognos 10

New features in Cognos 10 BI

• Business Insight
• Business Insight Advanced
• Active Reports
• Manage External Data
• Statistical reports

Cognos 10 Connection

• Examine Cognos Connection
• Run and view reports
• View the run history of a report
• Organize content with folders and shortcuts
• Customize report outputs by using report views
• Schedule single and multiple reports
• Personalize Cognos Connection

Query Studio

Introduction to Query Studio

• List the packages available for reporting
• Understand report types
• Add and save data to ad hoc reports
• View data by using charts

Create Reports in Query Studio

• Create list, grouped list, and crosstab reports
• List the charts available and their appropriate use
• Calculate and sort report data
• Define a custom group to create your own report
• Use shared dimensions to create multi-fact queries

Enhance Reports in Query Studio

• Highlight report items using conditional styles
• Focus the scope of a report using filters
• Format report objects
• Apply a report template

Report Studio

• Introduction to the Reporting Application
• discuss different modes of reporting
• 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

• group, format, 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

Create Crosstab Reports

• format and sort crosstab reports
• create complex crosstabs using drag and drop functionality
• create crosstabs using unrelated data items

Present Data Graphically

• create charts containing peer and nested columns
• present data using new chart type options
• add context to charts
• 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 types
• navigate between pages

Extend Reports Using Calculations

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

Design Effective Reports

• enhance report design with report objects
• reuse objects within the same report
• share layout components among separate reports

Customize Reports with Conditional Formatting

• create multi-lingual reports
• highlight exceptional data
• show and hide data
• conditionally render objects in reports
• conditionally format one crosstab measure based on another

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
• navigate through multiple reports

Drill-through Definitions

• discuss parameter-driven drill through
• discuss dynamic drill through
• set up package-based drill-through definitions
• set scope
• use the Drill Through Assistant

Manage Content in IBM Cognos Connection

• schedule and manage reports
• view lineage information
• organize content
• examine IBM Cognos Connection personal preferences
• set alerts and watch rules
• design a portal page and dashboard
• set permissions using IBM Cognos 10 BIgroups and roles

Examine the Report Specification

• examine the report specification structure
• save and edit reports locally
• discuss considerations for modifying a report specification

Create Query Models

• build query models and then connect them to the report layout
• add filters and prompts to a report using the query model
• edit an SQL statement to author custom queries

Create Reports Based on Query Relationships

• create reports by merging query results
• create reports by joining queries
• combine data containers based on relationships from different queries

Distribute Reports Through Bursting

• distribute reports using bursting
• create burst keys
• identify report recipients and data items using burst tables
• distribute reports using email and IBM Cognos Connection

Create Advanced Dynamic Reports

• filter reports on session parameter values
• navigate a briefing book using a table of contents
• create dynamic headers and title that reflect report data
• let users navigate to specific locations in reports
• create a customer invoice report

Design Effective Prompts

• control report displays using prompts
• specify conditional formatting values using prompts
• create a report that formats based on prompts selection
• create a sorted and filtered report based on prompt selection

Create Additional Advanced Reports

• create a report that displays summarized data before detailed data
• highlight alternate rows in a list report

Analysis Studio

• Analysis Studio Fundamentals
• Define the fundamental terms of Analysis Studio
• Explain how to insert objects
• Define and create sets
• Identify the work area, overview area, and properties pane

Tools for Investigation in Analysis Studio

• Employ drilling down and up to different levels of detail
• Apply changes to rows, columns, and measures in the analysis
• Explain how to change the display of data
• Use charts to display data graphically

Nest Data in Crosstabs in Analysis Studio

• Apply depth to rows and columns by nesting data
• Recognize drill behavior in nested rows and columns
• Demonstrate how to swap nested levels

Build Advanced Crosstabs in Analysis Studio

• Demonstrate how to view a complete level of data
• Design a crosstab without retrieving data
• Compare multiple measures
• Apply stacked sets to the crosstab
• Construct an asymmetrical crosstab
• Compose a custom sort

Focus with Filters in Analysis Studio

• Apply filters using expressions
• Apply filters using the Context area
• Create top and bottom lists
• Use several techniques to remove rows and columns

Framework Manage (Metadata Modeling)

• Introduction to Framework Manager
• Framework Manager Basics
• User Interface, Navigation, Objects
• Designing Project
• Create project
• Importing Metadata
• Exporting Metadata
• Create Model Documentation
• Data Sources
• Working with Data Source Connections
• Create and Modify Data Sources
• Improve Performance by setting Query Processing Type
• Preparing Relational Metadata for use in Reports
• Verifying Relationships
• Working with Dimensions
• Working with Query Subjects
• Working with Query Items
• Supporting Multilingual Metadata
• Adding Business Rules
• Organizing the Model
• Making Metadata Available to Report Authors
• Verify Model
• Set Governors
• Improving Performance
• Create or Modify Package
• Controlling access to Metadata
• Explore Package
• Publish Package
• Guideline for Modeling Metadata
• Scenarios
• New Objects - Regular Dimensions, Measure Dimensions, Scope Relationship
• Dimensional Modeling of Relational Data Sources.