Cognos BI training institute in Hyderabad | Cognos Bi Training


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
o discuss different modes of reporting
o examine Report Studio and its interface
o explore different report types
o create a simple, sorted, and formatted report
o explore how data items are added to queries
• Create List Reports
o group, format, and sort list reports
o describe options for aggregating data
o create a multi-fact query
o create a report with repeated data
 Focus Reports Using Filters
o create filters to narrow the focus of reports
o examine detail and summary filters
o determine when to apply filters on aggregate data
• Create Crosstab Reports
o format and sort crosstab reports
o create complex crosstabs using drag and drop functionality
o create crosstabs using unrelated data items
• Present Data Graphically
o create charts containing peer and nested columns
o present data using new chart type options
o add context to charts
o present key data in a single dashboard report
• Focus Reports Using Prompts
o identify various prompt types
o use parameters and prompts to focus data
o search for prompt types
o navigate between pages
• Extend Reports Using Calculations
o create calculations based on data in the data source
o add run-time information to the reports
o create expressions using functions
• Design Effective Reports
o enhance report design with report objects
o reuse objects within the same report
o share layout components among separate reports
• Customize Reports with Conditional Formatting
o create multi-lingual reports
o highlight exceptional data
o show and hide data
o conditionally render objects in reports
o conditionally format one crosstab measure based on another
• Drill-Through from One Report to Another
o let users navigate from a specific report to a target report
o pass parameter values to filter the data in drill-through targets
o navigate through multiple reports
 Drill-through Definitions
o discuss parameter-driven drill through
o discuss dynamic drill through
o set up package-based drill-through definitions
o set scope
o use the Drill Through Assistant
 Manage Content in IBM Cognos Connection
o schedule and manage reports
o view lineage information
o organize content
o examine IBM Cognos Connection personal preferences
o set alerts and watch rules
o design a portal page and dashboard
o set permissions using IBM Cognos 10 BIgroups and roles
• Examine the Report Specification
o examine the report specification structure
o save and edit reports locally
o discuss considerations for modifying a report specification
• Create Query Models
o build query models and then connect them to the report layout
o add filters and prompts to a report using the query model
o edit an SQL statement to author custom queries
• Create Reports Based on Query Relationships
o create reports by merging query results
o create reports by joining queries
o combine data containers based on relationships from different queries
 Distribute Reports Through Bursting
o distribute reports using bursting
o create burst keys
o identify report recipients and data items using burst tables
o distribute reports using email and IBM Cognos Connection
• Create Advanced Dynamic Reports
o filter reports on session parameter values
o navigate a briefing book using a table of contents
o create dynamic headers and title that reflect report data
o let users navigate to specific locations in reports
o create a customer invoice report
 Design Effective Prompts
o control report displays using prompts
o specify conditional formatting values using prompts
o create a report that formats based on prompts selection
o create a sorted and filtered report based on prompt selection
• Create Additional Advanced Reports
o create a report that displays summarized data before detailed data
o 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)
o Introduction to Framework Manager
o Framework Manager Basics
o User Interface, Navigation, Objects
o Designing Project
o Create project
o Importing Metadata
o Exporting Metadata
o Create Model Documentation
o Data Sources
o Working with Data Source Connections
o Create and Modify Data Sources
o Improve Performance by setting Query Processing Type
o Preparing Relational Metadata for use in Reports
o Verifying Relationships
o Working with Dimensions
o Working with Query Subjects
o Working with Query Items
o Supporting Multilingual Metadata
o Adding Business Rules
o Organizing the Model
o Making Metadata Available to Report Authors
o Verify Model
o Set Governors
o Improving Performance
o Create or Modify Package
o Controlling access to Metadata
o Explore Package
o Publish Package
o Guideline for Modeling Metadata
o Scenarios
o New Objects – Regular Dimensions, Measure Dimensions, Scope Relationship
o Dimensional Modeling of Relational Data Sources