150 likes | 331 Views
Quontra Solutions is a best platform for Online Training Classes with Experienced faculty. We Provide HD Quality Video after each session and our training are managed very professionally. Cognos is IBM's business intelligence (BI) and performance management software suite. The software is designed to enable business users without technical knowledge to extract corporate data, analyze it and assemble reports. List of topics covered during training: Introduction to Data Warehoue, Cognos-10 comparing with older versions, Cognos Connections, Framework Manager, Query Studio and etc…….
E N D
Contact info: Call:44 (0)20 3734 1498 / 99 Mail: info@quontrasolutions.co.uk
What is Cognos? • Web Based Reporting Tool-Zero foot print( has a few client based components like Office plug-in) • Allows user to create, modify, and distribute reports to user community. • Allows user to schedule and burst reports • We are licensed to run a few Cognos products of which these will be heavily used based on the User Role: • Query Studio – allow you to create simple list reports, for casual or novice users • Report Studio – allows you to create more complex reports (prompts, advanced formatting, advanced charting, etc) • Analysis Studio- multi dimensional analysis. • Interfaces with the ODS/EDW system
Cognos Process Flow Presentation Layer Client Model Tools-Develop Models & Publish Content as Packages ODS/ED/Other Data Sources
Demo • Quick exploration of Query Studio and ( time permitting-Report Studio)
A list of recently used packages Additional packages
Toolbar contains most commonly used functions • Main menu contains menu options and all functions
Insert Data • Select data from package Edit Data • Change display of query items Change Layout • Edit properties of your report Run Report • Processing or preview data • Export data in various formats Manage File • Create and save report and view a report definition
Query Subject - A single table that holds multiple Query Items • Query Item - A field in the Query Subject table (Entity UID, ID, Name, etc.) • Measure – Quantitative data such as revenue or quantity
Insert • Single-click a query item and click the Insert button • Double-click a query item • Click and drag a query item • Click and drag a query subject to add all of its query items CTRL+Click to select multiple items
Meet the Undo Button!!! • Undo the last several things you’ve done • Redo available
Data Element Dictionary • Helpful resource available to users • Structure mirrors data package hierarchy • Data Packages = highest level of data organization • Query Subjects (equivalent to database table) • Query Items (equivalent to database field)