Welcome to Wings Academy

COGNOS

COGNOS

Cognos Training
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 modelling)

  •  Introduction to framework manager
  •  Framework manager basics
  •  User interface, navigation, objects
  •  Planning the project and data model, framework manager workflow
  •  Naming conventions for objects in a project
  •  Designing project
  •  Create 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 package
  •  Controlling access to metadata
  •  Explore package publish package
  •  Guideline for modelling 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
  •  Run and manage reports
  •  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 report 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

Trainer Profile of Cognos Training
Our Trainers provide complete freedom to the students, to explore the subject and learnbased on real-time examples. Our trainers help the candidates in completing their projects and even prepare them for interview questions and answers. Candidates are free to ask any questions at any time.

  •  More than 7+ Years of Experience.
  •  Strong Theoretical & Practical Knowledge.
  •  Certified Professionals with High Grade.
  •  Expert level Subject Knowledge and fully up-to-date on real-world industry applications.
  •  Trainers have Experienced on multiple real-time projects in their Industries.
  •  Our Trainers are working in multinational companies such as CTS, TCS, HCL Technologies, ZOHO, Birlasoft, IBM, Microsoft, HP, Scope, Philips Technologies etc