1.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
2. Introduction to Cognos
- About Cognos 8.4
- 3 – Tier Architecture
- Cognos Release (EP series7, Reportnet , Cognos 8.0/8,1/8.2/8.3)
- Features of Cognos 8.4
- Cognos Vs other OLAP tools
- Cognos components (Modeling & Reporting)
- Different cognos services
3.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
4.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
5.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
6.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
- Static 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 (separate course not included in this package)
7.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
8.Event Studio
- Creating Agents
- Adding Event conditions
- Task and Task execution rules
- Scheduling Agents
|
