Introduction
- About Cognos 8 BI
- Architecture
- Cognos Features
- Difference between Cognos Other OLAP tools
- Cognos Release
Cognos Connections
- How to Connect to different Data Sources
- How to Provide Security to the Package
- Import and Export of Package (Deployment)
- Running the Report Burn
- Scheduling
Analysis Studio
- Insert Data
- Change the number of Visible Items
- Nest Data
- Replace Data
- Sort Data
- Explore Data
- Change the measure
- Drill down for Details
- Hide Items
- Insert a calculation
- Save a custom set
- Define a filter
- Compare sets of data
- Using Dynamic Context
Query Studio
- Introduction
- About Ad-hoc Reports
- Types of Report(List,Cross Tab,Chart Reports & Others)
- Applying Filters, Prompts & Calculations
- Sorting, Grouping, Sections & Aggregate Functions
Framework Manager
- About Framework Manager
- Framework Manager,Metadata Modeling
- Creation of Interface and Usage
- Creating Model & Namespace (Layers)
- Importing Metadata
- Creating Query Subjects & Query Items
- Merging Query Subjects
- Creating Relationships & Setting Cardinalities
- Creating Parameter Maps & Macros
- Creating of Model Filters,Prompts & Calculations
- Publishing Package
Report Studio
- Type of Report Templates
- Creating list, Cross Tab, Chart & Other Reports
- Map Reports
- Formatting Reports
- Generating and Creating Prompt Page
- Types of Prompts
- Query Calculations & Layout Calculations
- Static Filters and Dynamic Filters
- Conditional Block
- Conditional Formatting
- Master Details
- Cascading Prompt
- HTML Items & Hyperlinks
- Set Operators
- Setting Burst Options
- Setting Variables
- Report Functions
- Report Validation
- Reports Run with Options---http://www.crescentits.com/cognos-online-training.html
- ---------------------------OR------------------------------------
- NTRODUCTION TO DATAWARE HOUSING (DWH)
- Introduction to DWH
- Characteristics of DWH
- OLTP Vs OLAP Databases
- Different Approaches of DWH (Kimball Vs Inmon)
- Data mart Vs Data Warehouse
- Fact Table Vs Dimension Table
- Types Of Facts
- Types Of Dimensions
- ETL
- Staging Area
- Concepts of Schemas (Star schema & Snowflake schema)
- CLP Modeling
- Industry leading ETL and Reporting tools
- About Cognos
- 3 – Tier Architecture
- Cognos Release (EP series7, Reportnet , Cognos 8.0/8.1/8.2/8.3) and their differences
- Features of Cognos 8.4
- Cognos Vs other OLAP tools
- Cognos components (Modeling & Reporting)
- Personalize Cognos Connection
- Create and manage portals, shortcuts, report views..etc
- Running the Report Burn
- Scheduling Reports
- Various Options in Cognos Connection
- Report Studio User Interface
- Creating, Save and run reports
- Managing Reports.
- Creating list, Cross Tab etc.
- Report templates, formatting Reports – fonts, style, header, footer, boarder…etc
- Filters, Parameters and Prompts
- Subtotals and Calculations
- Working with Queries
- Generating and Creating Prompt Page
- Types Of Reports
- Types of Prompts
- Types of Variables
- Query Calculations & Layout Calculations
- Filters and Dynamic Filters
- Conditional Block
- Conditional Formatting
- Master Details
- Cascading Prompt
- Operators
- Setting Burst Options
- Drill through
- Setting Variables
- Report Functions
- Report Validation
- Reports Run with Options
- Different types of Reports with various functionalities
- Unions
- Joins
- Components and there properties.
QUERY STUDIO
- Introduction
- About Ad-hoc Reports
- Types of Report(List, Cross Tab, Chart Reports & Others)
- Applying Filters, Prompts & Calculations
- Sorting, Grouping, Sections & Aggregate Functions
- Run and Manage reports
ANALYSIS STUDIO
- Insert Data
- Nest Data
- Replace Data
- Sort Data
- Explore Data
- Change the measure
- Drill down for Details
- Hide Items
- Insert a calculation
- Save a custom set
- Define a filter
- Compare sets of data
- Using Dynamic Context
- About Framework Manager
- Framework Manager, Metadata Modeling
- Creation of Interface and Usage
- Creating Model & Namespace (Layers)
- Importing Metadata
- Naming convention for objects in a project
- Creating Query Subjects & Query Items
- Merging Query Subjects
- Creating Relationships & Setting Cardinalities
- Creating Parameter Maps & Macros
- Creating of Model Filters, Prompts & Calculations
- Add Business Rules and Set Governors
- Assigning package level security
- Improving performance
- Publishing Package
No comments:
Post a Comment