Cognos Traning:

Course content: IBM Cognos 10 BI

Course duration: 30 Hours

Classes: Classroom Training / Online Training

Data Warehouse Fundamentals:

Unit 1: Basic of Data Warehouse

  • An introduction to Data Warehousing
  • Purpose of Data Warehouse
  • Characteristics of DWH
  • Data Warehouse Life cycle
  • Data Warehouse Architecture
  • Different Approaches of DWH (Kimball Vs Inmon)
  • Operational Data Store
  • OLTP Vs OLAP Databases
  • OLTP Vs Warehouse Applications
  • Data Marts
  • Data marts Vs Data Warehouses
  • Fact Table Vs Dimension Table
  • Concepts of Schemas (Star schema & Snowflake schema)
  • Industry leading ETL and Reporting tools

Unit 2: Cognos Administration:

  • Introduction to IBM Cognos 8 BI Administration
  • Manage Scheduled Activities (Past, Present and Future)
  • Manage Content in IBM Cognos Administration
  • Manage content in IBM Cognos Connection
  • Create and Manage Drill through Definitions
  • How to connect to different Data Sources
  • How to provide security to the Package
  • Import and Export of Package (Deployment)
  • Report migration from one version to Other Version (Eg 8.4 to 10.1)
  • Security Maintenance by using Groups, Roles and Capabilities.
  • Creating Port let Page,URL,Multipage Dashboards
  • End-to-end Workshops

Unit 3: Cognos Framework Manager:

  • About Framework Manager
  • Creation of Interface and Usage
  • Creating Model & Namespace (Layers)
  • Importing Metadata
  • Creating Query Subjects & Query Items
  • Merging Query Subjects
  • Creating Relationships & Setting Cardinalities
  • Creating Parameter Maps & Macros
  • Usage of Session Parameters
  • Creation of Model Filters, Prompts & Calculations
  • Creating Package & Security Settings
  • Creating Multidimensional Package
  • Multi-developer environment (Segmenting and linking& Branching and Merging)
  • Synchronize Projects
  • Framework Manager Repository Control
  • Add Business Rules and Set Governors
  • Publishing Package
  • Performance Improvement Tips
  • Creation of Multilingual Metadata

Unit 4: Query Studio:

  • Business Authoring with Cognos Query Studio
  • Create ad hoc reports in Query Studio
  • Add data to existing ad hoc reports
  • Customize ad hoc reports
  • View ad hoc reports in different formats
  • Create ad hoc reports with filters and calculations
  • Create ad hoc charts and crosstabs
  • Create ad hoc exception reports
  • Define custom groups

Unit 5: Report Studio:

  • Type of Report Templates
  • 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
  • Filters and Dynamic Filters
  • 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

Unit 6: Analysis Studio:

  • Create agents
  • Use parameters and calculations
  • Add tasks (email, report, database update, agent)
  • Manage task execution rules
  • Reset the event list
  • Run an agent
  • Schedule an agent
  • Cognos 10 New tasks: Approval, Notification tasks

Unit 7: Transformer:

  • Discuss the basics of OLAP analysis
  • Review Transformer capabilities and its role in IBM Cognos 10 BI
  • Discuss Transformer components
  • Define categories and members
  • Using multiple Data sources in Transformer
  • Define the regular,Time,Measure dimensions
  • Creation of Signons
  • Building the Powercubes
  • Creation special,Manual categories
  • Defining security by using custom views
  • Drill thru creation
  • Time based partition cubes

Unit 8: Cognos 10 New features:

  • Active Reports:
  • Discuss the value of Active Reports
  • Examine an Active Report and its controls
  • Convert an existing report to an Active Report
  • Debug and save an Active Report
  • Explore interactive properties
  • Use filter and select in Active Reports
  • Examine decks and cards
  • Examine master-detail relationships and decks
  • Use advanced features with Active Reports
  • Drill up and down on an Active Report
  • Create cascading prompts in an Active Report
  • Business In sight:
  • Self-service Authoring with Cognos 10 Business Insight
  • Introduction to Business Insight
  • Leverage pre-existing content in a Business Insight dashboard
  • Modify content using basic Business Insight functionality:
  • Sorting output
  • Suppress and filter data
  • Control display properties
  • Add formatting
  • Add basic calculations
  • Business Insight Advance:
  • Extend your analysis with Advanced Business Insight functionality:
  • Apply conditional styles
  • Create advanced set definitions
  • Add advanced calculations
  • Group and sort data
  • Create advanced filter definitions
  • Extend reports with external data
  • And Many more Concepts……………