Course Content

This instructor-led course teaches business analysts to navigate and analyse data in Analysis Studio. Participants will learn techniques such as ranking, filtering, asymmetrical crosstabs, and graphing to help them analyse large volumes of data (whether OLAP or dimensionally modelled relational metadata).

They will also learn to manage reports through Cognos Connection. Attendees will participate in hands-on demos and workshops that illustrate key concepts while learning how to use the product.

Course Modules

  • 1: Introduction to Dimensional Reporting Concepts
  • – Identify different data sources and models.
  • – Investigate the OLAP dimensional structure.
  • – Identify dimensional data items and expressions.
  • – Identify the key components for this BI development Administrator course.
  • – Have a first look at Cognos Impromptu Administrator and PowerPlay Transformer.

 

  • 2: Introduction to Dimensional Data in Reports
  • – Review Impromptu Administrator Connectivity.
  • – Connect Impromptu to Access database via ODBC.

 

  • 3: Dimensional Report Context
  • – Learn what an Impromptu Catalog is.
  • – Create a Catalog.
  • – Review Catalog components.
  • – Review Catalog content overview report.

 

  • 4: Focus Your Dimensional Data
  • – How to ADD, MOVE (cut and paste) and REMOVE Folders and Columns.
  • – How to RENAME Folders and Columns.
  • – How to use GENERATE to create reports and additional tables.
  • – Review the training Catalog Folders.

 

  • 5: Calculations and Dimensional Functions
  • – Remove Tables, limit the Tables retrieved and review Table qualification.
  • – Create ALIAS Tables.
  • – Create Joins and understand the difference
    between Inner and Outer Joins and Complex and Non-Complex Joins.

 

  • 6: Functions for Navigating Dimensional Hierarchies
  • – Work with Catalog Conditions.
  • – Work With Catalog Calculations.
  • – Work with Catalog Prompts.

 

  • 7: Relative Functions
  • – Work with user classes.
  • – Control the user environment.
  • – Manage the impact on database and network.
  • – Troubleshoot Impromptu problems.

 

  • 8: Advanced Drilling Techniques and Member Sets
  • – Learn to open and close a Catalog, and create, save and open a Basic Report.
  • – Filters.
  • – Sorting.
  • – Grouping.
  • – Summaries.
  • – Calculations and Functions.
  • – Report Formatting and Titles.

 

  • 9: Setup Drill-Through Reports
  • – Learn to open and close a Catalog, and create, save and open a Basic Report.
  • – Filters.
  • – Sorting.
  • – Grouping.
  • – Summaries.
  • – Calculations and Functions.
  • – Report Formatting and Titles.

“A wonderful course the trainer was amazing at answering any queries. She was extremely helpful and I would definitely recommend it.”

Priyanka Patel
Student Systems Development Office, University of Sussex

Who should attend?

Professional report authors.

Prerequisites

  • Knowledge of common industry standard data structures and design.

Duration

One day

Location

Simpson Associates Customer Centre/ Customer Location

Cost*

£1500
*Cost is subject to courses being run in our Azure environment. Preconfigured laptops are available for £350.

Download Resource