Cognos Training in Chandigarh
Webtechlearning provide the best Congnos Training in Chandigarh. IBM Cognos software is a market leader in Business Intelligence category. Gartner rates Cognos as one of the best reporting tool in the world. IBM Cognos Business Intelligence is a DSS and performance monitoring tool helps to gather, arrange and analyze data for the various strategic planning process of an organization.
The Salient features of Cognos is
Table of Contents
- A GUI and user-friendly tool
- Provides precise and predictive level data for the organization growth
- Provides the workload balancing and fail-over
- Provides secured information on the web
- Provides right information for the right people at the right time
- Provides information to mobile devices and real-time analytics
- Provides workflow and Process
- Provides in-memory process
- Provides access to hierarchical Cube/OLAP data
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 various reporting tools include Report Studio, Query Studio, Event Studio and Business Insights .
Job Opportunities for Cogons
All Big 20 Companies riqurement for cognos…As well as India and International..
Cognos Training Syllabus in Chandigarh
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
Contact Us for Training:
WebtechLearning – Web Education Academy
SCO 54-55, 3rd Floor, Sector 34-A, Chandigarh
Mobile:09915337448, Email: webtechlearning@gmail.com
