Datawarehouse Online Training » Cognos Online Training
Cognos Online Training Concepts :
INTRODUCTION TO DATAWARE HOUSING (DWH)
1.Introduction to DWH
2.Characteristics of DWH
3.OLTP Vs OLAP Databases
4.Different Approaches of DWH (Kimball Vs Inmon)
5.Data mart Vs Data Warehouse
6.Fact Table Vs Dimension Table
7.Concepts of Schemas (Star schema & Snowflake schema)
8.Industry leading ETL and Reporting tools
INTRODUCTION TO COGNOS
1.About Cognos 8.4
2.3 – Tier Architecture
3.Cognos Release (EP series7, Reportnet , Cognos 8.0/8,1/8.2/8.3) and their differences
4.Features of Cognos 8.4
5.Cognos Vs other OLAP tools
6.Cognos components (Modeling & Reporting)
7.Different cognos services
COGNOS CONNECTIONS
1.Personalize cognos connection
2.Create and manage portals, shortcuts, report views..etc
3.Working with Cognos configuration, content Store
4.How to Connect to different Data Sources
5.Security setup
6.Import and Export of Package (Deployment)
7.Running the Report Burn
8.Scheduling Reports
FRAMEWORK MANAGER
1.About Framework Manager
2.Framework Manager, Metadata Modeling
3.Creation of Interface and Usage
4.Creating Model & Namespace (Layers)
5.Importing Metadata
6.Naming convention for objects in a project
7.Creating Query Subjects & Query Items
8.Merging Query Subjects
9.Creating Relationships & Setting Cardinalities
10.Creating Parameter Maps & Macros
11.Creating of Model Filters, Prompts & Calculations
12.Add Business Rules and Set Governors
13.Assigning package level security
14.Improving performance
15.Publishing Package
QUERY STUDIO
1.Introduction
2.About Ad-hoc Reports
3.Types of Report(List, Cross Tab, Chart Reports & Others)
4.Applying Filters, Prompts & Calculations
5.Sorting, Grouping, Sections & Aggregate Functions
6.Run and Manage reports
REPORT STUDIO
1.Type of Report Templates
2.Creating list, Cross Tab, Chart, repeater, Maps & Other Reports
3.Report templates, formatting Reports – fonts, style, header, footer, boarder…etc
4.Generating and Creating Prompt Page
5.Types of Prompts
6.Query Calculations & Layout Calculations
7.Filters and Dynamic Filters
8.Conditional Block
9.Conditional Formatting
10.Master Details
11.Cascading Prompt
12.HTML Items & Hyperlinks
13.Set Operators
14.Setting Burst Options
15.Drill through
16.Drill up & Drill down
17.Setting Variables
18.Report Functions
19.Report Validation
20.Reports Run with Options
ANALYSIS STUDIO
1.Insert Data
2.Change the number of Visible Items
3.Nest Data
4.Replace Data
5.Sort Data
6.Explore Data
7.Change the measure
8.Drill down for Details
9.Hide Items
10.Insert a calculation
11.Save a custom set
12.Define a filter
13.Compare sets of data
14.Using Dynamic Context
EVENT STUDIO
1.Creating Agents
2.Adding Event conditions
3.Task and Task execution rules
4.Scheduling Agents