COGNOS
About This Course
Course Curriculum
Cognos is a Business Intelligence Software that enables users to collate multidimensional data from various sources, analyze it to understand customer behavior and business performance and present the information through creative dashboards for better decision making. This online training class tries to focus on all critical elements of Cognos from a practical perspective.
CONTENTS :
DATA WAREHOUSE OVERVIEW
- Data Warehouse Environment, Architecture, Characteristics,
- Data Marts Vs Data Warehouse
- OLAP VS OLTP
- ETL Overview
- Fact, Dimension, Identifier
- Schema
- Modifying Dimensions
UNDERSTANDING COGNOS AS A BUSINESS INTELLIGENCE SOFTWARE
- Basic Concepts
- Framework Manager
- Query, Report and Analysis Studio
CONNECTION SETUP
- Connection Login Settings
- Models and Packages
- Creating URL and URL Shortcuts
- Bookmark Searched Entries
- Make Tailor Made User View of portal
- Create Jobs, Schedule and Manage Reports
QUERY STUDIO FUNCTIONALITY
- Features, Ad-Hoc Reports
- Types of Reports
- Working with Filters, Prompts, Calculations
- Operate with Sorting, Grouping and aggregate functions
- Page Break Settings, Conditional Formatting
- Execute and Managing Reports
- Define Custom Groups, Expand and Collapse.
- Apply Swap and Rows on Reports
REPORT STUDIO FUNCTIONALITY
- Report Structure, Design User Interface
- Reuse Objects, customize properties to set options
- Page Structure view
- Create Report and Report Layout
WORKING WITH DATA
- Work with Data Operations: Filter, Sort,
- Data Format, Adding Header & Footer
- Create Calculations
- Confine with Summary
PROMPTS AND ADVANCE REPORTS
- Schedule Prompts
- Build Prompt Page Tool
- Drag prompts into the reports
- Manage Changes in the model
- Conditional Formatting
- Drill-Through Reports
- Master-Detail Reports
COGNOS V10.1 ACTIVE REPORTS
- Basic Definition of Active Reports
- Key Features with active report structure
- Row ID
- Variable Text item
- Deck and Data Deck objects
- Tab controls
- Various Button Bars and their functioning with Data
- Check Box Group and their functioning with data
ADVANCED FRAMEWORK MANAGER
- Basic functionality of framework manager
- Creating and working with Projects, Models, Query, Subjects
- Initiate Security
- Meta Data Modeling
- Multilingual Reports
- Handle Projects
- Manage Dimensions
- Change Query Item Properties
- Create Filters
- Organize and verify Models
- Create and Modify Packages
- Publish Package
- Set Authorization controls
- Set Access controls Security to Meta Data
- Work on Name Spaces
- Create User groups, Roles with access checkpoints
- Content Store Security maintenance
- Deploy Project Specs, Planning and Entries
EVENT STUDIO FUNCTIONALITY
- Event studio basic structure with functionality
- Build task execution catalog with rules
- Reorder task execution priority
- Work with calculation items
- Run event reports
ANALYSIS STUDIO AND CUBE FUNCTIONING
- Pop in data
- Modify Item Visibility
- Analyze Data using analysis studio
- Data Operations: Nest, Replace, Sort, Filter
- Explore Data