Course Duration in Hours
90
90
Course content for class room and online training
Learning Objective
Introduction to Data warehousing?
Introduction to Business Intelligence?
Who needs Data warehousing?
Why Data warehousing is required?
Data warehousing Architecture
Difference between OLTP & OLAP?
Data Mart -Need ,Advantages
ETL - Process training
What is a Dimension?
What are Facts?
Star Schema?
Snowflake Schema?
Dimension Modeling?
Slowly changing Dimensions?
Conformed Dimension?
About Cognos 10 BI training
Architecture
Cognos Suit walk through
Cognos Features, Need & Importance.
Cognos Connection
Walk through elements on the screen
Manage Folders(Public & My folders)
How to Connect to different Data Source
Import and Export of Package(Deployment)
Set up Scheduling of Reports
Frame Work Manager
Introduction about Frame work Manager
Workflow of Frame work Manager
Designing a Project
Working with Data Sources
Designing and preparing Metadata Model
Working With Packages
Query Studio
Introduction
About Ad-hoc Reports
Reporting using Query Studio (List, Crosstab, Chart Reports & others)
Working with Data ( Applying Filters, Prompts & Calculations, Sorting, Grouping &Sections )
New Features in Cognos 10
Cognos Workspace
Cognos Workspace Advanced
Active Reports
Overview of Cognos 8 Components & comparison with cognos10
Introduction to Report Studio
Type of Report Templates
Creating List, Crosstab, Chart & Others Reports
Introduction to Filters(creating, editing &removing filters)
Parameters & Prompts (Definition, Creating prompt Page& Usage of Multiple prompts in Reports)
Formatting Reports(Fonts, styles, Header &Footers )
Types of Prompts (Select& search ,Tree, generated prompt, Date, Time)
Cognos 10 Advanced Reporting Topics
Conditional Blocks - Need ,usage
Conditional Formatting
Complex Reports (Master Detailed, Drill Through reports)
Introduction to Query Explorer (Building reports using queries, joins)
How to use HTML & JAVA scripts in Reports-Need ,Importance
Import
Many more Advanced Reports
Other Topics
Import & Export XML Reports
Open Reports from XML
Creating , Editing Queries
Workflow of how report runs in backend.
How to create portal Pages
Analysis Studio
About Analysis Studio
Insert Data
Explore Data
Types of Reports
Drill up & Drill down for Detail
Event Studio
Introduction to Event Studio
Discuss Event Studio window
Events, Agents, Tasks..
Cognos Administration
Import and export of Package
Scheduling and manage reports
Transformer
Cube
Relative time
Dimensions, Levels, Categories
Measures
Cognos Active Reports
Overview of Cognos Active Report.
Difference between Cognos Report and Cognos Active Report.
Difference between Parameter and Variable
Few features of Active Reports
o Absolutely Positioned Content
o Cascading Animated Prompt
o Custom Buttons
o Disabling Until a Condition is Met
o Drill to Details
o Exploding Pie Slice
o Hidden Report Regions
o Scrollable Control List
o Sliding to Visualize Changes
o Toggled Conditional Styling
o Toggled List Column Display
o Tree Control
Things to remember for IPad versions of Active Report.
o Size of Report (702 X 1024)
o Installation of Cognos Mobile app on IPad
Performing Drill Through For IPad Reports
Fresher/Experienced
Info Era, Indira Nagar (Bangalore),Bangalore,IN