0 items

Cognos Online Training

COURSE CONTENTS FOR Cognos                                          

Cognos Course Detailed Description

  • Cognos Installation Steps, Softwares, Exercises, Training
  • materials, Certification Dumps will be provided during the Class

Overview of Business Intelligence

  • What is Business Intelligence
  • Why is BI Important and where can we use it
  • Components of BI
  • Business Intelligence Roadmap

Overview of Data Warehousing

  • What is Data Warehouse, Why do we need it
  • Data Warehouse Architecture and its components
  • Define Star Schema – Fact and Dimensions
  • Understand OLTP and OLAP Systems

Overview of Cognos BI and Architecture

  • Introduce Cognos BI
  • Examine the different studios in Cognos BI
  • Identify the different data sources within the studios
  • Highlight key capabilities of Cognos BI
  • Understand Cognos Multi Layered architecture

Cognos Installations and Configuration

  • Installing Cognos
  • Install Database (MS SQL)
  • Install Framework Manager
  • Install Cognos BI Application
  • Setting up the Environment
  • Configuring Cognos
  • Setting up Samples in Cognos
  • Uninstalling Cognos

  Cognos BI Administration

  • Create and Modify a Data Source
  • Create Database backups
  • Understand Roles, Users and Groups
  • Specify Permission Settings

Cognos Connection

  • What is Cognos Connection
  • Examine Cognos Connection UI elements – Create a URL,
  • Login, Logoff
  • Entry Properties: General Properties, Permissions, Report,
  • Query, Analysis, Job, Agent and Page Properties
  • Navigation- Public and Private Folder
  • Open reports with Report Name, Go to Links, Run Reports from a View
  • Run Reports- Prompt Pages, Printing a report and Open in Excel
  • View the run history of a report and Historical Reports
  • Closing and Creating Quick links to Reports – My Folder
  • Shortcut and Browser Bookmark
  • Personalize Cognos Connection
  • Backups- Export of Cognos, Content Store or select items for Backups
  • Restore an exported Backup
  • Create and Customize a Page and share a single page with
  • Multiple Users

Cognos Query Studio

  • Introduction to Query Studio
  • Create Reports (List, Grouped List, Crosstab, Charts)
  • Changing the Appearance of Reports (Format)
  • Sorting and Grouping
  • Filters and Prompts
  • Subtotals and Calculations
  • Run and Manage Reports
  • Drill Through reports

Cognos Analysis Studio

  • Introduction to Analysis Studio
  • Creating a Basic Analysis
  • Working with data in Crosstab
  • Exploring Data
  • Limiting Data
  • Calculating Data
  • Sharing Data

Cognos Report Studio

  • Introduction to Report Studio
  • Report Studio User Interface
  • Creating, Save and Run Reports
  • Report Templates
  • Managing Reports
  • Types of Reports
  • List Reports
  • Crosstab Reports
  • Charts
  • Formatting a Report
  • Report Layout Guidelines
  • Fonts, Styles, Header, Footer and Borders
  • Insert objects
  • Swap Columns and Rows
  • Working with Data
  • Filters, Parameters and Prompts
  • Sorting and Grouping
  • Subtotals and Calculations
  • Working with Queries
  • Working with Reports
  • Managing changes in the Package
  • Conditional Formatting
  • Drill-through Reports
  • Drill-up/Drill-down Reports
  • Master-Detail Reports
  • Scheduling Reports

Cognos Framework Manager (Metadata Modeling )

  • Introduction to Framework Manager
  • Framework Manager Basics
  • User Interface, Navigation, Objects
  • Planning the project and data model. Framework Manager
  • Workflow
  • Naming Conventions for objects in a project
  • Designing Project
  • Create project
  • Importing Metadata from one and more sources
  • Exporting Metadata
  • Data Sources
  • Working with Data Source Connections
  • Create and Modify Data Sources
  • Improve Performance by setting Query Processing Type
  • Preparing Relational Metadata for use in Reports
  • Verifying Relationships
  • Working with Dimensions
  • Working with Query Subjects- Data, Model and Stored
  • Procedure Query Subject
  • Working with Query Items- Set Usage and Aggregate Property
  • Making Metadata Available to Report Authors
  • Verify Model
  • Set Governors
  • Improving Performance
  • Create or Modify Package
  • Controlling access to Metadata
  • Explore Package
  • Publish Package
  • Guideline for Modeling Metadata
  • Best Practices – Presentation and Database layers
  • Merge Metadata
  • Perform Calculations and Filters

Cognos Power Play Transformer (Power Cube Modeling)

  • Fundamentals
  • What is Cognos Transformer
  • Understanding Power Play Data Sources
  • Starting and Navigating Transformer
  • Importing your source Data
  • Creating your Power Cube
  • Building the Time Dimension
  • Create the Time Dimension Manually
  • Building a Transformer Model
  • Performance Considerations
  • Build Model with AutoDesign
  • Modify Property sheets for Dimensions, Levels and
  • Categories
  • Build Model without AutoDesign
  • Create New Dimensions from Source Data
  • Creating Exception Dimensions from Source Data
  • Specify a Level Label
  • Enhancing Your Model
  • Creating Sub-Dimensions
  • Creating Alternate Drill Paths
  • Creating Special Categories
  • Creating Calculated Columns
  • Creating Multiple Query Power Cubes
  • Adding a Query to Existing Model
  • View Scope of a Data Source
  • Creating a Multiple Query Model
  • Currency Conversions and Indentify Measures that use
  • Currency Conversions
  • Create a Power Cube for Distribution
  • Creating Regional Power Cubes
  • Adding Cube Password Protection

Daily 2 hr

Interested candidates Contact:

For Online Trainings: SHIVA- +91 80088 14567

For Further Details Please Click Here: http://www.soasanaari.com

Note: If possible, Please Pass This Message to Your Friends/Colleagues.

Sanaari Software Solutions Private Limited
Office               :           +91 40 40048283
Mobile             :           +91 99497 14567
Madhapur       :           +91 8008914567,
USA                  :           +1 484 365 2489
Skype               :           Sanaari

Gtalk                :           shivaitonline@gmail.com

Contact: shiva@sanaari.net  any queries are always welcome

Please feel free to mail us for demo session or call @ 1 44 365 249