COGNOS TM1 Training in OMR Chennai

COGNOS 10.1 BI CERTIFICATIONS

Cognos certification training is a series of courses and seminars offered by IBM, the owner and creator of the Cognos program. Completing such training and obtaining the certification provides many benefits for the information technology professional.

• Cognos 10 Administrator (COG 622)
• Cognos 10 BI_Author (COG 612)
• Cognos 10 BI_Multidimensional_Developer (COG 645)
• Cognos 10 BI_OLAP_Developer (COG 635)
• Cognos 10 Metadata_Model_Developer (COG 632)
• Cognos BI Professional (COG 180)

Cognos training in Chennai – Real time project training by working Professional

IBM COGNOS BI Course Content:

COGNOS TM1 COURSE CONTENT

INTRODUCTION TO DATAWARE HOUSING (DWH)

• Describe IBM Cognos Business Intelligence (BI) and Financial Performance Management (FPM)
• Introduction to DWH
• Characteristics of DWH
• OLTP Vs OLAP Databases
• Different Approaches of DWH (Kimball Vs Inmon)
• Data mart Vs Data Warehouse
• Fact Table Vs Dimension Table
• Types Of Facts
• Types Of Dimensions
• ETL
• Staging Area
• Concepts of Schemas (Star schema & Snowflake schema)
• Surrogate Key
• Slowly Changing Dimension Types
• Industry leading ETL and Reporting tools

INTRODUCTION TO COGNOS

• About Cognos 10.1
• 3 – Tier Cognos 10.1 Architecture
• Cognos Release (EP series7, Reportnet , Cognos 8.0/8.1/8.2/8.3) and their differences
• New Features of Cognos 10.1
• Cognos Vs other OLAP tools
• Cognos components (Modeling & Reporting)
• Different cognos services

IBM COGNOS BI ARCHITECTURE

• Identify features of the IBM Cognos BI architecture
• Explain the Dispatcher and Cognos BI servlets and services
• Identify an example of Cognos BI request processing
• Examine the Cognos Application Firewall
• Content Manager and Content Store
• Perform a distributed installation and configuration of IBM Cognos BI

COGNOS CONNECTIONS

• Personalize Cognos Connection
• Create and manage portals, shortcuts, report views..etc
• Running the Report Burn
• Various Options in Cognos Connection
• Working with Cognos configuration, content Store
• How to Connect to different Data Sources
• Security setup
• Properties of an Entry
• Search for an Entry
• Bookmark an Entry

• Import and Export of Package (Deployment)
• Scheduling and manage reports
• Create Jobs
• Cognos groups and roles
• Cognos Business Insight Advanced

QUERY STUDIO

• Introduction
• Features in Query Studio
• About Ad-hoc Reports
• Types of Report(List, Cross Tab, Chart Reports & Others)
• Applying Filters, Prompts & Calculations
• Sorting, Grouping, Sections & Aggregate Functions
• Apply page break on Reports
• Run and Manage reports
  • Define custom group
  • Conditional formatting
  • Expand and Collapse groups
  • Apply Swap and Rows on Reports

REPORT STUDIO

• Report Studio User Interface
• Creating, Save and run reports
• Managing Reports.
• Creating list, Cross Tab, Chart, repeater, Maps & Other Reports
• Group and section on List report having 1:M relationship
• Group span on List report having 1:1 relationship
• Apply page break on reports.
• Headers and Footers on Crosstab report
• Report templates, formatting Reports – fonts, style, header, footer, boarder…etc
• Filters, Parameters and Prompts
• Subtotals and Calculations
• Working with Queries
• Generating and Creating Prompt Page
• Format Data
• Map Report,Repeater objects
• Types of Prompts
• Types of Variables
• Layout Component Reference to reuse the objects
• Building the Cube Reports
• Building the Dashboard Reports
• Query Calculations & Layout Calculations
• Filters and Dynamic Filters
• Conditional Block
• Conditional Formatting
• Master Details Relationship reports
• Cascading Prompt
• Set Operators
• Setting Burst Options
• Drill through reports
• HTML Items & Hyperlinks
• Drill up & Drill down
• Setting Variables
• Report Functions
• Report Validation
• Bookmark
• Bursting
• Reports Run with Options
• Different types of Reports with various functionalities
• Unions
• Joins
• Components and there properties.

ANALYSIS STUDIO

• Insert Data
• Change the number of Visible Items
• Analyze data using Analysis Studio
• Nest Data
• Replace Data
• Sort Data
• Explore Data
• Change the measure
• Drill up & Drill down on reports
• Drill down for Details
• Hide Items
• Insert a calculation
• Save a custom set
• Define a filter
• Compare sets of data
• Using Dynamic Context

EVENT STUDIO

• Creating Agents
• Adding Event conditions
• Task and Task execution rules
• Scheduling Agents

METRIC STUDIO

• Identify scorecards, metrics, and metric types
• Organize metrics with strategies
• Track initiatives with projects
• View metric history
• Address problems with actions
• Monitor status visually with diagrams
• Verify metric details
• Quickly access important metrics
• Create a scorecard
• Create metrics
• Enter metric values
• Customize Metric Studio
• Report on Metric Studio data

FRAMEWORK MANAGER

• About Framework Manager
• Framework Manager, Metadata Modeling
• Creation of Interface and Usage
• Create a Project
  • Creating the data source connection

• Creating Model & Namespace (Layers)
• Importing Metadata
  • Work with dimensions and Modify properties of Query Items
  • Naming convention for objects in a project

• Creating Query Subjects & Query Items
• Merging Query Subjects
• Creating Relationships & Setting Cardinalities
• Creating Parameter Maps & Macros
• Creating of Model Filters, Prompts & Calculations
• Parameter Map
• Loop
• Usage property, regular aggregate properties
• Add Business Rules and Set Governors
• Assigning package level security,Object Level security and Data Level security
• Improving performance
• Describe Transformer capabilities and its role in IBM Cognos BI
• Describe Transformer components
• Organize the model
• Publishing Package

DASHBOARDS in IBM Cognos BI

• Describe IBM Cognos Business Insight
• Explore navigation and general functionality
• Create a dashboard from existing content
• Modify an existing dashboard
• Collaborate on a dashboard

Extend IBM Cognos BI

• Describe IBM Cognos Go Mobile
• Explain IBM Cognos for Microsoft Office

INTRODUCTION TO POWERPLAY TRANSFORMER CUBES

• Cognos 10 Cube Creation using Transformer
• Different aspects of cognos cube
• Different aspects of cognos cube
• Levels, categories, dimension and measures in Transformer
• Viewing the cube data in Powerplay reports

COGNOS BI ADMINISTRATION

• Describe the role of the Administrator in relation to the IBM Cognos BI administration workflow process
  • Describe the role of IBM Cognos Administration and IBM Cognos Configuration user interface components
  • Manage dispatchers and services
  • Tune server performance
  • Identify issues while troubleshooting the server environment
  • Formulate the IBM Cognos BI backup strategy
  • Configure IBM Cognos for Microsoft Office
  • Manage user profiles

• Enable users to navigate to related data in IBM Cognos BI

COGNOS TM1

• Review financial performance management
• Describe the architecture and components of TM1

Create Dimensions

• Review cubes and dimensions
• Create dimensions manually
• Edit dimensions
• Create dimensions using Turbo Integrator

Build Cubes and Views

• Discuss cubes and data points
• Create cubes
• Construct views of data in cubes
• Create and use a pick list

Load and Maintain Data

• Create processes to load data
• Create a process to delete data in a cube
• Create processes to update the model

Add Business Rules

• Discuss a rule
• Construct rules for elements or consolidations
• Use functions in rules
• Optimize rule performance
• Discuss rules in a Rule Worksheet

Optimize Rule Performance

• Optimize rule performance
• Use Skipcheck and Feeders
• Employ tools to enhance rules and feeders

Transfer Data into Your Model Using Scripts

• Review Advanced tabs in Turbo Integrator
• Add a subset to a dimension
• Use logic in scripts
• Move data between versions
• Construct chores

Customize Drill Paths

• Create a Drill Process
• Create a Drill Assignment Rule

Using Rules for Advanced Modeling

• Discuss virtual cubes
• List uses for lookup cubes
• Create and use a spread profile cube
• Move data between versions
• Implement moving balances in a cube

Convert Currencies

• Discuss currency challenges
• Create currency dimension
• Create currency cube
• Create rules for currency conversion

Model for Different Fiscal Requirements

• Discuss time considerations
• Use discrete time dimensions
• Implement a continuous time dimension model

Introduction to Managed Planning Applications

• Review the purposes and benefits of a managed planning application
• Review supported platforms

Contribute Data to Managed Planning Applications

• Access a Managed Planning Applications
• Identify user roles and workflow states
• Enter data using shortcuts and spreading
• Submit and reject data

Best COGNOS TM1 Training In Chennai When you train with us, you can be assured that this is your passport to the global IT world. Our training programs are designed to help you develop practical and technical skills that will make you a full-fledged IT professional. Our main focus is to provide individual training and corporate training in Data Warehouse and Business Intelligence tools like, Informatica, Datastage, Microsoft SQL Server BI, MicroStrategy, OBIEE, Oracle Data Integrator, Cognos and Business Objects.

Over the course every trainee will be generating 120 + reports of various utilities and features of cognos.

Every trainee will be creating a powercube and publishing and packaging it.

COGNOS 10 TRAINING

Some of the courses we deliver in Cognos 10 are as follows –

• Overview of Business Intelligence
• Overview of Data Warehousing
• New Features of Cognos 10
• Overview of Cognos 10 BI and Architecture
• Cognos 10 Installations and Configuration
• Cognos 10 Connection Administration
• Cognos 10 BI Administration
• Cognos 10 Report Studio
• Cognos 10 Event Studio
• Cognos 10 Metric Studio
• Cognos 10 Query Studio
• Cognos 10 Analysis Studio
• Cognos 10 Framework Manager
• Cognos 10 PowerPlay Tranformer Cubes
• Cognos 10 Drill Through Definitions
• Cognos 10 Active Reporting (Exclusivelly new feature in Cognos 10.1)
• Cognos 10 Business Insight Advance (CWA)

Courses can be customized according to client needs.

For other ETL – BI Tools like

• Informatica
• OBIEE
• MicroStrategy
• Oracle Data Integrator
• Datastage
• Teradata
• Microsoft SQL Server Business Intelligence (MSBI)

Our Cognos courses cover Powerplay to administration to Report Studio, Metrics Manager, Query studio, TM 1 etc whilst each session is tailored to your client needs.

AMONG SOME OF THE COURSES WE OFFER IN COGNOS ARE-

Cognos 8 BI Migrate from Series 7 Powerplay:
The course educates about the Powerplay web & client applications It also teaches about how to migrate powerplay applications and how to administer new and migrated applications.

Cognos 8 BI Administration:
This course teaches new administrators the important responsibilities of administering servers and content. It will enable them to implement security, and manage the server components. Participants will also be able to schedule tasks, manage & deploy content; set up package based drill-through access.

Cognos 8 BI Data Manager – Building Datamarts with Enterprise Data:
The course teaches how to move, merge, consolidate, & transform data from a range of data sources to build, maintain subject-area data marts. Participants will learn to create a catalog and add connections to data sources and targets. They shall also learn to deliver fact and dimension data to a data mart through the use of builds and the dimensional framework and also learn how to automate common functionality and handle complex data issues, such as unbalanced hierarchical structures.

Cognos 8 BI Authoring and Modelling Fast Track:
This course is technical overview, it covers standard content in an accelerated and appended format. This will provide accelerated training on authoring and modeling and covers report creation in query studio and report studio, data analysis using analysis studio, model building using framework manager & reporting environment administration.

Cognos 8 BI Framework Manager – Designing Metadata Models:
This course provides knowledge of metadata modeling concepts for predictable reporting and analysis results using framework manager. They will learn the entire metadata modeling process, from initial project creation, to publishing of metadata to the web.

Cognos 8 BI Metadata Modelling Part 2:
This course provides knowledge on how to model metadata with framework manager using modeling recommendations as a modeling strategy. They shall learn the generic modeling structures and techniques, and the basic modeling concepts and naming conventions in the framework manager environment.

Cognos 8 BI Authoring and Modelling Fast Track:
This course is technical overview, it covers standard content in an accelerated and appended format. This will provide accelerated training on authoring and modeling and covers report creation in query studio and report studio, data analysis using analysis studio, model building using framework manager & reporting environment administration.

Cognos 8 BI Analysis Studio – Analysing Data:
The course teaches business analysts to navigate & analyse data in analysis studio. They will discover trends, identify opportunities, and learn how to make better business decisions. Participants will also learn techniques such as filtering, ranking, asymmetrical cross tabs, & graphing to help them analyse large data.

Cognos 8 BI Powerplay Administration:
This course teaches participants how to administer powerplay applications. It shall enable them to identify the components and architecture, set server properties, schedule, monitor, log, and audit powerplay activities, set cube and report properties, and set security.

Cognos 8 BI Powerplay Client – Explore and Build Reports:
This course is designed to help participants with the skills needed to analyse business data and create reports in powerplay client. They will learn how to drill through cube data, replace categories and measures in a crosstab, change the display to view the data in one of several graphical formats, format each display to enhance their analysis, sort, rank, and filter data, and create calculations. They shall also learn to create reports, how to build a report crosstab, perform and add calculations, use advanced nesting functions, create subsets, and distribute reports.

Cognos 8 BI Powerplay Studio – Web Exploration:
The course is designed to teach participants the basic skills they need to view, explore, format and distribute powerplay reports using powerplay studio. They will learn to create reports, view multidimensional cube data, add calculations, and use graphical displays. It also covers drag and drop within crosstabs, ranking, custom subsets and scenario dimensions.

Cognos 8 BI Report Studio – Authoring Professional Reports Fundamentals:
The course is designed for professional report authors who wish to learn report building techniques using relational data models, and ways of enhancing, customising, and managing professional reports.

Cognos 8 BI Report Studio – Authoring Professional Reports Advanced:
The course is designed for professional report authors who wish to learn advanced report building techniques using relational data models, and ways of enhancing, customising, and distributing professional reports.

Cognos 8 BI Report Studio – Authoring Reports with Multidimensional Data:
This course enables participants to build on their experience with report studio by applying dimensional techniques to reports. Participants shall learn how to author reports that navigate and manipulate dimensional data structures using specific dimensional functions and features available in Report Studio.

Cognos 8 BI Query Studio – Building Ad Hoc Reports:
The course is designed for business authors, who want to learn how to create, modify and organise ad hoc reports. It shall cover the following topics: how to use different report capabilities, how to graphically display the data, and how to create reports with a consistent look and feel through the use of templates. It also teaches basic administrative tasks, such as scheduling reports and delivering reports in different formats like HTML, PDF, Excel and so on.

Cognos 8 BI Query Studio – Building Ad Hoc Reports:
The course is designed for business authors, who want to learn how to create, modify and organise ad hoc reports. It shall cover the following topics: how to use different report capabilities, how to graphically display the data, and how to create reports with a consistent look and feel through the use of templates. It also teaches basic administrative tasks, such as scheduling reports and delivering reports in different formats like HTML, PDF, Excel and so on.

Cognos 8 BI Report Authoring Part 2:
The course is designed for professional report authors. They shall learn advanced techniques for creating, modifying, and distribution professional reports using report studio. They will also learn to examine and create query models, burst reports, examine and edit XML report specifications, author advanced reports, manage the task execution rules, create a schedule for an agent, and work with agents.

Cognos 8 BI Reporting and Analyzing Data for Business Authors:
This course teaches how to create, modify, and manage ad hoc reports. Participants will learn how to create and publish statement style reports using multidimensional data. They will also learn how to navigate and analyse multidimensional data.

Cognos 8 BI Authoring and Modelling Fast Track:
The course is a high level, technical overview that covers standard content in an accelerated and appended format. It provides accelerated training on authoring and modeling and covers report creation in query studio and report studio, data analysis using analysis studio, model building using framework manager and reporting environment administration.

Cognos 8 BI Metrics Manager – Designing Scorecards:
This course teaches participants how to plan, create, set up, and maintain scorecard applications. They will learn to load data from supported data sources using metric designer and to use alternative data loading methods such as flat files and SQL scripts. Participants will also learn how to secure objects within the scorecard application and the application itself.

Cognos 8 BI Server Administration:
The course provides practical skills on administering the server environment. Participants will learn about the server administrator workflow processes, architecture, security implementation, managing the server components, and setting up office connection.

Cognos 8 BI Transformer – Designing OLAP Models:
The course teaches OLAP modelers how to design, build, and maintain power cubes. It also teaches about the key concepts and also about how to use the product.

Cognos 8 BI Essentials for Project Management:
This course teaches how to move, merge, consolidate, and transform data from a range of data sources to build and maintain subject-area data marts. Managers will learn to create a catalog and add connections to data sources and targets. They shall also learn to deliver fact and dimension data to a data mart through the use of builds and the dimensional framework and will also learn about how to automate common functionality and handle complex data issues, such as unbalanced hierarchical structures.

Want to learn more about Cognos 10.2 The Greens Technology BI Group is now offering a 1-day class room course that covers everything new in Cognos 10.2. Do you have questions about upgrading to version 10.2, or would like to better understand where these new features and technologies complement and enhance your organizations overall Business Intelligence strategy? Are you considering Dynamic Cubes and would like to know more about design and development best practices, or environment sizing recommendations? Contact Us for more information or to speak with one of our veteran consultants today.

COGNOS TM1 TRAINING IN CHENNAI

We are the best COGNOS TM1 Training Institute in Chennai. Buy providing COGNOS TM1 Training in Chennai we are educating all of our students in complete topics. Our trainers are well experienced experts and we are limiting the batch size to give better knowledge to all the students.

We are the best Cognos TM1 Training Institute by maintaining excellency in course syllabus comparing to any other institutes in Chennai. Cognos is the leading supplier of business intelligence solutions that optimize the efficiency of the world’s most successful and largest organizations. Business intelligence is a category of technologies and applications for assembling, analyzing, storing, reporting on, and giving access to data to facilitate enterprise users take superior business decisions. It’s the prime developer of business intelligence software. They are biggest dealer of tools of business intelligence globally, and the company name is acknowledged as a leader in the field of BI reporting. This BI tool constantly adds direct context to business-driving details, supporting decisions and building enterprises further agile. It contributes to more than 17,000 clients in 121 countries worldwide.

JASPERSOFT BI DEVELOPER CORPORATE TRAINING IN CHENNAI

Jaspersoft BI is one of the leading BI tools in the industry. Jaspersoft BI developer training covers the basics of DW&BI, Jaspersoft Connection, different studios like, Query Studio, Report Studio, Advanced Report Studio, Analysis Studio and Event Studio. It also covers Business Insight that includes building and managing dashboards. The modeling tool, Framework Manager is covered extensively to train the participants on how to prepare and build objects and metadata to be used in reports.

JASPERSOFT TRAINING COURSE CONTENT

DATAWAREHOUSING CONCEPTS

• What is DWH?
• Characteristics of Datawarehouse
• Difference between OLTP and DWH
• Architecture of DWH
• Various BI tools
• Types of DWH
• Types of Dimensional Data Modeling
• Surrogate key
• Types of Dimension

DW & BI BASIC CONCEPTS

• RDMBS Introduction
• DW Architecture
• Star Schema
• Snowflake Schema
• Conceptual Data Model
• Logical Data Model
• Physical Data Model
• Data Mart
• OLAP, MOLAP, ROLAP
• Cubes
• BI Uses
• Dimensional Model
• Fact Tables
• Lookup Tables
• Hierarchy
• Jaspersoft Vs Other BI Tools
• BI Vendor Comparison

JASPERSOFT COURSE OUTLINE

• Course OutlineIntroduction to BI.
• Introduction to Dimensional Modeling
• Introduction to report design using jaspersoft ireport Designer
• Report life cycle
• Installing Ireports and Jasperserver
• Developing Reports with ireport designer.
• Navigation Ireport
• Create Expressions
• Working with data sets
• Working with charts
• Working with Chart Themes
• Work with groups
• Use styles and fonts
• Incorporate sub datasets
• Export and preview reports
• Passing paDinesheters inside the report
• Working with sub reports
• Deploying reports to server and working with Jasper repository
• Administration of Jasper server – sharing reports, scheduling reports, email, etc.
• Jaspersoft OLAP (Cubes) :
• OLAP Basics
• Creating cubes and cubes deployment
• Understanding MDX.