Cognos

INTRODUCTION

  • Introduction to Basic SQL
  • Data warehousing Overview
  • Business Intelligence Overview
  • Cognos Architecture and Overview

COGNOS CONNECTIONS

  • Personalize Cognos connection
  • Create and manage portals, shortcuts, report views..etc
  • Working with Cognos configuration, content Store
  • How to Connect to different Data Sources
  • Import and Export of Package (Deployment)
  • Running the Report
  • Scheduling Reports
  • Basic Cognos Administration

QUERY STUDIO

  • About Ad-hoc Reports
  • Types of Report(List, Cross Tab, Chart Reports & Others)
  • Applying Filters, Prompts & Calculations
  • Sorting, Grouping, Sections & Aggregate Functions
  • Run and Manage reports
  • Limitations of Query Studio Report
  • Converting Query Studio Report to Report Studio Report

ANALYSIS STUDIO

  • Insert Data
  • Change the number of Visible Items
  • Nest Data
  • Replace Data
  • Sort Data
  • Explore Data
  • Change the measure
  • Drill down for Details
  • Hide Items
  • Insert a calculation
  • Save a custom set
  • Define a filter
  • Compare sets of data
  • Using Dynamic Context

EVENT STUDIO

  • Creating Agents
  • Adding Event conditions
  • Task and Task execution rules
  • Scheduling Agents

WORKSPACE ADVANCE

Examine Workspace Advanced

  • Business Scenario
  • What is Workspace advanced
  • Explore the user interface
  • Design the report layout
  • View your data
  • Define the report layout
  • Report Studio vs Workspace Advance

CREATE A REPORT

  • Business Scenario
  • Goal of reporting
  • List Report Example
  • Crosstab Report Format
  • Crosstab Example
  • Chart Report format
  • Basic Chart Types
  • Pie Chart Example
  • Column Chart Example
  • Combination Reports
  • Same data with multiple business cases
  • Create a calculation

REPORT STUDIO (will be covered in detail)

  • Type of Report Templates
  • Creating list, Cross Tab, Chart, repeater, Maps & Other Reports
  • Report templates, formatting Reports – fonts, style, header, footer, boarder…etc
  • Generating and Creating Prompt Page
  • Types of Prompts
  • Query Calculations & Layout Calculations
  • Filters and Dynamic Filters
  • Conditional Block, Conditional Formatting
  • Master Details
  • Cascading Prompt
  • HTML Items & Hyperlinks
  • Set Operators
  • Setting Burst Options
  • Drill through, Drill up & Drill down
  • Setting Variables
  • Report Functions
  • Report Validation
  • Reports Run with Options
  • Active Reports
  • XML and bug fixing

FRAMEWORK MANAGER


  • About Framework Manager
  • Framework Manager, Metadata Modeling
  • Creating Model & Namespace (Layers)
  • Importing Metadata
  • Naming convention for objects in a project
  • Creating Query Subjects & Query Items
  • Merging Query Subjects
  • Creating Relationships & Setting Cardinalities
  • Creating Parameter Maps & Macros
  • Creating of Model Filters, Prompts & Calculations
  • Add Business Rules and Set Governors
  • Assigning package level security
  • Improving performance
  • Publishing Package

WORKSPACE

  • Explore, Navigate, and create dashboards
  • Business Scenario
  • Dashboard content
  • Define widgets
  • Add report content to dashboard
  • Align and rearrange widgets in the dashboard
  • Add tools to dashboard
  • Adding multiple tabs and managing workspace

BEST PRACTICE AND OTHER TOPICS

  • Best Practice
  • Coding Standards
  • Overview of Quality Process
  • POC Reports
  • Process flow in report development
  • Documents and links to share
  • Additional real time scenario and exercises will be provided in Report Studio
  • Real time examples and my experience will be shared. Starting from Requirement gathering, POC, development, peer review, checklist, coding standards, unit testing, quality documentation till KT to customer/support team