Enquiry Now !      

IBM Cognos Training in Pune - Technogeeks, IBM Cognos Institutes in Pune, Cognos Classes in Pune.
    DURATION OF TRAINING : 10 WEEKENDS
     
    SYLLABUS
     
    Data warehousing Basic Concepts

    Introduction to data warehousing
    Difference Between OLTP Vs OLAP
    What dimensional modeling ?
    What is dimension ?
    What is fact ?
    Types of schemas in data warehousing
    Star Schema
    Snow flake Schema
    Hybrid Schema
    Slowly changing dimension
    Types of Slowly Changing dimensions
    ·         SCD I
    ·         SCD II
    ·         SCD III
    What is confirmed dimensions ?
    Fact less fact table and types of Facts
     
    Framework Manager
     
    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
     
    Gather requirements
     
    ·         Examine key modeling recommendations
    ·         Define reporting requirements
    ·         Explore data sources to identify data access strategies
     
    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
     
    Prepare reusable metadata
     
    ·         Verify the relationships and query item properties
     
    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
     
    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 behaviour
     
    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
     
     
    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
     
    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 a star schema groupings to provide authors with logical groupings of query subjects
    ·         Rapidly create a model using the Model Design Accelerator
     
    Report Studio
     
    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
     
     
    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
     
     
    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
     
    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
     
    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
     
    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
     
    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
     
    Implement Master Detail relationship
     
    Analysis Studio
     
    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
     
    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
     
     
     
    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
     
    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
     
    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
     
    Extend the analysis
    ·         Apply summary calculations
    ·         Apply item based calculations
    ·         Practice ranking items
    ·         Demonstrate how to customize the report display
     
    Query Studio
     
    Introduction to query studio
    ·         Examine query studio
    ·         Open adhoc reports
    ·         Add data to adhoc reports
    ·         Examine report types
    ·         Examine charting
     
    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
     
    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
    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
     
    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
     
    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
     
    Introduction to transformer
    Purpose of transformer
    Difference b/w  transformer model Vs Framework Manager Model
    Explore the transformer interface
    How to refresh the cube
    How to publish the cube in cognos connection
    ·         Active Reports
    ·         Introduction to Dash boarding
    ·         Deck and Data Deck
    ·         Static Prompts
    ·         Dynamic Prompts
ibm cognos
ibm cognos


Enquiry Now !