About this course:
Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the SAS.
Course Syllabus:
This 5 day course will give delegates a thorough study on using Cognos BI.
Day 1
Overview of IBM Cognos BI.
- Discuss IBM Cognos BI and Performance Management
- Describe IBM Cognos BI components
- Describe IBM Cognos BI architecture at a high level
- Define IBM Cognos BI groups and roles
- Explain how to extend IBM Cognos BI
Introduction to the Reporting Application
- Examine Report Studio and its interface
- Explore different report types
- Create a simple, sorted, and formatted report
- Explore how data items are added to queries
Create List Reports
- Format, group, and sort list reports
- Describe options for aggregating data
- Create a multi-fact query
- Create a report with repeated data
Focus Reports Using Filters
- Create filters to narrow the focus of reports
- Examine detail and summary filters
- Determine when to apply filters on aggregate data
Day 2
Create Crosstab Reports
- Format and sort crosstab reports
- Convert a list to a crosstab
- Create complex crosstabs using drag and drop functionality
- Create crosstabs using unrelated data items
Present Data Graphically
- Create charts containing peer and nested items
- Add context to charts
- Create and reuse custom chart palettes
- Present key data in a single dashboard report
Focus Reports Using Prompts
- Identify various prompt types
- Use parameters and prompts to focus data
- Search for prompt items
- Customize prompts to facilitate users’ choices
- Navigate between pages
- Display users’ prompt selections in the report
Extend Reports Using Calculations
- Create calculations based on data in the data source
- Add run-time information to the reports
- Create expressions using functions
Day 3
Customize Reports with Conditional Formatting
- Create multi-lingual reports
- Highlight exceptional data
- Show and hide data
- Conditionally render objects in reports
Drill-Through From One Report to Another
- Let users navigate from a specific report to a target report
- Pass parameter values to filter the data in drill-through targets
Identify Common Data Structures
- Define the metadata modeling role in IBM Cognos BI
- Identify a transactional data structure
- Distinguish between normalized and de-normalized data
- Identify a star schema data structure
- Identify common reporting traps (overview then detail slides)
- Define OLAP data structures
- Decide on the appropriate data access strategy
Gather Requirements
- Modeling recommendations overview
- Analyze BI and data requirements
- Interview and view samples
- Identify required business areas
- Work in stages (use a phased approach to importing and modeling)
Day 4
Create a Baseline Project
- What is Framework Manager?
- Define an FM project and its high level objects (namespace, data sources, packages, etc.)
- Query Subject Types (data source, model, and stored procedure)
- Define Query items.
- Examine the model in Cognos BI (what do authors see)
Prepare Reusable Metadata
- Verify and Modify Query Item Properties
- Verify Query Subject Relationships
- Ensure efficient filters by configuring prompt properties
Model for Predictable Results: Identify Reporting Issues
- Describe multi-fact queries and when full outer joins are appropriate
- Describe how IBM Cognos uses cardinality
- Identify reporting traps
- Use tools to analyze the model
Model for Predictable Results: Virtual Star Schemas
- Identify the advantages of modeling metadata as a star schema
- Model in layers
- Create aliases to avoid ambiguous joins
- Merge query subjects to create as view behavior
Model for Predictable Results: Consolidate Metadata
- Create virtual facts to simplify writing queries
- Create virtual dimensions to resolve fact-to-fact joins
- Create a consolidated modeling layer for presentation purposes
- Consolidate snowflake dimensions with model query subjects
- Simplify facts by hiding unnecessary codes
Calculations and Filters
- Use calculations to create commonly-needed query items for authors
- Use static filters to reduce the data returned
- Use macros and parameters in calculations and filters to dynamically control the data returned
Implement a Time Dimension
- Make time-based queries simple to author by implementing a time dimension
- Resolve confusion caused by multiple relationships between a time dimension and another table
- Specify Determinants
- Use determinants to specify multiple levels of granularity and prevent double-counting
Create the Presentation View
- Identify the dimensions associated with a fact table
- Identify conformed vs. non-conformed dimensions
- Create star schema groupings to provide authors with logical groupings of query subjects
- Rapidly create a model using the Model Design Accelerator
Work with Different Query Subject Types
- Identify key differences and make recommendations for using data source, model, and stored procedure query subjects
- Identify the effects on generated SQL when modifying query subjects, SQL settings and relationships
Set Security in Framework Manager
- Examine the IBM Cognos security environment
- Restrict access to packages
- Create and apply security filters
- Restrict access to objects in the model
Day 5
Identify IBM Cognos BI Architecture
- The features of the IBM Cognos BI architecture
- The three architectural tiers
- IBM Cognos BI servlets and services
- The default servlet container and alternatives to its use
- An example of IBM Cognos BI request processing
- Installation options
- Load balancing mechanisms
- Configuration options
- The IBM Cognos Application Firewall
Manage Content in IBM Cognos Administration
- Add a data source
- Distribute data and create a distribution list
- Plan a deployment
- Create deployment folders
- Export and import entries
- Identify how to maintain the IBM Cognos BI content store
- Configure saving content to the file system
- Customize the appearance of IBM Cognos BI using styles
- Use portlets to display custom Web content
Secure the IBM Cognos BI Environment
- Identify the IBM Cognos BI security model
- Define authentication in IBM Cognos BI
- Define authorization in IBM Cognos BI
- Identify security policies
- Secure the IBM Cognos BI environment
Our international certified trainers have highly experienced Cognos BI practitioners who have real-world expertise.
I – Laptops will be provided for all candidates with pre-installed Cognos.
II – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of a place on the course).
For more information on our training, please enquire using the form above or call +2348103382376