Cognos Training

Syllabus of Cognos Course

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

Cognos Training Course Highlights

1) Our Training Center batch sizes are generally very small size 3-5 members OR 1 to 1 also, so students receive direct, hands-on training from us.

2) 100% practical training only. It is not a slide show training program / theory class program. 

3) At the end of this class, definitely you will refer your colleagues / friends / relatives for our training.

4) Conducting regularly online Cognos training for US peoples in all time zones (PST,CST,EST,HST,MST)

5) Installation of Softwares in your desktop / laptop will be done.

6) Will be provided self evaluation testing software, exam simulator, dumps & books with this training.

7) Continuous support is provided for any of your on-site problems. Assistance will be provided and you will be recommended to some of IT development firms.

Why Enroll with IICT for Cognos Training Course ?

1) Two days free trial - If candidate likes this course, these days are adjusted in his actual schedule.

2) Live Project Exposure of Fortune companies.

3) Training by Subject Matter experts from CMM Level 5 companies

4) Both Online and Classroom Training offered at Cognos

5) Our basic course worth more than the advanced course of other institutes/freelancers.

6) Free Interview preparations.

7) 100% free assistance for Cognos certifications.

8) Practical and Hands on Training for Cognos Course .

9) 100 % guarantee in succeeding the certification at affordable fees.

10) Also provide online training to students of foreign countries.

Cognos Trainer Profile

• More than 10+ Years of Experience.
• Trained more than 5000+ students in a year.
• Strong Theoretical & Practical Knowledge.
• Cognos Certified Professionals with High Grade.
• Well connected with Hiring HRs in multinational companies.
• 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

Cognos Placement Training

• More than 5000+ students Trained
• 2000+ students Placed
• 1100+ Interviews Organaized
• Strong Theoretical & Practical Knowledge
• Cognos certified Professionals