IBM Cognos Analytics Training in Chennai

DW & BI – Concepts

Dimensional Modeling Concepts

Working with Cubes and Hierarchies

 IBM Cognos BI  Architecture

• Cognos Components
• Multi-tier Architecture
• Report Process Flow
• Report Objects

Report Studio

• Report Studio Interface
• Different report templates
• List Report
• Cross Tab Report
• Grouping columns
• Detail Filters
• Summary Filters
• Filters – Before and After Aggregation

Report Studio – Objects and techniques

Objects

• Parameters
• Text and Value Prompts
• Page Sets
• Page, List Headers & Footers
• Chart Report
• Blocks and Tables
• Map Report
• Repeater Table
• Singleton

 Techniques

• Adding multiple pages
• Using Query Explorer
• Multiple Axes
• Nested CrossTab
• Unlocking objects
• Master Detail Reports

Report Studio

• Variables
• Conditional Styling
• Conditional Rendering
• Managing Report Queries 

Report Studio – Active Reports

• Key Features
• Static & Dynmaic Controls
• Interactivity
• Active report variable
• Working Offline

Cognos Portal

• My Content
• Team Content
• Run and Manage Reports

Data Modules

• Using different sources
• Relationship between tables
• Define Filters
• Group data

 Data Sets

• Data Module as a source
• Create from package
• Adding filters
• Reprompt

Dashboard

• Templates
• Sources
• Visualizations
• Multilingual

Framework Manager – Meta data modelling

• Create Project and Models
• Data Sources
• Types of Query Subjects
• Defining Relationships on Query Subjects
• Generated SQL and customized queries
• Setting properties for Query Items
• Filters and Calculations
• Creating and Publishing a Package
• Parameter Maps
• Macros
• Define Dimensionally Modeled Relational Metadata
• Regular, Measure and Time Dimensions
• Power Cubes as data source
• Parameter Maps
• Macros
• Publishing Options
• Different levels of Security 

Performance Tuning