IBM Cognos BI Hands-On Online Training By Realtime Certified Experts

IBM Cognos Certification Training makes you expert Cognos BI, shares data-driven insights in a governed environment, cognos framework manager, cognos report studio, query studio, cognos analytics, create compelling reports and dashboards etc.



FOR FREE DEMO contact :

Email : raj@apex-online-it-training.com

Phone/WhatsApp : +91-(850) 012-2107

USA Number : 214-628-3894

Gtalk : raavi.sriraja@gmail.com

Blog: http://apex-it-online-trainings.blogspot.in


IBM Cognos BI Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided

COGNOS COURSE CONTENT

(the course agenda can be modified as per your requirements):


1.Introduction to Dataware Housing (DWH)

  • Introduction to DWH
  • Characteristics of DWH
  • OLTP Vs OLAP Databases
  • DWH Architecture
  • Different Approaches of DWH (Kimball Vs Inmon)
  • Data mart Vs Data Warehouse
  • Fact Table Vs Dimension Table
  • Dimension Modeling
  • Concepts of Schemas (Star schema & Snowflake schema)

2. ETL Tools

  • Code based
  • GUI Based

3. Reporting Tools

  • Overview about the diff Reporting Tools
    1. SAP-BO
    2. Hyperion
    3. MS BI
    4. OBIEE

4. Introduction to Cognos

  • About Cognos 8.4 /10.1
  • 3 – Tier Architecture
  • Cognos Release (EP series7, Reportnet , Cognos 8.0/8,1/8.2/8.3)
  • Features of Cognos 8.4 /10.1
  • Features of Cognos 10.0/10.1
  • Advantage/Disadvantage of Cognos
  • Cognos Vs other OLAP tools
  • Cognos components (Modeling & Reporting)
  • Different cognos services

5. Framework Manager

  • About Framework Manager
  • Framework Manager, Metadata Modeling
  • Creation of Interface and Usage
  • Creating Model & Namespace (Layers)
  • Importing Metadata
  • Naming convention for objects in a project
  • Creating Query Subjects & Query Items
  • Merging Query Subjects
  • Creating Relationships & Setting Cardinalities
  • Creating Parameter Maps & Macros
  • Creating of Model Filters, Prompts & Calculations
  • Add Business Rules and Set Governors
  • Working with different layers
  • Assigning package level security
  • Improving performance
  • Publishing Package
  • DMR Modeling
  • Creation of Measures/Regular dimensions
  • Determinants

6. Transformer Manager

. Creation of IQD/CSV,Tab files through FM

. Creation of Cube with Package/report etc.

. Apply relationships and calculations

. Cube Creation and Update.

. Working with cubes in Both windows and Unix environments

. Resolving the issues with Cube refresh.

7. Different Studios in Cognos

  • Query Studio
  • Report Studio
  • Event Studio
  • Analysis Studio
  • Metric Studio
  • Powerplay Studios
  • Business Insight
  • Dashboard

8. Query Studio

  • Introduction
  • About Ad-hoc Reports
  • Types of Report(List, Cross Tab, Chart Reports & Others)
  • Applying Filters, Prompts & Calculations
  • Sorting, Grouping, Sections & Aggregate Functions
  • Run and Manage reports

9. Report Studio

  • Introduction to Report Studio
  • Report Studio User Interface
  • Type of Report Templates
  • Types of Reports
  • Creating list, Cross Tab, Chart, repeater, Maps & Other Reports
  • Report templates, formatting Reports – fonts, style, header, footer, boarder…etc
  • Generating and Creating Prompt Page
  • Types of Prompts
  • Query Calculations & Layout Calculations
  • Static Filters and Dynamic Filters (prompts )
  • Working with Queries
  • Conditional Block
  • Conditional Formatting
  • Master Details
  • Cascading Prompt
  • HTML Items & Hyperlinks
  • Set Operators
  • Setting Burst Options
  • Drill through
  • Drill up & Drill down
  • Setting Variables
  • Report Functions
  • Report Validation
  • Reports Run with Options
  • Scheduling Reports

10. Analysis Studio

  • Insert Data
  • Change the number of Visible Items
  • Nest Data
  • Replace Data
  • Sort Data
  • Explore Data
  • Change the measure
  • Drill down for Details
  • Hide Items
  • Insert a calculation
  • Save a custom set
  • Define a filter
  • Compare sets of data
  • Using Dynamic Context

11. Event Studio

  • Creating Agents
  • Adding Event conditions
  • Task and Task execution rules
  • Scheduling Agents
  • Complete flow of Event studio.

12. Powerplay Studio

  • Represents the Cube Data
  • Working with charts and Calculation
  • Creation and Maintenance of Powerplay reports.

13. Cognos Administration

  • Application Administration
  • System Administration
  • Server Administration
  • Trouble Shooting

14. Application Administration

· Personalize cognos connection

· Create and manage portals, shortcuts, report views, etc

· Working with cognos configuration, content store

· How to connect to different data sources

· Security setup

· Access permissions

· Import and Export of package(Deployment)

· Running the Report Burn

· Scheduling Reports

15. System Administration

· Performance Tuning

· Access permissions

· Create and manage portals

· Logging levels

16. Server Administration

· Re Booting server

· Unix/window environment

· Log Analysis

· Core Analysis

· BIB Analysis

17. Trouble Shooting

· Resolve the different issues

· Diff error codes in Cognos

· Log Analysis

18. Installations

· Components used by Cognos 8.4/10

· Server Components

· Modeling Components

· Installing Cognos8.4

· Uninstalling Cognos8.

· Installing/Uninstalling Cognos10

· Single Network/Distributed Network

19. Cognos 10.2.1

Report Enhancements

· Dash Boards

· Enhancement in Framework manager

· Interface Change

· Lotus notes configurations

· Working with External datasource.

20. Cognos Testing/Migration

· Overview

· Project Architecture

· Unit Testing

· SIT/UAT testing

· Test cases

· Working with Issues

21. Cognos Testing/Migration

· Overview

· Project Architecture

· Unit Testing

· SIT/UAT testing

· Dev/SIT/UAT/Prod

· Test cases

· Working with Issues

22. BPM Applications : -

1. Citrix,VPN,Remote connection

2. Toad, Sql analyzer,Sharepont.

3. Unix/Putty/Win sap/Aix

4. Windows client/Server Os

5. BMC Remedy,QC,CTLM,Espresso.

6. IBM Lifecycle Manager

23. Cognos 10.2.1

· Fresh New Look

· Data Visualization

· Big Data

· Platform Improvements

· Enhanced Multi-tenancy Support

· Overall Performance Improvement

· Enhanced Report Output Archiving

· Deployment of “My Folders”

· Support for Additional Hadoop Platforms

· Support for New Analytic Data Sources

· In-Memory Analytics

Dynamic Cubes, the powerful in-memory analytics solution that came about with Cognos 10.2

· Self-Service

24. Workspace :

· Create Dashboard

· Addition of a easy resize to fit option

· Add reports to Dashboard

· Customize the dashboard appearance

25. Advanced Workspace :

· Sort and Group reports in Dashboard

· Filtering on multiple related data items in select value filter

and slider filter widgets

· Tabbed workspaces

· Share custom sets between reports for easy reuse. This was a feature of analysis studio that may have kept some users from migrating to Cognos Workspace Advanced in the past.

· Ability to easily show values as percentage of total.

· Simplified custom grouping

· Enhanced crosstab headers

· Automatic group and summary behavior for lists