Datawarehousing Cognos BI Online Training

Introduction & Overview of Cognos BI

  • Basics of Data warehouse
    • Methods
    • Difference betweeen OLAP & OLTP
    • ETL, Reporting, Analatics etc
    • Differenc between Facts, dimensions, type of schema, methodologies
    • What is Business Intelligence (BI)?
    • Why BI?
    • What is Cognos? And why Cognos?
    • Cognos BI Architecture
    • Cognos 10.2 New Features & Advantages
  • BI Applications
    • Cognos Connection, Report Studio, Query Studio, Event Studio, Analysis Studio
    • Transformers, Dynamic Cubes, Framework Manager
    • IBM Cognos Workspace
    • IBM Cognos Workspace Advanced
    • IBM Rapidly Adaptive Visualization Engine (RAVE!)
  • Installation & Configuration
    • Pre-requisits for installation
    • Minimum space and memory required
  • Introduction to Report Studio
    • The User interface
    • Basic report structure
    • Creating a basic report
    • Specify the framework package
    • Choose a report template
    • Add data to the report
    • Save report
    • Run/Execute report
    • Run with options (excel, PDF, HTML, etc)
  • Types of Reports
    • LIST
      • Properties
      • hide columns
      • Limations
      • converting List to Repeater
      • Example : mailing label
    • Cross tab
      • Properties
      • Single edge crosstab
      • nested crosstab
      • swap columns and rows
      • adding aggregated data (sum, average, etc)
    • Charts
      • Line chart
      • pie chart
      • Chart types
      • convert chart from one type to another
      • customizing chart properties
      • Drill up and drill down chart
    • Maps
      • Create Map report
      • Set Map properties
      • add colors to the region
      • add legend title
      • drill thourgh to anotehr report
      • edit map
      • additional maps
      • location intellignece
    • Other Report Studio objects
  • Assignments:1

  • Formatting a Report
    • Adding a Header or Footer
    • Table object
    • Adding Date
    • Adding Time
    • Adding Page Number
    • Insert Other Objects and properties
    • Text object
    • Image
    • Text Item
    • Block
    • Field Set
    • Query Calculation
    • Layout Calculation
    • Image
    • Bookmark
    • Align an Object
    • Apply a Table Style
    • Apply Padding
    • Set Margins
    • Add a Page
    • Reorder Columns
    • Rename a Column
  • Working with Data
    • Filter Data
    • Detailed Filters & Summary Filters
    • Sort Data & Grouping
    • Create Sections
    • Add a Summary
    • Setting Aggregation, sum, count, min, max..etc
    • Create a Calculation
    • Conditional Functions
    • IF, Else, When case statements
    • Arithmetic operations, functions
    • Format Data and its properties
  • Assignments:2

  • Prompts
    • Adding Prompts to report
    • Build Your Own Prompt and Prompt Page
    • Types of Prompts
    • Text Box Prompt
    • Value Prompt
    • Select & Search Prompt
    • Date & Time Prompt
    • Date Prompt
    • Time Prompt
    • Interval Prompt
    • Tree Prompt
  • Working with Existing Reports
    • Open and Save a Report in My folder
    • Open a Report from the Clipboard
    • Change the Package Connection
    • Adding Conditional Formatting to a Report
    • Drillthrough Access
    • Understanding Drillthrough Concepts
    • Set Up Drillthrough Access in a Report
    • MasterDetail Relationship
    • Working with Queries
    • Union Query, Intersect, Except
    • Create an query from SQL
    • Join Relationship
  • Assignments:3

  • Active Reports (advance topics)
    • Active report controls
    • Active report variables
    • Convert an Existing Report to an Active Report
    • Specify Active Report Properties
    • Summarize Data in the Active Report Output
  • Assignments:4

  • Miscellaneous Reports
    • Bursting Reports
    • Dashboards
    • Scheduling a report
    • Adding recipients in scheduled report
    • Scheduling report using prompt values
    • Scheduling set of reports
  • Assignments:5

  • Cognos Administration
    • Examine Cognos Connection
    • Creation of data Source connection at Cognos connection level
    • Creation Of Report Shortcut
    • Creation of Jobs
    • Scheduling Reports, Report shortcut, Jobs
    • Disabling Schedule
    • Organize content with folders and shortcuts
    • Personalize Cognos Connection
    • How to add portal tab
    • How to add report to portal tab
    • Connecting Report to Another Package
    • Create Users Groups and Users Roles
    • Adding Users to Users Groups
    • Importing and Exporting Reports From one Environment to Another Environment (Development Environment to production Environment )
    • Publishing native metadata into Content store
    • How to copy reports from one persons my folder to another persons my folder
    • Drill through definition
    • How to hide objects in cognos connection
    • How to view hidden object in cognos connection
    • my preferences
    • How to change my preferences
  • Query Studio
    • Working with Query Studio and its features
  • Event Studio
    • Working with Event Studio and its features
  • Assignments:6

    Framework Manager (Metadata Modelling)

  • Introduction to Framework Manager
    • Framework Manager Basics
    • User Interface, Navigation, Objects
    • Planning the project and data model
    • Naming conventions for objects in the project
  • Desiging Project
    • Creating project, Importing & Exporting Metadata
    • Working with data source connections
    • Creating and modify data sources
  • Preparing Relational Metadata for use in Reports
    • Adding relationships between data/tables
    • Working with Query subjects and Query Items
    • Adding Business Rules
    • Organizing the data model
    • Performance Tuning
  • Misc tasks in FM
    • Moving packages from one env to another env
    • Creating and Modifing Packages
    • Controlling access to Metadata
    • Explore & Publish Package
    • Guideline for Modeling Metadata & Scenarios
  • Project Work on Meta data Modelling & Assignment:7

  • Analysis Studio & Transformers
    • Analysis Studio & working with Transformers
  • Extend your analysis with Advanced cognos workspace
    • Apply conditional styles
    • Create advanced set definitions
    • Add advanced calculations
    • Group and sort data
    • Create advanced filter definitions
    • Extend reports with external data
  • Additional Topics
    • IBM Cognos Workspace
    • IBM Cognos Workspace Advanced
    • IBM Rapidly Adaptive Visualization Engine (RAVE!)
    • Project Work
    • FAQ's & Interview questions
    • Resume Preparation
    • Video's
    • Cognos Study Materials
    • Relatime project assignments