COGNOS HANDS-ON ONLINE TRAINING,CORPORATE TRAINING BY REALTIME IT EXPERTS FROM INDIA | JOB SUPPORT

Post# A558868 · boston, Kansas · Posted by: raj

IBM COGNOS BI TOOL HANDS-ON LIVE ONLINE TRAINING,CORPORATE TRAINING,INTERVIEW & JOB SUPPORT BY SOFTWARE REALTIME TRAINERS

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

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

Course Content (we can customize the course agenda as per your requirements)

COGNOS-BI REPORTING TOOL Course Outline

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.


  1. Different Studios in Cognos
    • Query Studio
    • Report Studio
    • Event Studio
    • Analysis Studio
    • Metric Studio
    • Powerplay Studios
    • Business Insight
    • Dashboard

  2. 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

  3. 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

  4. 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

  5. Event Studio
    • Creating Agents
    • Adding Event conditions
    • Task and Task **** rules
    • Scheduling Agents
    • Complete flow of Event studio.

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

  7. Cognos Administration
    • Application Administration
    • System Administration
    • Server Administration
    • Trouble Shooting

  8. 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

  9. System Administration
    • Performance Tuning
    • Access permissions
    • Create and manage portals
    • Logging levels

  10. Server Administration
    • Re Booting server
    • Unix/window environment
    • Log Analysis
    • Core Analysis
    • BIB Analysis

  11. Trouble Shooting
    • Resolve the different issues
    • Diff error codes in Cognos
    • Log Analysis

  12. Installations
    • Components used by Cognos 8.4/10
    • Server Components
    • Modeling Components
    • Installing Cognos8.4
    • Uninstalling Cognos8.
    • Installing/Uninstalling Cognos10
    • Single Network/Distributed Network

  13. Cognos 10.2.1
    Report Enhancements
    • Dash Boards
    • Enhancement in Framework manager
    • Interface Change
    • Lotus notes configurations
    • Working with External datasource.

  14. Cognos Testing/Migration
    • Overview
    • Project Architecture
    • Unit Testing
    • SIT/UAT testing
    • Test cases
    • Working with Issues

  15. Cognos Testing/Migration
    • Overview
    • Project Architecture
    • Unit Testing
    • SIT/UAT testing
    • Dev/SIT/UAT/Prod
    • Test cases
    • Working with Issues

  16. BPM Applications : -


    1. Citrix,VPN,Remote connection


  17. Toad, Sql analyzer,Sharepont.

  18. Unix/Putty/Win sap/Aix

  19. Windows client/Server Os

  20. BMC Remedy,QC,CTLM,Espresso.

  21. IBM Lifecycle Manager

  22. 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


    1. Workspace :
      • Create Dashboard
      • Addition of a easy resize to fit option
      • Add reports to Dashboard
      • Customize the dashboard appearance


  23. 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



FOR More Details contact us at:
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

Type
Offer
Contract type
Permanent
Name
sri raja
Phone number
8500122107

Contact this User

It is NOT ok to contact this poster with commercial interests.
Reply to
[email protected]