FOR FREE DEMO contact :
 
India(M): +91-8500-122-107 ,(whats app)
Land line +919988663117 
Gtalk: raavi.sriraja@gmail.com
Email: raj@apexonlinetraining.com
WebSite:www.apexonlinetraining.com
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