banner
 
 
  ......................................................................................................................................................................................................................................  
  COGNOS REPORTNET BI FOR TRAINING  
   
 
  ......................................................................................................................................................................................................................................
 
  • Review Corporate Performance Management 
  • Introduce Cognos 8 BI
  • Examine the different studios in Cognos 8 BI
  • Identify the different data sources within the studios
  • Highlight key capabilities of Cognos 8 BI
  ......................................................................................................................................................................................................................................
  INTRODUCTION TO COGNOS CONNECTION
  ......................................................................................................................................................................................................................................
 
  • Identify the advantages of using Cognos Connection
  • Schedule and manage reports
  • Organize content
  • Include dynamic Web pages
  .......................................................................................................................................................................................................................................
  COGNOS REPORTNET BI FOR TRAINING
  OVERVIEW OF COGNOS 8 BI
  .......................................................................................................................................................................................................................................
 
  • Review Corporate Performance Management
  • Introduce Cognos 8 BI
  • Examine the different studios in Cognos 8 BI
  • Identify the different data sources within the studios
  • Highlight key capabilities of Cognos 8 BI
  .......................................................................................................................................................................................................................................
  INTRODUCTION TO COGNOS CONNECTION
  ......................................................................................................................................................................................................................................
 
  • Identify the advantages of using Cognos Connection
  • Schedule and manage reports
  • Organize content
  • Include dynamic Web pages
  .......................................................................................................................................................................................................................................
  INTRODUCTION TO QUERY STUDIO
  ......................................................................................................................................................................................................................................
 
  • List the packages available for reporting
  • Examine 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 define your own report item
  ......................................................................................................................................................................................................................................
  TOOLS FOR INVESTIGATION
  ......................................................................................................................................................................................................................................
 
  • Drill down and drill up
  • Change rows, columns and measures
  • Sort
  • Show values as percentages
  • Manage the number of items retrieved
  • Display data graphically
  .......................................................................................................................................................................................................................................
  INTRODUCTION TO THE REPORT STUDIO
  ......................................................................................................................................................................................................................................
 
  • Examine Report Studio and its interface
  • Explore different report types
  • Create a simple, sorted, and formatted report
  .......................................................................................................................................................................................................................................
  CREATE LIST AND CROSSTAB REPORTS
  ......................................................................................................................................................................................................................................
 
  • Format, group, and sort list reports
  • Format and sort crosstab reports
  • Create a report with repeated data
  • Work with dimensional data in a report
  .......................................................................................................................................................................................................................................
  PRESENT DATA GRAPHICALLY
  ......................................................................................................................................................................................................................................
 
  • Create charts 
  • Present data using new chart type options
  • Create and reuse custom chart palettes
  • Present key data in a single dashboard report
  .......................................................................................................................................................................................................................................
  FOCUS REPORTS USING FILTERS
  ......................................................................................................................................................................................................................................
 
  • Create filters to narrow the focus of reports
  • Determine when to apply filters on aggregate data
  • Examine source filters
  ......................................................................................................................................................................................................................................
  FOCUS REPORTS USING PROMPTS
  ......................................................................................................................................................................................................................................
 
  • Use parameters and prompts to focus data
  • Identify various prompt types
  • Customize prompts to facilitate users’ choices
  • Search for prompt items
  • Navigate between pages
  .......................................................................................................................................................................................................................................
  DESIGN EFFECTIVE REPORTS
  ......................................................................................................................................................................................................................................
 
  • Enhance report design
  • Add report objects to enhance design
  • Format data and report objects
  • Add a background image to a report
  • Add row numbers to a report
  .......................................................................................................................................................................................................................................
  CUSTOMIZE REPORTS WITH CONDITIONAL FORMATTING
  .......................................................................................................................................................................................................................................
 
  • Create multi-lingual reports
  • Highlight exceptional data
  • Show and hide data
  • Conditionally render objects in reports
  ......................................................................................................................................................................................................................................
  INTRODUCTION TO FRAMEWORK MANAGER
  .......................................................................................................................................................................................................................................
 
  • Define Framework Manager and its purpose
  • Describe the Framework Manager environment
  • Examine the Cognos 8 and Framework Manager workflow processes
  • Examine the Framework Manager user interface 
  • Create a project
  .......................................................................................................................................................................................................................................
  PREPARE METADATA IN FRAMEWORK MANAGER
  .......................................................................................................................................................................................................................................
 
  • Verify and modify query item properties and relationships to control the presentation of data and ensure expected results
  • Customize data for a multilingual audience
  • Customize metadata for runtime to dynamically control the data returned through calculations and filters
  • Leverage user defined functions and stored procedures
  • Resolve a recursive relationship
  ......................................................................................................................................................................................................................................
  MODEL FOR PREDICTABLE RESULTS IN FRAMEWORK MANAGER
  .......................................................................................................................................................................................................................................
 
  • Identify reporting traps
  • Identify the advantage of modeling as a star schema 
  • Use metadata modeling recommendations to model a dimensional data source
  .......................................................................................................................................................................................................................................
  INTRODUCTION TO COGNOS CONNECTION
  .......................................................................................................................................................................................................................................
 
  • Identify the advantages of using Cognos Connection
  • Schedule and manage reports
  • Organize content
  • Customize a portal
  .......................................................................................................................................................................................................................................
  EXPLORE ADMINISTRATION FUNDAMENTALS
  .......................................................................................................................................................................................................................................
 
  • Examine the administration tools
  • Add a data source
  • system.xml
  • CognosURL.xml (Access Dynamic Data from server to Report )
  • Image Access from server
  ......................................................................................................................................................................................................................................
  MANAGE CONTENT
  ......................................................................................................................................................................................................................................
 
  • Define deployment
  • Discuss security and deployment
  • Create deployment folders
  • Export and import entries
  • View the deployment history
  • Content store
  .......................................................................................................................................................................................................................................
  INTRODUCTION TO FRAMEWORK MANAGER
  .......................................................................................................................................................................................................................................
 
  • Define Framework Manager and its purpose
  • Describe the Framework Manager environment
  • Examine the Cognos 8 and Framework Manager workflow processes
  • Examine the Framework Manager user interface 
  • Create a project
  .......................................................................................................................................................................................................................................
  PREPARE METADATA IN FRAMEWORK MANAGER
  .......................................................................................................................................................................................................................................
 
  • Verify and modify query item properties and relationships to control the presentation of data and ensure expected results
  • Customize data for a multilingual audience
  • Customize metadata for runtime to dynamically control the data returned through calculations    and filters
  • Leverage user defined functions and stored procedures
  • Resolve a recursive relationship
  .......................................................................................................................................................................................................................................
  MODEL FOR PREDICTABLE RESULTS IN FRAMEWORK MANAGER
  ......................................................................................................................................................................................................................................
 
  • Identify reporting traps
  • Identify the advantage of modeling as a star schema 
  • Define how Cognos 8 treats cardinality
  • Use metadata modeling recommendations to model a dimensional data source
  .......................................................................................................................................................................................................................................