Course outline of Cognos

  • Courses offered include
  • DWH Basics
  • 1 Cognos System Administration
  • 2 Metadata Modeling Best Practices With Cognos Framework Manager
  • 3 OLAP Modeling With Cognos Transformer (Power Play Tranformer)
  • 4 Multidimensional Analysis With Cognos Analysis Studio
  • 5 Professional Authoring With Cognos Report Studio
  • 6 Dimensional Authoring With Cognos Report Studio
  • 7 Business Authoring With Cognos Query Studio
  • 8 BI Consumer Training
  • 9 Self-service Authoring with Cognos 10 Business Insight
  • 10 Cognos 10 BI Advanced Business Insight
  • 11 Authoring Cognos 10 Active Reports
  • 12 what is new In cognos 10
  • Detals of IBM Cognos 10.1
  • 1 Cognos System Administration
    • Detailed Cognos System architecture overview
    • Hardware, software and network topologies
    • Capacity planning and Scalability
    • Applications and services
    • Data flows, memory, processing and communication bandwidth implications
    • Security configuration
  • Audit logging
    • Common troubleshooting tips
    • Recommended maintenance
    • Performance Tuning
  • 2. Metadata Modeling Best Practices with Cognos Framework Manager
    • Become proficient with the Framework Manager modeling tool following a best practices
  • approach
    • Identify common data structures and reporting traps
    • Create a project and prepare metadata
    • Model for predictable results
    • Create business-friendly views of data
    • Secure metadata to allow appropriate access by users (Row-level, Object-level, and Packagelevel)
    • Create and deploy custom packages for different audiences
    • Dimensionally model relational content
  • 3. OLAP Modeling with Cognos Transformer
    • Transformer Fundamentals
    • Discuss the basics of OLAP analysis
    • Discuss the importance of business requirements
    • Review PowerPlay components
    • Review Cognos BI components
    • Define a model
  • The Transformer Development Process
    • Describe the purpose of a Transformer model plan
    • Match business requirements to the model
    • Discuss an approach for creating a Transformer model plan
    • Review the relation of the model plan to the Transformer model
  • Data Sources in Transformer
    • Identify source data
    • Discuss the types of data used by Transformer
    • Create data source files
    • Connect the data source to the model
    • Define the data source and column properties in the model
    • Preview source data and SQL
    • Maintain and synchronize data sources with the model
  • Building a Model
    • Create model structures using manual techniques and AutoDesign
    • Modify property sheets for dimensions, levels, and categories
    • Confirm the data source origin
    • Generate categories to populate the Transformer model
    • Modify the model using the dimension diagram
    • Verify the model
    • Create a default PowerCube
  • The Time Dimension
    • Discuss the purpose of a time dimension
    • Identify the specific properties of a time column
    • Define a regular time dimension
    • Discuss a nonstandard time dimension
  • Relative Time
    • Compare trends over time
    • Set the current period
    • Create relative time categories
    • Customize relative time categories
  • Use Multiple Data Sources
    • Discuss the use of multiple data sources
    • Plan the data source
    • Define data source types
    • Identify and resolve conflicts between data sources
    • Validate a multiple data source model
    • Discuss a unique move
  • Working with Measures
    • Discuss the purpose and uses of measures
    • Describe the differences between regular and calculated measures
    • Set measure properties
    • Compare rollup options
    • Create calculations before or after rollups
    • Create a category count
  • 4. Multidimensional Analysis with Cognos Analysis Studio
    • Explore the Analysis Studio interface
    • Summarize data to define exact values in a report
    • Compare data using advanced crosstab layouts
    • Analyze performance by focusing on the best or worst results
    • Limit the data that displays in a report by creating user-defined filters
    • Determine relative importance using rank calculations
    • Understand and define a custom set
  • 5. Professional Authoring with Cognos Report Studio
    • Examine Cognos Connection, personalize your portal, and manage your reporting environment
    • Explore Report Studio and different report types
    • Create and format reports using grouping, headers, footers, and other formatting options
    • Narrow the focus of reports by filtering data
    • Create interactive reports by building report prompts
    • Add value to your reports using calculations including advanced database and report functions
    • Enhance reports with advanced formatting and layout
    • Create complex reports using queries
    • Highlight exceptional data in your reports
    • Link reports to one another by setting up drill-through access
    • Understanding the query model
    • Adding and modifying elements of the query model (data items, aggregate properties, filters)
    • Creating relationships between queries ( set operations, joins, query references)
    • Authoring complex reports
    • Designing effective prompts to determine report contents and/or format at runtime
    • Create Dashboards in the Cognos Connection Portal using interactive Portal Pages
  • 6. Dimensional Authoring with Cognos Report Studio
    • Fundamental Differences between dimensional reporting and relational reporting
    • Dimensional reporting vocabulary
    • Creating basic dimensional reports
    • Understanding members, member sets, and tuples
    • Using dimensional expressions to control report context
    • Using MDX (Dimensional) functions in calculations
    • Relative and hierarchical functions
    • Controlling advanced drill-up and drill-down behavior
    • Defining report and package-level drill-through
  • 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
  • BI Consumer Training
    • Navigating in the C8 environment: running and saving reports
    • Create personal workspaces (folders, shortcuts)
    • Create personalized report views
    • Scheduling Report Studio reports
    • Saving Report Studio reports as xls, pdf, and other formats
    • View Report Studio run history
  • 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
    • 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
  • Authoring Cognos 10 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