Learn how to use Cognos from beginner level to advanced techniques which is taught by experienced working professionals. With our Cognos Training in Bangalore you’ll learn concepts in expert level with practical manner.
Cognos means “Knowledge from personal experience”. IBM Cognos Business Intelligence is a decision support system and performance monitoring tool helps to gather, arrange and analyze data for the various strategic planning process of an organization.
IBM Cognos BI provides users with many options to access information. Each option uses common functions and interfaces as follows….
- Easily view, assemble and personalize information
- Explore all types of information from all angles to assess the current business situation analyze facts and anticipate tactical and strategic implications by simply shifting from viewing to more advanced, predictive or what-if analysis
- Collaborate to establish decision networks to share insights and drive toward a collective intelligence
- Communicate and coordinate tasks to engage the right people at the right time
- Access information and take action anywhere, taking advantage of mobile devices and real-time analytics
- Integrate and link analytics in everyday work to business workflow and Process
IBM Cognos BI can report from a wide variety of data sources, both relational and dimensional. Database connections are created in the Web administration interface, and are used for modeling, for authoring, and for running the application.
The Salient features of Cognos are
- A powerful in-memory analytics server to deliver fast responses to business questions
- Flexible data access to relational, OLAP and local data sources in any combination
- A common web portal that delivers a single shared view of the business
- Tight security supporting single sign-on
- A simple management console to control installation, configuration and operation
- Mobile supported Active reports
Cognos BI Author Professional provides Report Studio, Query Studio, Event Studio and Business Insights. Cognos is a User-Friendly GUI tool. Cognos is consistently ranked top “Leader” in the Business intelligence Reporting tool Category.
-
Course Name IBM Cognos 10.1 Category Database Administration Venue Besant Technologies Official URL Cognos Training Demo Classes At Your Convenience Training Methodology 10% Theory & 90% Practical Course Duration 25 – 30 Hours Class Availability Weekdays & Weekends For Demo Class Call – +91-996 252 8293 / 94
Email ID – besanttech@gmail.com -
Cognos Training Syllabus
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 10.1 BI and Architecture
- Introduce Cognos 10.1 BI
- Examine the different studios in Cognos 10.1 BI
- Identify the different data sources within the studios
- Highlight key capabilities of Cognos 10.1 BI
- Understand Cognos multi layered architecture
Cognos 10.1 BI Administration
- Create and modify a data source
- Create database backups
- Understand roles users and groups
- Specify permission settings
Cognos 10.1 Connection
- What is Cognos connection
- Examine Cognos connection UI elements – create a URL, Login, Logoff
- Entry properties: General Properties, Permission, 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 10.1 Framework Manager (metadata modelling)
- 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 and modify package
- Controlling access to metadata
- Explore package publish package
- Guideline for modelling metadata
- Best practices – presentation and database layers
- Merge metadata
- Perform calculations and filer
Cognos 10.1 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 10.1 Analysis Studio
- Introduction to Analysis Studio
- Creating a basic analysis
- Working with data in crosstab
- Exploring data
- Limiting data
- Calculating data
- Sharing data
Cognos 10.1 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 orders
- 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