1 / 9

Mining the Data Warehouse from Chapter 6.2

Mining the Data Warehouse from Chapter 6.2. Anna Thomas BCIS 340 Fall 2009. Ben & Jerry’s. Company is obsessed with quality of their products Uses Oracle database and Business Intelligence software from Business Objects to track the ingredients and life of each pint.

drago
Download Presentation

Mining the Data Warehouse from Chapter 6.2

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. Mining the Data Warehouse from Chapter 6.2 Anna Thomas BCIS 340 Fall 2009

  2. Ben & Jerry’s • Company is obsessed with quality of their products • Uses Oracle database and Business Intelligence software from Business Objects to track the ingredients and life of each pint.

  3. Ben & Jerry’s BI tools allowed them to access, analyze, and act on information collected from customers • They can determine which milk customers prefer in the making of the products. • Gather comments on ingredients used in ice-cream and also to social causes supported by the company. The technology helped track more than 12,500 consumer contacts in 2005.

  4. California Pizza Kitchen • Founded in 1985, now has 130 restaurants in 26 States, the District of Columbia and 5 foreign countries. • Before using it’s BI tool, CPK would use spreadsheets to plan and track it’s financial statements and line items • Issues: 1. It took several weeks of 2 people working full-time to obtain one version of the financial statement and future forecast 2. Their current software was unable to link cells and calculations across multiple spreadsheets With their BI tool, Cognos, CPK reduced quarterly forecasting cycles from eight to two days.

  5. Noodles & Company • Throughout nine states has over 70 restaurants. • Like CPK, uses Cognos BI to implement reporting standards and communicate real-time operational information to field management throughout the U.S.

  6. Before Cognos, IT and finance professionals spent days compiling report requests from numerous departments • Now Cognos… • Saves the company time and money • Provides daily access to operational reports through the company’s website • Allows users a 360° view of the business • Provides consistent reporting throughout the enterprise

  7. QUESTION 1: Which company used BI technology to help track over 12,500 consumer contacts in 2005? • Ben & Jerry’s • California Pizza Kitchen • Noodles & Company Answer: a. Ben & Jerry’s

  8. QUESTION 2: What type of BI system does both CPK and Noodles & Company use? • Oracle • Teflon • Icon • Cognos Answer: d. Cognos

  9. DISCUSSION QUESTION • What other types of company issues do you think BI tools could help resolve?

More Related