COGNOS
|
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 tools
|
INTRODUCTION 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 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
|
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
-
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
Pl contact: www.monstercourses.com
|
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.