DTecH Cognos BI training covers Introduction to IBM Cognos BI 10.2 tool, Cognos Dashboards, Cognos Framework Manager, Cognos Connection(Admin) , Cognos Query Studio, Cognos Report Studio , Cognos Event Studio Cognos Analysis Studio

Topics Covered

SQL Basics ========== Joins Views Sub queries Set Operators Aggregate Functions Datawarehousing Concepts =================== OLTP Vs OLAP Data warehouse Architecture Data warehouse Vs Data Mart ETL Masures, Fact, Dimensions Schema Star Schema and Snowflake Schema Dimension Hierarchy Aggregates Aggregation Strategy, Compression Ratio Indexing Strategy Slowly Changing Dimension Type 1 Type 2 Type 3 Performance Tuning IBM Cognos 10.2 BI =============== Introduction to IBM Cognos BI 10.2 Overview of IBM Cognos 10.2 BI and Its Components Understand the Business Requirements Identify and Study the Common Data Structure IBM Cognos Framework Manager (Metadata Modeling) ======================== Introduction to IBM Cognos Framework Manager (FM) Design Cognos FM Project Working with Data Sources Understand the Model Layers Prepare Metadata for use in BI Reports Understand the Different Query Subject Types Specify determinants Work with Query Calculations and filters Working with Regular Dimensions and Measure Dimensions Prepare Presentation Layer Understand Star Schema Grouping Making Metadata Available to Report Authors Understand the SQL generated by Cognos Cognos Connection =============== Explore the Cognos Connection Run and View Reports Customize Report outputs by using report views Schedule Reports Customize the Cognos Connection Cognos Query Studio ================ Introduction Query Studio How to Open the Web Portal Create Reports and Report Types Save and Run Report Formatting Reports Swapping Rows and Columns Filter, Sorting, Grouping, Calculations Create Drill Through Definitions Open Report in Report Studio Cognos Report Studio ================= Introduction to Report Studio Types Of Reports Exploring Report Studio Explorers Create and Format Reports Working with Report Queries Working with Filters, Parameters Types of Prompts Cascaded Prompts Create Prompt Page for a Report Drill-up/Drill-down Reports Master Detail Reports Drill Through Reports Understand Query Calculation Understand Layout Calculation Available Report Functions Understand the Report Variables Conditional Formatting Various Report Output Formats Cognos Analysis Studio ================= Introduction to Analysis Studio Create Basic Analysis Report Working with data in Crosstab Nesting Rows or Columns Swapping Rows and Columns Display Type Creation of Charts, Types

Who should attend

Without technical knowledge to extract corporate data, analyze it and assemble reports. Without technical knowledge you can learn IBM Cognos.

Pre-requisites

Basic computer skills Basic Database knowledge

What you need to bring

If you have personal laptop to practice the tool.

Key Takeaways

Cognos is basically a Business Intelligence Tool which enables you to explore and interact with any data, in any combination and spanning the entire spectrum of time