IBM Cognos BI Online Training

 

Data warehousing Basic Concepts

1. Introduction to data warehousing
2. Difference Between OLTP Vs OLAP
3. What dimensional modeling ?
4. What is dimension ?
5. What is fact ?
6. Types of schemas in data warehousing

• Star Schema
• Snow flake Schema
• Hybrid Schema

7.  What is slowly changing dimension ? Types of Slowly Changing dimensions ?

• SCD I
• SCD II
• SCD III

8. What is confirmed dimensions ?

9. What is fact less fact table ? and types of Facts

Framework Manager

1. Overview of IBM Cognos BI

• Describe IBM Cognos 10 BI Components
• Describe IBM Cognos 10 BI Architecture at a high level
• Define IBM Cognos 10 Groups and Roles

2. Gather requirements

• Examine key modeling recommendations
• Define reporting requirements
• Explore data sources to identify data access strategies

3. Create a baseline project

• Examine the IBM Cognos 10 and Framework Manager work flow processes
• Define a project and its structure
• Describe the Framework Manager Environment
• Create a baseline project
• Enhance the model with additional metadata

4. Prepare reusable metadata

• Verify the relationships and query item properties

5. Identify Reporting Issues

• Describe multi-fact queries and full outer joins are appropriate
• Describe how IBM Cognos 10 uses cardinality
• Identify reporting traps
• Use tools to analyze the model

6. Virtual Star Schemas

• Identify the advantages of modeling metadata as a star schema
• Model in layers
• Create aliases to avoid ambiguous joins
• Merge the query subjects to create as view behavior

7. Consolidate metadata

• Create virtual facts to simplify writing queries
• Create a 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

8. Calculations & 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

9. Implement a time dimension

10. Specify Determinants

• Use determinants to specify multiple levels of granularity and prevent double counting

11. Create the presentation view

• Identify the dimensions associated with a fact table
• Identify Conformed Vs non conformed dimensions
• Create a star schema groupings to provide authors with logical groupings of query subjects
• Rapidly create a model using the Model Design Accelerator

Report Studio

1. Introduction to reporting application

• Examine report studio and its interface
• Explore report types
• Create a simple , sorted, and formatted report
• Explore how data items are added to queries

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

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

4. Create crosstab reports

• Format and sort crosstab reports
• Convert a list to a crosstab
• Create a complex crosstabs using drag and drop functionality
• Create crosstabs using unrelated data items

5. Present data graphically

• Create charts containing peer and nested columns
• Present data using new chart type options
• Add context to charts
• Create and reuse custom chart palettes
• Present key data in a single dashboard report

6. Focuses reports using prompts

• Identify various prompt types
• Use parameters and prompts to focus data
• Search for prompt types
• Customize prompts to facilitate users choices
• Navigate between pages
• Display users prompt selections in the report
• Implement casting prompts

7. Extend reports using Calculations

• Create calculations based on data in the data source
• Add runtime information to the reports
• Create expressions  using functions
• Discusses report templates
• Add pages to a report
• Choose options to handle reports with no available data

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

9. Implement Master Detail relationship 

Analysis Studio

1. Analysis studio fundaments

• Define the fundamental terms  of analysis studio
• Explain how to insert objects
• Define & create sets
• Identify the work area, overview area, and properties pane

2. Tools for investigation in analysis studio

• Employ drilling down and up to different levels of detail
• Apply changes to rows, columns, and measures in the analysis
• Explain how to change the display of data
• Use charts to display data graphically

3. Nest data in crosstabs in analysis studio

• Apply depth to rows and columns by nesting data
• Recognize drill behavior in nested rows and columns
• Demonstrate how to swap nested levels

4. Build advanced crosstabs in analysis studio

• Demonstrate how to view a complete level of data
• Design a crosstab without retrieving data
• Compare multiple measures
• Apply stacked sets to the crosstab
• Construct an asymmetrical crosstab
• Compose a custom sort

5. Focus with filters in analysis studio

• Apply filters using expressions
• Apply filters using context area
• Create top and bottom lists
• Use several techniques to remove rows and columns

6. Extend the analysis

• Apply summary calculations
• Apply item based calculations
• Practice ranking items
• Demonstrate how to customize the report display

Query Studio

1. Introduction to query studio

• Examine query studio
• Open adhoc reports
• Add data to adhoc reports
• Examine report types
• Examine charting

2. Create reports in query studio

• Create list, grouped list, and crosstab reports
• Use prompts to specify filter criteria
• Create custom groups
• Format data
• Calculate and sort report data

3. Explore and modify reports in query studio

• Run a report in query studio
• Explore run options
• Render reports in HTML, PDF, and CSV format
• Format report elements
• Create report views
• View report outputs 

Business Insight

1. Explore, Navigate, and create dashboards

• Business Scenario
• What is business insight
• Examine Business Insight interface
• Dashboard content
• Define widgets
• Add report content to dashboard
• Align and rearrange widgets in the dashboard
• Add tools to dashboard 

Business Insight Advanced

1. Examine Business Insight Advanced

• Business Scenario
• What is business insight advanced
• Explore the user interface
• Design the report layout
• View your data
• Define the report layout

2. Create a report

• Business Scenario
• Goal of reporting
• List Report Example
• Crosstab Report Format
• Crosstab Example
• Chart Report format
• Basic Chart Types
• Pie Chart Example
• Column Chart Example
• Scatter chart Example
• Financial Reports
• Combination Reports
• Same data with multiple business cases
• Create a calculation
• Calculation Example 

Transformer

1. Introduction to transformer
2. Purpose of transformer
3. Difference b/w  transformer model Vs Framework Manager Model
4. Explore the transformer interface
5. How to refresh the cube
6. How to publish the cube in cognos connection

• Active Reports

• Introduction to Dash boarding

• Deck and Data Deck

• Static Prompts

• Dynamic Prompts