Cognos Online Training
Cognos Online Training
Cognos Online Training
Cognos Online Training Course Content :
Cognos 10 Architecture
User Interfaces
- Cognos connection
- Query studio, Report studio, Analysis studio, Event studio
- Frame work manager
Cognos 10 servers
- Content manager
- Dispatcher
- Content store
Work Flow
- Creating Models and Packages
- Authoring Reports
Frame Work Manager
Designing a Project
- Naming conventions for objects in a project
- Connecting to Data sources
- Create a data source connection
- Importing Meta data
- Preparing Meta data for using reports
- Verifying relationships
- Working with query subjects
- Modifying the properties of query items
- Format query items
- Define a prompt control
- Modifying how query items are aggregated
- Adding business rules
- Creating calculations and Filters
- Using prompt values to filter data
- Creating a business view of the model
- Use short cuts
- Create a folder or name space
- Create a query item folder
- Dimension models
- Specify dimension information
- Create a star schema grouping
- Create the package
- Publishing a package
- Verify a model and Set governors
Changing the Appearance of the reports
- Applying filters
- Shorting data
- Custom groups
- Group identical values
- Calculations
- Producing reports in various formats
Report Studio
- Working in Cognos report Studio
- The User interface
- Basic report structure
- Working with objects
- Creating and managing reports
- Types of reports
- List reports
- Cross tab reports
- Charts and repeaters
- Formatting a report
- Swapping rows and columns
- Working with data
- Filter data
- Sort data
- Create sections
- Adding Prompts
- Working with queries
- Drilling through Cognos reports
- Report studio objects and properties
- A work shop on framework manager
- Query studio and report studio
Query Studio
- Using query studio
- Creating a report
- Report types
- List reports
- Grouped List reports
- Cross tab reports
- Charts
Analysis Studio
- Analysis studio
- Creating Basic Analysis
- Working with Items in the Cross Tab
Event Studio
- New Event
- Ongoing Event
- Ceased Event
- No Event
Cognos Transformer
Data Warehousing Basic Concepts
- Data Warehouse Definition,
- Reasons for using, uses
- Characteristics of DWH
- OLTP Vs OLAP Databases
Architecture of Date Warehouse
- Process flow In DWH
- Components of Architecture
- Source, Integration Layer, Staging Area.
Implementation Methodology
- Kimball Methodology
- Inmon Methodology
Types of Loads
- First Time Load
- Full Load
- Incremental Load
Data Marts and Star Schema Design
- Definition of Star Schema
- Data Marts Reasons for Construction
- Replacement of Data Mart With Warehouse
- Design process
- Design of Dimension and Facts
- Snow Flake Star Schema
- Summary Tables
- Slowly Changing Dimensions
- Non Additive Facts
- Conformed Dimensions
- Types of OLAP ROLAP, DOLAP, HOLAP, MOLAP