Sunday, February 16, 2014

Cognos Online Training in Hyderabad

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:
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                : 
Contact: any queries are always welcomed Please feel free to mail us for demo session or 
call @ 1 484 365 2489 
India Number @ 91-99497 14567

WhatsApp : 91 8008814567 

Facebook Like

Contact Form


Email *

Message *


Total Pageviews