Facebook Twitter google plus LinkedIn

Email:contact@psntrainings.com
india:Whatsapp No+91 86860 29160 USA:+1 228 586 3560

Cognos Training



Psntrainings is the Best Cognos Online Training institute in Hyderabad,india

Course Description

INTRODUCTION TO DATAWARE HOUSING(DWH)

  • Introduction to DWH
  • Characteristics of DWH
  • OLTP Vs OLAP Databases
  • Different Approaches of DWH (Kimball Vs Inmon)
  • Data mart Vs Data Warehouse
  • Fact Table Vs Dimension Table
  • Concepts of Schemas (Star schema & Snowflake schema)
  • Industry leading ETL and Reporting tools

INTRODUCTION TO COGNOS

  • About Cognos 8.4
  • 3-Tier Architecture
  • Cognos Release (EP series7, Report net,Cognos 8.0/8.1/8.2/8.3) and their differences
  • Features of Cognos 8.4
  • Cognos Vs other OLAP tools
  • Cognos components (Modeling & Reporting)
  • Different Cognos services

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
  • Security setup
  • Import and Export of Package(Deployment)
  • Running the Report Burn
  • Scheduling Reports

FRAMEWORK MANAGER

  • About Framework Manager
  • Framework Manager, Metadata Modeling
  • Creation of Interface and Usage
  • 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

QUERY STUDIO

  • Introduction
  • 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

REPORT STUDIO

  • 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 up & Drill down
  • Setting Variables
  • Report Functions
  • Report Validation
  • Reports Run with Options

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
We are offered Datastage online training also


Enquiry