Cognos 10 Course Details

Cognos 10 Course Detailed Description

Whats new Cognos 10 BI
Overview of Business Intelligence
• What is Business Intelligence
• Why is BI Important and where can we use it
• Components of BI
• Business Intelligence Roadmap


Overview of Data Warehousing
• What is Data Warehouse, Why do we need it
• Data Warehouse Architecture and its components
• Define Star Schema - Fact and Dimensions
• Understand OLTP and OLAP Systems


Overview of Cognos 10 BI and Architecture
• Introduce Cognos 10 BI
• Whats new Cognos 10 BI
• Examine the different studios in Cognos 8 BI
• Identify the different data sources within the studios
• Highlight key cap abilities of Cognos 8 BI
• Understand Cognos Multi Layered architecture


Cognos 10 Installations and Configuration
• Installing Cognos 10
• Install Framework Manager
• Install Cognos BI Application
• Setting up the Environment
• Configuring Cognos 10
• Setting up Samples in Cognos 10
• Uninstalling Cognos 10


Cognos 10 BI Administration
• Create and Modify a Data Source
• Create Database backups
• Understand Roles, Users and Groups
• Specify Permission Settings


Cognos 10 Connection Administration
• What is Cognos Connection
• Examine Cognos Connection UI elements , Create a URL, Login, Logoff
• Entry Properties: General Properties, Permissions, Report, Query, Analysis, Job, Agent and Page Properties
• Navigation- Public and Private Folder
• Open reports with Report Name, Go to Links, Run Reports from a View
• Run Reports- Prompt Pages, Printing a report and Open in Excel
• View the run history of a report and Historical Reports
• Closing and Creating Quick links to Reports , My Folder Shortcut and Browser Bookmark
• Personalize Cognos Connection
• Backups- Export of Cognos, Content Store or select items for Backups
• Restore an exported Backup
• Create and Customize a Page and share a single page with Multiple Users


Cognos 10 Query Studio
• Introduction to Query Studio
• Create Reports (List, Grouped List, Crosstab, Charts)
• Changing the Appearance of Reports (Format)
• Sorting and Grouping
• Filters and Prompts
• Subtotals and Calculations
• Run and Manage Reports
• Drill Through reports


Cognos 10 Analysis Studio
• Introduction to Analysis Studio
• Creating a Basic Analysis
• Working with data in Crosstab
• Exploring Data
• Limiting Data
• Calculating Data
• Sharing Data


Cognos 10 Report Studio
• Introduction to Report Studio
• Report Studio User Interface
• Creating, Save and Run Reports
• Report Templates
• Managing Reports
• Types of Reports
• Active Reports
• List Reports
• Crosstab Reports
• Charts
• Formatting a Report
• Report Layout Guidelines
• Fonts, Styles, Header, Footer and Borders
• Insert objects
• Swap Columns and Rows
• Working with Data
• Filters, Parameters and Prompts
• Sorting and Grouping
• Subtotals and Calculations
• Working with Queries
• Working with Reports
• Managing changes in the Package
• Conditional Formatting
• Drill-through Reports
• Drill-up/Drill-down Reports
• Master-Detail Reports
• Scheduling Reports


Cognos 10 Framework Manager
• Introduction to Framework Manager
• Framework Manager Basics
• User Interface, Navigation, Objects
• Planning the project and data model. Framework Manager Workflow
• Naming Conventions for objects in a project
• Designing Project
• Create project
• Importing Metadata from one and more sources
• Exporting Metadata
• Data Sources
• Working with Data Source Connections
• Create and Modify Data Sources
• Improve Performance by setting Query Processing Type
• Preparing Relational Meta data for use in Reports
• Verifying Relationships
• Working with Dimensions
• Working with Query Subjects- Data, Model and Stored Procedure Query Subject
• Working with Query Items- Set Usage and Aggregate Property
• 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
• Best Practices , Presentation and Database layers
• Merge Metadata
• Perform Calculations and Filters

IBM Cognos 10 Business Insight Advanced:
Highlight Report Data

• understand query item properties
• use formatting to improve the visual effectiveness of a report
• use conditional styles to highlight query items on a report

Integrate External Data

• use external data in reports
• map query subjects from an enterprise report to external data

Analyze Your Data

• name four data analysis processes
• implement a report for each process

Use Report Development Processes to Design Effective Reports

• discuss phases of report development for business authors
• discuss elements of effective reports

Extend Business Insight Advanced Reports with Report Studio

• identify Business Insight Advanced reports that can benefit from Report Studio capabilities
• create a report in Report Studio and open it in Business Insight Advanced
• create a report in Business Insight Advanced and extend it in Report Studio

Cognos 10 Business Insight:

• Introduction.
• Getting your bearings in Cognos 10.
• Create your first dashboard page.
• Meet all the new visualization objects.

• Understand the difference between Business Insight and Connection.
• Assemble your own interactive dashboards.
• Reuse Cognos standard reports and lift them to a higher level of usability with Business Insight.
• Be familiar with all the new visualization techniques that Cognos

·         Build a dynamic dashboard and make it reusable for other users