1 / 32

COGNOS INC.

COGNOS INC. Eddie Haizlip Danny Roach Greg Sparks. Background. Founded in 1969. Offices in 14 countries. Corporate Offices in Ottawa, Canada Sales Headquarters in Burlington, Mass. 1300 Employees Worldwide. History. Designed custom information systems in the 70’s and early 80’s.

fiachra
Download Presentation

COGNOS INC.

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. COGNOS INC. Eddie Haizlip Danny Roach Greg Sparks

  2. Background • Founded in 1969. • Offices in 14 countries. • Corporate Offices in Ottawa, Canada • Sales Headquarters in Burlington, Mass. • 1300 Employees Worldwide

  3. History • Designed custom information systems in the 70’s and early 80’s. • PowerHouse 4GL rolled out in the early 80’s. • Took leadership position in application tools in proprietary mid-range computers. • In client/server environment, Cognos rolled out PowerPlay, their first BI solution.

  4. Today • One million seats in a thousand companies. • BI solutions support over 100 OLAP data sources. • Can intergrate many enterprise applications • Examples: Oracle Financials PeopleSoft SAP

  5. Software Categories Business Intelligence Impromtu PowerPlay Scenario 4Thought

  6. Software Categories Web-based BI PwerPlay Enterprise Server Impromptu Web Reports Impromptu Web Query DataMerchant

  7. Software Categories 4GL Tools PowerHouse 4GL Axiant Power2000

  8. Visualizer • Management and measurement tool • Extends PowerPlay and Impromptu • Advanced reporting and analysis • Graphs multiple data dimensions • Graphs geographical data

  9. Data Example • Large amounts of data in succinct visual reports and virtual rooms of information. • www.cognos.com/visualizer/walk6.html

  10. NovaView • Cognos’ OLAP client • Uses SQL Server 7.0 OLAP services • Bought from Panorama Software Systems

  11. COGNOSuite • Suite of integrated products for turning data into knowledge • Includes three key components • PowerPlay • Scenario • Impromptu

  12. PowerPlay • Industry-leading OLAP solution • Utilizes Analyze-then-Query approach to data analysis

  13. PowerPlay Features • Drill down capabilities • Ability to slice and dice for flexible presentation • Analyze trends over time • Visualize data graphically • Drill through to details or other cubes

  14. Scenario • Data-mining component of the suite • Identifies relationship among factors • Allows drill down to supporting factors for a selected factor • Inverse is also true - Scenario will identify those factors which don’t impact a given factor • Combined - this means better decisions

  15. Scenario Practical Uses • Classification according to key factors • Market segmentation • Customer profiling • Areas of focus • Targeted strategies

  16. Impromptu • Used for ad-hoc reports • From scratch or based on canned reports • No SQL needed (drag and drop)

  17. Advantages of Impromptu • Frees up IS resources • Empowers the user • Results in the right data in the right hands • Raises overall effectiveness of the user through more informed decision-making

  18. COGNOS in Action Solutions and Case Studies

  19. Challenges Faced • IT environments include many different systems, that are not integrated • IT departments are impeded by labor-intensive reporting • Managers do not have timely access to business information.

  20. Benefits of Business IntelligenceSoftware • Users can easily explore and analyze all the business information they need • IT staff is no longer tied up with time-intensive report processing • Improved decision-making processes has led to increased revenues.

  21. Cognos Success Stories • Avon Products, Inc. • The Timken Company

  22. Avon Products Inc. • Founded in 1886 • The world’s largest direct seller of beauty products • $5.1 billion annual revenues • 2.7 million independent sales reps. • Markets over 400 brands • 135 countries

  23. Business Process Redesign • Redesign began in 1996 • Avon chose Cognos line of Business Intelligence (BI) products: • PowerPlay - quickly and easily explore multi-dimensional information and create OLAP reports • Impromptu - ad hoc querying of data and access to transaction-level information

  24. Avon’s Succes Story • Reduced cost by streamlining their analysis and reporting processes • For example, printing and distribution costs • Credits Cognos BI solutions to the $250 million increase in revenue, due to the improved decision making processes.

  25. Future Plans • Installation of PowerPlay Enterprise Server • Incorporates the Web • Lowers overall cost of business intelligence system because the cubes are built once and are accessible from all users of the system. • Gives all users of the BI a common front end • Able to extend the benefits of the system to their global operations.

  26. The Timken Company • Established in 1898 • Headquartered in Canton, Ohio • Produces tapered roller bearings • Offers a selection of more than 200 types and 30,000 sizes • These bearings are used by every major manufacturing industry worldwide

  27. System Needs • Began implementation in 1996 • Needed a new job costing system (JCS) • Costing is difficult because Timken’s products are made to order. • Under the old system, product cost rates were updated once a year based on averages gathered from production history.

  28. New Job Costing System • Chose Cognos Impromptu and PowerPlay • Impromptu for generating reports • PowerPlay to track sales and costs by district, type of product, size of product, and where the product originated from.

  29. Benefits of New System • The finance, sales, and marketing departments are able to accurately track and set product costs. • Results in fairer pricing for all their customers • Using the drill-down features they are able to analyze cost detail to an activity level for any customer order.

  30. Data Cubes • Using PowerPlay’s OLAP tool, Timken integrates the data from the JCS into a data cube • Compare and track the product cost versus the profitability • Cost has in excess of 100,000 rows • Profitability involves more than 1 million rows

  31. Future Goals • Expand the system to implement the Web for faster decision making capabilities • In the process of implementing the Web-versions of Impromptu and PowerPlay

  32. Thanks for your time

More Related