Cognos

Reading Time: 4 minutes

Cognos

    Introduction to Data warehousing

      Module 1: Characteristics of DWH

      • OLTP Vs OLAP Databases
      • Architecture of DWH
      • Different Approaches of DWH (Kimball Vs Inmon)
      • Data mart Vs Data Warehouse
      • Fact Table Vs Dimension Table
      • Concepts of Schemas (Star schema & Snowflake schema)
      • Types of Dimensional Data Modeling
      • Data Modelling and Types
      • Logical Data Model
      • Physical Data Model
      • Onine Analytical Processing (OLAP and Types)
      • ROLAP, MOLAP, HOLAP, CUBES
      • Industry leading ETL and Reporting tools
      • BI Vendor Comparison

      Module 2: Introduction of IBM Cognos 10 BI

      • Review Corporate Performance Management
      • Introduce Cognos 10 BI Architecture
      • What is Content store,Content Manager, Dispatcher?
      • Different studios in Cognos 10 BI
      • Working with different data sources in Framework manager
      • Highlight key capabilities of Cognos 10 BI and new features
      • Cognos Architecture( Single Tier, Three Tier and Multi Tier)

      Module 3: Introduction to Framework Manager

      • Define Framework Manager and its purpose
      • Describe the Framework Manager environment
      • Examine the Cognos 10 and Framework Manager workflow processes
      • Examine the Framework Manager user interface
      • Create a project

      Module 4: Create Metadata Modelling

      • Create Data source connection
      • Create Namespaces
      • Overview of Business view and Database view
      • Overview of Presentation view
      • Create Cardinality Relationships
      • Create Model Query Subjects
      • Data source Query subjects and Query items
      • Create Determinants
      • Regular Dimension and Measure Dimension
      • Model Filters, Prompts & Calculations
      • Create Business Logic
      • Leverage user defined functions
      • Stored procedures
      • Data for mutilingual Audience
      • Create Preparing the Metadata
      • Create Creating Star Schema
      • Security level Types
      • Data level Security
      • Object Level Security
      • Package Level Security
      • Verify Objects
      • Performance Tuning
      • Create & publish Packages

      Module 5: Introduction to Query Studio

      • List the packages available for reporting
      • Examine report types
      • Add and save data to ad hoc reports
      • View data by using charts

      Module 6: Create Reports in Query Studio

      • Create list, grouped list, and crosstab reports
      • List the charts available and their appropriate use
      • Calculate and sort report data
      • Define a custom group to define your own report item
      • Drill down and drill up
      • Change rows, columns and measures
      • Sort
      • Show values as percentages
      • Manage the number of items retrieved
      • Display data graphically

      Module 7: Introduction to the Report Studio

      • Examine Report Studio and its interface
      • Explore different report types
      • Create a simple, sorted, and formatted report

      Module 8: Create List and Crosstab Reports

      • Format, group, and sort list reports
      • Format and sort crosstab reports
      • Create a report with repeated data
      • Work with dimensional data in a report

      Module 9: Present Data Graphically

      • Create charts
      • Present data using new chart type options
      • Create and reuse custom chart palettes
      • Present key data in a single dashboard report

      Module 10: Focus Reports Using Filters

      • Create filters to narrow the focus of reports
      • Determine when to apply filters on aggregate data
      • Examine source filters

      Module 11: Focus Reports Using Prompts

      • Use parameters and prompts to focus data
      • Identify various prompt types
      • Customize prompts to facilitate users’ choices
      • Search for prompt items
      • Navigate between pages

      Module 12: Design Effective Reports

      • Enhance report design
      • Add report objects to enhance design
      • Format data and report objects
      • Add a background image to a report
      • Add row numbers to a report

      Module 13: Customize Reports with Conditional Formatting

      • Create multi-lingual reports
      • Highlight exceptional data
      • Show and hide data
      • Conditionally render objects in reports

      Module 14: Analysis Studio

      • Analysis Studio Fundamentals
      • Nest Data in Crosstabs in Analysis Studio
      • Create Analysis with Multiple filter
      • Reusable analysis
      • Build Advanced Crosstabs in Analysis Studio
      • Focus with Filters in Analysis Studio
      • Creating reports from cubes
      • Drill down and drill up

      Module 15: Event Studio

      • Introduction to Event Studio
      • Create an agent
      • Add tasks to an agent
      • Run an agent through its lifecycle
      • Schedule an agent

      Module 16: Business Insight

      • Introdcution to Dashboards
      • Create Dashboard
      • Types of Filter-Value, Slider and advanced filter
      • Overview of RSS Feed and web Page
      • Content Pane
      • Create Widgets
      • Sort, Filter and Calculate data
      • Hands on

      Module 17: Business Insight Advanced

      • Overview of Business Intelligence Advance level
      • Create Different types of Reports
      • Reporting Styles and filters
      • Create dashboard objects
      • Summarize data and Create Calculations
      • Dispatcher and Services

      Module 18: Dispatcher in detail

      • All Services
      • Properties of Services