Welcomes to eworldclasses - Data Warehousing - Cognos

HOME

ABOUT US

SERVICES

REGISTRATION

COURSES

ENQUIRY

PAYMENT

CONTACT US

LOGIN

Courses

SAP Technical

SAP Functional

SAP New Dimensional

Microsoft Technologies

Oracle

Testing Tools

Middleware Technologies

Siebel

Administration

Adobe Flex 3.0

Mainframes

Course :	Data Warehousing	Duration : 30 Hrs
Sub Course :	Cognos
Course Content :	Course Description
	This course is designed to introduce the basics and advance of Cognos. Students will learn a variety of techniques to retrieve and modify information from databases, and to generate complex and customized reports. This course is also offered interview questions and Reports which we will use in Real time. Course Objective Upon completion of the course, students will be able to: Write reports using Cognos® Modeling activities can be done by using FWM Can create reports using sorting and grouping Can create List,crosstab,chart and Map reports Can create reports with drill through and Master detail relationship Display information in a concise format using cross tab reports Select data to be printed using filters and different kinds of prompts Create and customize several types of charts Can create complex(Real time) reports with conditions, Variables and dynamic calculations Customize the format of a report in HTML and Excel. Course Audience Report Authors Course Prerequisites Experience with Windows and a Web browser Course Topics Overview What is data warehouse? What is cognos? Versions in cognos and differences Components in cognos Query studio Report studio Analysis studio Event studio Metric studio Various Components in Query studio What is Query studio? Query studio : Simple list Reports Groped list Reports Sections Cross tab Reports Charts. Page breaks Report Studio: Simple List Report Grouped List Report(1 to n) Grouped List Report - Level Span (1 to 1) Advanced List Report Merging the data cells Report with Conditional Formatting List Report - Master data Detail Relationship List report with Drill through Links Report with Various types of filters Detailed filter Summary filter Dynamic filtering` Cascading prompts - single and Auto submit Cascading prompt - multi select and reprompt button List Report with the value prompt List report with select and search prompt List Report - calculations Design list report with headers and footers Display a list for each country on Separate page Explaining about all prompts Scheduling a repot with Run with options Cross tab reports and types of cross tab reports Design a Nested cross tab reports Reports with repeater table such as mailing labels or address - Slips Dashboard reports Pivot list to cross tab Convert list to repeater Burst Report Analysis studio Basic Cross tab report Nested Cross tab Cross tab with different calculations Cross tab with Context filter Reports with Page layers Creating custom sets Top and bottom count of reports Different kinds of Graph Reports Graph Reports with calculations Data formatting in the reports Aggregation functions Cognos Connection Public Folders and My Folders Creating and Editing Data source connection Performing import and export operations Scheduling reports Create a job for a group of reports with sequential scheduling or Parallel scheduling Creating report view Framework Manager Creating Project Creating Data source connection Importing data from different sources like oracle and SQL Creating namespaces Creating namespaces Creating relations between tables in FWM Creating calculations Publishing Packages and nested packages Creating IQDs Creating Regular dimensions Edit definitions Define security at package level Define function sets Session parameters, Parameter maps Model testing