Course Duration: 30-35 hours Training + Assignments + Actual Project Based Case Studies Training Materials: All attendees will receive, Assignment after each module, Video recording of every session Notes and study material for examples covered. Access to the Training Blog & Repository of Materials Pre-requisites: Basic Computer Skills and knowledge of IT. Who should plan on joining? Anyone who wants to start his/her career as a Cognos Developer. Anyone working on technologies which are doing not so good in the market like Mainframes, SAP, Siebel, Oracle……. Someone who has experience as Business Analyst. Fresh BE, BTech, MS students Training Format: This course is delivered as a highly interactive session, with extensive live examples. This course is Live Instructor led Online training delivered using Cisco Webex Meeting center Web and Audio Conferencing tool. Timing: Weekdays and Weekends after work hours. Course Objective: Understand What & Why of Cognos Development . Hands on experience of end-to-end application designing on Cognos Platform. Get guidance on the best practices of Cognos Business Intelligence . Training Highlights * Focus on Hands on training. * 30 hours of Assignments, Live Case Studies. * Video Recordings of sessions provided. * One Problem Statement discussed across the whole training program. * Resume prep, Interview Questions provided.

Topics Covered

Introduction to Data warehousing Introduction to Data warehousing? Introduction to Business Intelligence? Who needs Data warehousing? Why Data warehousing is required? Data warehousing Architecture Differ OLTP & OLAP? Data Mart –Need ,Advantages ETL – Process What is a Dimension? What are Facts? Star Schema? Snowflake Schema? Dimension Modeling? Slowly changing Dimensions? Conformed Dimension? Cognos 8 BI The entire Training will be on COGNOS 10 comparing with older version (Cognos 8.4) Cognos Concepts About Cognos 10 BI Architecture Cognos Suit walk through Cognos Features, Need & Importance. Cognos Connection Walk through elements on the screen Manage Folders(Public & My folders) How to Connect to different Data Source Import and Export of Package(Deployment) Set up Scheduling of Reports Frame Work Manager Introduction about Frame work Manager Workflow of Frame work Manager Designing a Project Working with Data Sources Designing and preparing Metadata Model Working With Packages Query Studio Introduction About Ad-hoc Reports Reporting using Query Studio (List, Crosstab, Chart Reports & others) Working with Data ( Applying Filters, Prompts & Calculations, Sorting, Grouping &Sections ……) New Features in Cognos 10 Business Insight Business Insight Advanced Active Reports Report Studio Overview of Cognos 8 Components & comparison with cognos10 Introduction to Report Studio Type of Report Templates Creating List, Crosstab, Chart & Others Reports Introduction to Filters(creating, editing &removing filters) Parameters & Prompts (Definition, Creating prompt Page& Usage of Multiple prompts in Reports) Formatting Reports(Fonts, styles, Header &Footers …) Types of Prompts (Select& search ,Tree, generated prompt, Date, Time……) Cognos 10 Advanced Reporting Topics Conditional Blocks – Need ,usage Conditional Formatting Complex Reports (Master Detailed, Drill Through reports) Introduction to Query Explorer (Building reports using queries, joins…) How to use HTML & JAVA scripts in Reports-Need ,Importance Import Many more Advanced Reports Other Topics Import & Export XML Reports Open Reports from XML Creating , Editing Queries Workflow of how report runs in backend. How to create portal Pages Analysis Studio About Analysis Studio Insert Data Explore Data Types of Reports Drill up & Drill down for Detail Event Studio Introduction to Event Studio Discuss Event Studio window Events, Agents, Tasks.. Real Time Scenarios & Many More……

Who should attend

About our Instructors: Our instructors are not just trainers but industry experts who are working in leading organizations and have real world experience. They all have more than 12+ years of experience in training and consulting. What if I miss a class? You needn't worry at all! We record all the sessions which conducted by Quontra Solutions and the same will be uploaded in the training blog after each session, so that you can always refer back at your own pace. How will I do the practical? You will be given assignments, case studies and training materials. You can do the practical at your own pace. How will I get support? We will be providing you the access for our training blog. Any details or any questions you can always update in the blog and the respective trainer or the training coordinator will respond to you ASAP in the training blog. Once they update in the training blog you will be notified by an instant email. What if I have doubts before or after the class? If you have doubts before the class, we can always get the trainer in a conference call and you can clarify your doubts or once in every week we conduct a FREE DEMO where your questions will be answered by our trainer. And if you have doubts after you enroll you can always ask the trainer as this is a LIVE training session and if the class gets over, you can get them cleared by updating your queries in the training blog.

Pre-requisites

Prerequisite Sql Basic Knowledge Basic C-language HTML CSS

What you need to bring

System Internet connection

Key Takeaways

Cognos Development Cognos Administration