COGNOS Course Details
Introduction to Data Warehouse
- Introduction to DWH
- Characteristics of DWH
- Data Warehouse Concepts
- Data mart Vs Data Warehouse
- Data warehousing architecture
- OLAP vs OLTP
- Business Intelligence Concepts
- ETL Concepts
- Reporting Concepts
- Industry leading ETL and Reporting tools
- Define Fact, dimension and identifier
- Star schema and Snowflake schema
- Slowly changing dimension
Introduction to Cognos
- About Cognos 10.1
- 3 – Tier Cognos 10.1 Architecture
- Cognos Connection
- Query Studio
- Event Studio
- Report Studio
- Analysis Studio
- Framework Manager
- Powerplay Transformer
Cognos Connection
- Log on to Cognos Connection
- Models and Packages
- Create a URL Create a shortcut
- Properties of an Entry
- Search for an Entry
- Bookmark an Entry
- Personalize the portal
- Scheduling and manage reports
- Create Jobs
Introduction to Query Studio
- Introduction
- Features in Query Studio
- About Ad-hoc Reports
- Types of Report (List, Cross Tab, Chart
Reports & Others)
- Applying Filters, Prompts & Calculations
- Sorting, Grouping, Sections & Aggregate
Functions
- Apply page break on Reports
- Run and Manage reports
- Define custom group
- Conditional formatting
- Expand and Collapse groups
- Apply Swap and Rows on Reports
Introduction to Report Studio
- Basic Report Structure
- User Interface
- Work with Objects Set options
- Create a Report
- Page Structure View
- Reports Layout
- Reuse objects
- Set object properties
Work with Data
- Day 5 Filter Data
- Sort Data
- Create Sections
- Format Data
- Header & Footer
- Add a Summary
- Create Calculations
Prompts & Advanced Reports
- Include Prompts
- Build Prompt Page Tool
- Prompts & Prompt Page
- Insert prompts into the report
- Manage changes in the model
- Conditional Formats
- Drill-through reports
- Master-detail reports
Cognos 10.1 Active Reports
- Introduction to Active reports
- Key Features
- Purpose
- Active Report structure
- Row Number
- Variable Text item
- Deck & Data Deck objects
- Tab Control& Data Tab Control
- Button Bar & Data Button Bar
- Toggle Button Bar & Data Toggle Button
Bar
- Radio Button Group & Data Radio Button
Group
- Check Box Group & Data Check Box Group
Framework Manager - I
- Introduction to Framework Manager
- Objects to work with - Projects, Models,
Query subjects, etc
- Create a project
- Work with Metadata
- Multilingual Reports
- Manage Projects
- Work with dimensions
- Modify properties of Query Items
- Create a filter
- Organize the model
Framework Manager -II
- Verify models
- Create & modify packages
- Access to metadata
- Publish a package
- Authorization
- Cognos Namespaces
- Application security
- Users, Groups & Roles
- Access Permissions
- Initial Security setup
- Content Store security
- Deployment Specs & Planning
- Deploy Cognos Entries
Introduction to event Studio
- Basic event Studio structure
- Working with different Tasks
- Managing the Task execution rules
- Reordering the tasks
- Work with New calculation item
- Running the event report
Introduction to Analysis Studio/Cubes
- Insert Data
- Change the number of Visible Items
- Analyze data using Analysis Studio
- Nest Data
- Replace Data
- Sort Data
- Explore Data
- Define a filter