Overview of Cognos 10 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

Other Courses  Offerings       

• Android
• Cognos 8 BI & Tm1
• Data Stage
• DB2 DBA
• Dot Net
• DAC
• Hyperion Essbase , Planning
• IBM AIX Administration
• IBM Lotus Notes (Development)
• IBM Lotus Notes Domino Server Administration
• IBM Message Broker
• IBM MQ Series
• IBM Web Sphere Application Server Administration (WAS)
• IBM WAS Portal server Development
• Informatica
• I Phone
• Java/J2EE          
• MicroSoft .NET Technologies (VB.NET, C#, ASP.NET)
• Microstrategy
• MicroSoft Business Intelligence
• MicroSoft Dynamics CRM
• OBIEE 11 g
• Oracle APPS –  HRMS
• Oracle APPS –  SCM
• Oracle APPS –  Financial
• Oracle APPS – Technical
• Oracle BI Apps  
• Oracle BI Publisher
• Oracle DBA  11g
• Oracle Fusion SOA , B2B, 
• Oracle SQL , PL SQL
• PHP
• Perl Scripting
• SAP  SD  &  BO & ABAP
• Sales Force CRM
• SharePoint Server 2010