INTRODUCTION 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
Concepts of Schemas (Star schema & Snowflake schema)
Industry leading ETL and Reporting toolsINTRODUCTION TO COGNOS
About Cognos 8.4
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)
Different cognos services
COGNOS CONNECTIONS
Personalize cognos connection
Create and manage portals, shortcuts, report views..etc
Working with Cognos configuration, content Store
How to Connect to different Data Sources
Security setup
Import and Export of Package (Deployment)
Running the Report Burn
Scheduling Reports
FRAMEWORK MANAGER

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

QUERY STUDIOIntroduction
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

REPORT STUDIO

Type of Report Templates
Creating list, Cross Tab, Chart, repeater, Maps & Other Reports
Report templates, formatting Reports – fonts, style, header, footer, boarder…etc
Generating and Creating Prompt Page
Types of Prompts
Query Calculations & Layout Calculations
Filters and Dynamic Filters
Conditional Block
Conditional Formatting
Master Details
Cascading Prompt
HTML Items & Hyperlinks
Set Operators
Setting Burst Options
Drill through
Drill up & Drill down
Setting Variables
Report Functions
Report Validation
Reports Run with Options

ANALYSIS STUDIO : Cognos Online Training

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

EVENT STUDIO

Creating Agents
Adding Event conditions
Task and Task execution rules
Scheduling Agents

More about

ibm cognos certification