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

COGNOS 10

• 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 Transfomer:-

• Creating Cubes