Cognos Training in Chennai

Syllabus of Cognos Course in Chennai

• 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