Data Technologies

Home » Data Technologies

IBM Cognos Training

    Introduction to Data Warehouse
    Data Warehouse Concepts
    ETL Concepts


Overview of Cognos 10 BI

    Introduce Cognos 10 BI
    Examine the different studios in Cognos 10 BI
    Identify the different data sources within the studios

Cognos 10BI Installations and Configuration

    Components used by Cognos 10
    Server Components
    Modeling Components
    Installing Cognos 10
    Uninstalling Cognos 10

Cognos 10 BI Architecture and Planning

    Multi-tire architecture

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

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
    dd 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

Cognos System Administration

    Capacity planning and Scalability
    Applications and services
    Data flows, memory, processing and communication bandwidth implications
    Security configuration
    Common troubleshooting tips
    Recommended maintenance
    Performance Tuning

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

Course Content

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

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

  5. 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 mode
      Modify the model using the dimension diagram 
      Verify the model 
      Create a default PowerCube

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

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

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

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

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 Package-level)
    Create and deploy custom packages for different audiences
    Dimensionally model relational content
In addition to the training, we provide material to prepare you for the interviews, assist you in building your resume & final placements. If you are interested in our training program, please call us at 734.377.6007 or email us at Include a word copy of your resume.