Introduction to Data warehousing
- Introduction to Data warehousing?
- Introduction to Business Intelligence?
- Why Data warehousing is required?
- Who needs Data warehousing?
- Data warehousing Architecture
- Differ OLTP & OLAP?
- Data Mart –Need ,Advantages
- ETL – Process
- What is a Dimension?
- What are Facts?
- Star Schema?
- Snowflake Schema?
- Dimension Modeling?
- Slowly changing Dimensions?
- Conformed Dimension?
Cognos Concepts
About Cognos 10 BI
- Architecture
- Cognos Features, Need & Importance.
- Cognos Suit walk through
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 ……)
Report Studio
Introduction to Report Studio
- Type of Report Templates
- Creating List, Crosstab, Chart & Others Reports
- Introduction to Filters(creating, editing &removing filters)
- Types of Prompts (Select& search ,Tree, generated prompt, Date, Time……)
- Formatting Reports(Fonts, styles, Header &Footers …)
- Parameters & Prompts (Definition, Creating prompt Page & Usage of Multiple prompts in Reports)
Cognos 10 Advanced Reporting Topics
- Conditional Blocks – Need ,usage
- Conditional Formatting
- Introduction to Query Explorer (Building reports using queries, joins…)
- How to use HTML & JAVA scripts in Reports-Need ,Importance
- Import
- Complex Reports (Master Detailed, Drill Through reports)
- Many more Advanced Reports
Other Topics
- Import & Export XML Reports
- Open Reports from XML
- Workflow of how report runs in backend.
- Creating , Editing Queries
- 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
