Curriculam

• • • 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

• • • 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)

• • • 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

• • • 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

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

• • • 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

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

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

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

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

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

• • • 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

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

• • • 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

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

• • • 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

• • • 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

• • All Services
  • Properties of Services