COURSE CONTENTS FOR Cognos
Cognos Course
Detailed Description
Ø Cognos Installation Steps, Softwares, Exercises, Training
Ø materials, Certification Dumps will be provided during the Class
Overview of Business Intelligence
Ø What is Business Intelligence
Ø Why is BI Important and where can we use it
Ø Components of BI
Ø Business Intelligence Roadmap
Overview of Data Warehousing
Ø What is Data Warehouse, Why do we need it
Ø Data Warehouse Architecture and its components
Ø Define Star Schema - Fact and Dimensions
Ø Understand OLTP and OLAP Systems
Overview of Cognos BI and Architecture
Ø Introduce Cognos BI
Ø Examine the different studios in Cognos BI
Ø Identify the different data sources within the studios
Ø Highlight key capabilities of Cognos BI
Ø Understand Cognos Multi Layered architecture
Cognos Installations and Configuration
Ø Installing Cognos
Ø Install Database (MS SQL)
Ø Install Framework Manager
Ø Install Cognos BI Application
Ø Setting up the Environment
Ø Configuring Cognos
Ø Setting up Samples in Cognos
Ø Uninstalling Cognos
Cognos BI
Administration
Ø Create and Modify a Data Source
Ø Create Database backups
Ø Understand Roles, Users and Groups
Ø Specify Permission Settings
Cognos Connection
Ø What is Cognos Connection
Ø Examine Cognos Connection UI elements – Create a URL,
Ø Login, Logoff
Ø Entry Properties: General Properties, Permissions, Report,
Ø Query, Analysis, Job, Agent and Page Properties
Ø Navigation- Public and Private Folder
Ø Open reports with Report Name, Go to Links, Run Reports from a View
Ø Run Reports- Prompt Pages, Printing a report and Open in Excel
Ø View the run history of a report and Historical Reports
Ø Closing and Creating Quick links to Reports – My Folder
Ø Shortcut and Browser Bookmark
Ø Personalize Cognos Connection
Ø Backups- Export of Cognos, Content Store or select items for Backups
Ø Restore an exported Backup
Ø Create and Customize a Page and share a single page with
Ø Multiple Users
Cognos Query Studio
Ø Introduction to Query Studio
Ø Create Reports (List, Grouped List, Crosstab, Charts)
Ø Changing the Appearance of Reports (Format)
Ø Sorting and Grouping
Ø Filters and Prompts
Ø Subtotals and Calculations
Ø Run and Manage Reports
Ø Drill Through reports
Cognos Analysis
Studio
Ø Introduction to Analysis Studio
Ø Creating a Basic Analysis
Ø Working with data in Crosstab
Ø Exploring Data
Ø Limiting Data
Ø Calculating Data
Ø Sharing Data
Cognos Report
Studio
Ø Introduction to Report Studio
Ø Report Studio User Interface
Ø Creating, Save and Run Reports
Ø Report Templates
Ø Managing Reports
Ø Types of Reports
Ø List Reports
Ø Crosstab Reports
Ø Charts
Ø Formatting a Report
Ø Report Layout Guidelines
Ø Fonts, Styles, Header, Footer and Borders
Ø Insert objects
Ø Swap Columns and Rows
Ø Working with Data
Ø Filters, Parameters and Prompts
Ø Sorting and Grouping
Ø Subtotals and Calculations
Ø Working with Queries
Ø Working with Reports
Ø Managing changes in the Package
Ø Conditional Formatting
Ø Drill-through Reports
Ø Drill-up/Drill-down Reports
Ø Master-Detail Reports
Ø Scheduling Reports
Cognos Framework
Manager (Metadata Modeling )
Ø Introduction to Framework Manager
Ø Framework Manager Basics
Ø User Interface, Navigation, Objects
Ø Planning the project and data model. Framework Manager
Ø Workflow
Ø Naming Conventions for objects in a project
Ø Designing Project
Ø Create project
Ø Importing Metadata from one and more sources
Ø Exporting Metadata
Ø Data Sources
Ø Working with Data Source Connections
Ø Create and Modify Data Sources
Ø Improve Performance by setting Query Processing Type
Ø Preparing Relational Metadata for use in Reports
Ø Verifying Relationships
Ø Working with Dimensions
Ø Working with Query Subjects- Data, Model and Stored
Ø Procedure Query Subject
Ø Working with Query Items- Set Usage and Aggregate Property
Ø Making Metadata Available to Report Authors
Ø Verify Model
Ø Set Governors
Ø Improving Performance
Ø Create or Modify Package
Ø Controlling access to Metadata
Ø Explore Package
Ø Publish Package
Ø Guideline for Modeling Metadata
Ø Best Practices – Presentation and Database layers
Ø Merge Metadata
Ø Perform Calculations and Filters
Cognos Power Play Transformer
(Power Cube Modeling)
Ø Fundamentals
Ø What is Cognos Transformer
Ø Understanding Power Play Data Sources
Ø Starting and Navigating Transformer
Ø Importing your source Data
Ø Creating your Power Cube
Ø Building the Time Dimension
Ø Create the Time Dimension Manually
Ø Building a Transformer Model
Ø Performance Considerations
Ø Build Model with AutoDesign
Ø Modify Property sheets for Dimensions, Levels and
Ø Categories
Ø Build Model without AutoDesign
Ø Create New Dimensions from Source Data
Ø Creating Exception Dimensions from Source Data
Ø Specify a Level Label
Ø Enhancing Your Model
Ø Creating Sub-Dimensions
Ø Creating Alternate Drill Paths
Ø Creating Special Categories
Ø Creating Calculated Columns
Ø Creating Multiple Query Power Cubes
Ø Adding a Query to Existing Model
Ø View Scope of a Data Source
Ø Creating a Multiple Query Model
Ø Currency Conversions and Indentify Measures that use
Ø Currency Conversions
Ø Create a Power Cube for Distribution
Ø Creating Regional Power Cubes
Ø Adding Cube Password Protection
Daily
2 hr
Interested candidates Contact:
For Online
Trainings: SHIVA- +91 80088 14567
For Further Details
Please Click Here: http://www.soasanaari.com
Note: If possible, Please
Pass This Message to Your Friends/Colleagues.
Sanaari Software Solutions Private Limited
Office : +91 40 40048283
Mobile : +91 99497 14567
Madhapur : +91 8008914567,
USA : +1 484 365 2489
Skype : Sanaari
Gtalk : shivaitonline@gmail.com
call @ 1 484 365 2489
India Number @ 91-99497 14567
WhatsApp : 91 8008814567
