Cognos Training

Data Warehouse Introduction

• Basic Concepts of data warehousing
• Data warehouse architectures
• Some characteristics of data warehouse data
• The reconciled data layer
• Data transformation

Overview of Business Intelligence

• What is Business Intelligence
• Why is BI important and where can we use it
• Components of BI
• Business Intelligence Roadmap

Overview of Data Warehousing

• What is Data warehouse, why do we need it
• Data warehouse architecture and its components
• Define star schema – fact and dimensions
• Understand OLTP and OLAP Systems

Overview of Cognos 10.1 BI and Architecture

• Introduce Cognos 10.1 BI
• Examine the different studios in Cognos 10.1 BI
• Identify the different data sources within the studios
• Highlight key capabilities of Cognos 10.1 BI
• Understand Cognos multi-layered architecture

Cognos 10.1 BI Administration

• Create and modify a data source
• Create database backups
• Understand roles users and groups
• Specify permission settings

Cognos 10.1 Connection

• What is Cognos connection
• Examine Cognos connection UI elements – create a URL, Login, Logoff
• Entry properties: General Properties, Permission, Report, Query, Analysis, Job, Agent and Page Properties
• Navigation – Public and Private Folder
• Open reports with report name, Go to links, Run reports from a view
• Run Reports – Prompt Pages, Printing a report and Open in Excel
• View the run history of a report and historical reports
• Closing and creating quick links to reports – my folder
• Shortcut and browser bookmark
• Personalize Cognos connection
• Backups – Export of Cognos
• Content store or select items for backups
• Restore an exported backup
• Create and customize a page and share a single page with multiple users

Cognos 10.1 Framework Manager (metadata modeling)

• Introduction to framework manager
• Framework manager basics
• The user interface, navigation, objects
• Planning the project and data model, framework manager workflow
• Naming conventions for objects in a project
• Designing project
• Create a project
• Importing metadata from one and more sources
• Exporting metadata
• Data sources
• Working with data source connections
• Create and modify data sources
• Improve performance by setting query processing type
• Preparing relational metadata for use in reports
• Verifying relationships
• Working with dimensions
• Working with query
• Subjects – data, model and stored procedure query subject
• Working with query items- set usage and aggregate property
• Making metadata available to report authors
• Verify model
• Set governors
• Improving performance
• Create and modify a package
• Controlling access to metadata
• Explore package publish package
• Guideline for modeling metadata
• Best practices – presentation and database layers
• Merge metadata
• Perform calculations and filer

Cognos 10.1 Query Studio

• Introduction to query studio
• Create reports (List, Grouped List, Crosstab, Charts)
• Changing the appearance of reports (Format)
• Sorting and grouping
• Filters and prompts
• Subtotals and calculations
• Drill through reports

Cognos 10.1 Analysis Studio

• Introduction to Analysis Studio
• Creating a basic analysis
• Working with data in crosstab
• Exploring data
• Limiting data
• Calculating data
• Sharing data

Cognos 10.1 Report Studio

• Introduction to reporting studio
• Report studio user interface
• Creating, save and run reports
• Report templates
• Managing reports
• Types of reports
• List reports
• Crosstab reports charts
• Formatting a report
• Report layout guidelines
• Fonts, styles, header, footer, and orders
• Insert objects
• Swap columns and rows
• Working with data
• Filters, parameters, and prompts
• Sorting and grouping
• Subtotals and calculations
• Working with queries
• Working with reports
• Managing changes in the package
• Conditional formatting
• Drill-through reports
• Drill-up / drill-down reports
• Master-detail reports
• Scheduling reports