Premium Essay

Data Warehousing at Rei: Understanding the Customer

In:

Submitted By nadaalhosani
Words 566
Pages 3
Management Information Systems 14e
KENNETH C. LAUDON AND JANE P. LAUDON

CHAPTER 6
CASE 2

SUMMARY
URL

CASE

FOUNDATIONS OF BUSINESS INTELLIGENCE: DATABASES AND INFORMATION
MANAGEMENT

Data Warehousing at REI: Understanding the Customer

REI uses IBM data warehousing technology to achieve its vision of understanding what its customers want, and how they want to interact with the company. L= 4:39. http://www.youtube.com/watch?v=4KEkA3O784s Systems

REI (Recreational Equipment Inc.) is an American consumers’ cooperative that sells outdoor recreation gear and sporting goods via the Internet, catalogs, and over 120 stores in 29 states. It opens six to eight new stores each year. Its major competitors in the U.S. include many other sporting goods retailers. REI is the largest consumer co-op in the United States.
A consumer’s cooperative is a business owned by its customers for their mutual benefit.
The goal of a co-op is to sell quality goods and services at the lowest cost to its consumers, as opposed to the traditional model of selling goods and services at the highest cost that consumers are willing to pay. However, a co-op is no different from traditional firms in the following regard: databases and information management still play key roles in efficiency and strong customer service and are critical to the company’s bottom line.
There is a one-time fee of $20 for lifetime membership to REI. The company normally pays an annual dividend check to its members equal to 10% of what they spent at REI on regularpriced merchandise in the prior year, although this is not guaranteed. The refund, which expires on December 31 two years from the date of issue, can be used as credit for further

continued

CHAPTER 6, CASE 2 DATA WAREHOUSING AT REI: UNDERSTANDING THE CUSTOMER

2

purchases or taken as cash or check between July 1 and

Similar Documents

Premium Essay

Data Warehousing at Rei - Understanding the Customer

...· REI? Recreational Equipment Inc. is a consumers“ cooperative specializing in the sale of sporting goods and outdoor equipment. 1. What is a data warehouse and why is REI building one? · A data warehouse is a process for storing and analyzing data. · This system allows organization to collect large amounts of data from its many different parts. · This data can then be converted to information used to help satisfy customer needs and wants. 2. What are some of the disadvantages of consumer cooperatives compared to ‘traditional’ firms? · Members rarely benefit from company’s financial success. · All member are allowed to help manage the company. · Ultimately, Coops aren’t as profitable as traditional firms. 3. Describe some of the marketing strategies that REI’s data warehouse will allow it to use. Would these have been possible before the data warehouse was built? · After buying a certain product (such as a snowboard), REI can then send emails or advertisements pertaining to that particular product to the customer (snowboard accessories, snowboard places nearby, etc.) · When searching for products on REI’s website, the data warehouse is able to analyze what items are viewed and send advertisements to the person viewing the items regarding discounts or events about those items. · When REI holds events for certain sports, equipment, or products, REI uses the list of attendees to send them advertisment surrounding the event. 4. What are some of the risks or concerns...

Words: 348 - Pages: 2

Premium Essay

Hello

...To better understand why REI decided to work with IMB’s data warehouse technology, I think we need to understand what exactly IBM’s DB2 9 (data base 2 and also known as “Viper”) does with its software. IBM’s DB2 9 software can be utilized through Linux, UNIX (AIX, Solaris, and HP-UX), Windows, Mac OS, i5/OS, and z/OS. It is an enterprise –class data server that delivers hybrid data management for XML data and relational data in the same data base. It offers state of the art security as well. Viper brings huge advancements in the mainframe that allows queries at a rapid speed and provides consumers access to information without constraints. This allows a less need for system administration saving money in the future. Ambuj Goyal (GM of IBM of Information Management stated, “DB2 9 Viper for z/OS marks a significant milestone in the database software industry and has changed the rules of competition. Viper provides increased performance, deep compression capabilities along with scalability and availability that are unmatched anywhere in the industry." REI services over three million co-op members who live in different states who like different activities and purchase different equipment. These co-op members pay memberships and receive a percentage from REI. DB2 9 is vital in REI’s success because IBM’s DB2 9 allows better intimacy with its customer’s. This software recognizes a log in and where they are located and can not only suggest equipment they may like...

Words: 623 - Pages: 3

Premium Essay

Case Study 2 (Chapter 6)

...1. What is a data warehouse and why is REI building one? A data warehouse is unique kind of a database where current and historical data about a certain group of people such as customers, is stored. Information from operational systems, such as transaction processing systems, is extracted and summarised then stored in in a data warehouse. This type of information includes records about customer interaction patens, customer purchasing history or trends and current customer records. The information in a data warehouse is used for management analysis and decision making. REI needs data warehouse for the following benefits • It will help REI’s management in decision making. Drawing trends about past and current customer buying patens will indicate as to which products are making the most profit and which ones require improvements. • REI will have an integrated, companywide view of high-quality information. The information systems department will be able to separate informational from operational systems to improve performance dramatically in managing company data. 2. What are some of the disadvantages of consumer cooperatives compared to ’traditional’ firms? Consumer co-operatives will not make a higher profit if they happen not to have a lot of members. While traditional firm firms will make profit from a variety of customers. Prices in Consumer-operatives are owners driven while traditional firms change their prices according to demands of products. This makes price...

Words: 678 - Pages: 3

Premium Essay

Business Management

...Case 2 Data warehousing at REI: Understanding the customer 1. What is a data warehouse and why is REI building one? Data warehouse is a large store of data accumulates from a wide range of sources within a company used. It collects data from the customers to better understand the customer’s trends, needs, and preferences. It also helps company analysing the data collected and improve the management strategies and decision making process. 2. What are some of the disadvantages of consumer cooperatives compared to ‘traditional’ firms? There are some disadvantages of consumer cooperatives compared to traditional firms where traditional model allow selling goods and services at the highest cost that are consumer willing to pay that will reflect the company to maximizing profits. In contrast, the goal of coop is to sell quality goods and services at the lowest cost to its consumers. The members of a consumer cooperative rarely benefit from the financial success of the cooperative. Additionally, coops can sometimes suffer from management difficulties because each member can technically play some part in managing the company. 3. Describe. Would these have been possible before the data warehouse was built? Some of the marketing strategies that REI’s data warehouse will allow it to use? REI’s data warehouse allows the company to better understand their customers’ preferences such as their favourite product. Hence the company can keep track the customers’ records...

Words: 1156 - Pages: 5

Premium Essay

Assignment

... | |Chapter 1: Information Systems in|(1) UPS Global Operations with the DIAD IV | |Global Business Today | | | |How IT drives the UPS operation worldwide. Using smart people and smart technology, UPS delivers over 14 million | | |packages daily to 200 countries and territories, requiring the talents of 70,000 drivers who are wirelessly connected| | |to UPS main databases located in seventeen major data centers throughout through out the world. L= 3:15 | | | | | |Tags: UPS global operations; hand held computers; wireless mobile platform; digital firm; integration of...

Words: 3467 - Pages: 14

Premium Essay

Test

...Week 1: Information Systems in the Digital Firm - Lecture | | | Information Systems in the Digital Firm Evolution | Current State | Trends | Tutorial The Evolution, Current State, and Trends of Information Systems In addition to the material currently described, an introduction to cloud computing and user involvement in IT projects also will be included in this lecture. This is required as foundational knowledge for the chapters to come. We will explore it at a business level and a minimal technical level. | | Evolution | | The business landscape has changed over the past seventy years in every significant way. Without information systems, these changes would not have occurred. To gain a perspective on the evolution of information systems, we can review the significant computer inventions from the first computer through to cloud computing. As computer technology progressed, new skills had to be learned, and new methods of management evolved to replace old hierarchical styles with new team based methods. Increased productivity resulting in new information technology caused the downsizing of employees that began in the late 1980s and has continued. Information systems consultants identified productivity gains, so large that they cut the numbers in half and still weren't believed. Many of the products and services we use every day had not been invented just five or ten years ago. The ability to communicate electronically with anyone anywhere in the world...

Words: 5656 - Pages: 23

Premium Essay

Retail Management

...or products in large quantities from manufacturers or importers, either directly or through a wholesaler, and then sells smaller quantities to the end-user. Retail establishments are often called shops or stores. Retailers are at the end of the supply chain. Manufacturing marketers see the process of retailing as a necessary part of their overall distribution strategy. The term "retailer" is also applied where a service provider services the needs of a large number of individuals, such as a public utility, like electric power. Shops may be on residential streets, shopping streets with few or no houses or in a shopping mall. Shopping streets may be for pedestrians only. Sometimes a shopping street has a partial or full roof to protect customers from precipitation. Online retailing, a type of electronic commerce used for business-to-consumer (B2C) transactions and mail order, are forms of non-shop retailing. Shopping generally refers to the act of buying products. Sometimes this is done to obtain necessities such as food and clothing;...

Words: 30165 - Pages: 121

Premium Essay

Ggggggg

...Krafft ´ Murali K. Mantrala (Editors) Retailing in the 21st Century Current and Future Trends With 79 Figures and 32 Tables 12 Professor Dr. Manfred Krafft University of Muenster Institute of Marketing Am Stadtgraben 13±15 48143 Muenster Germany mkrafft@uni-muenster.de Professor Murali K. Mantrala, PhD University of Missouri ± Columbia College of Business 438 Cornell Hall Columbia, MO 65211 USA mantralam@missouri.edu ISBN-10 3-540-28399-4 Springer Berlin Heidelberg New York ISBN-13 978-3-540-28399-7 Springer Berlin Heidelberg New York Cataloging-in-Publication Data Library of Congress Control Number: 2005932316 This work is subject to copyright. All rights are reserved, whether the whole or part of the material is concerned, specifically the rights of translation, reprinting, reuse of illustrations, recitation, broadcasting, reproduction on microfilm or in any other way, and storage in data banks. Duplication of this publication or parts thereof is permitted only under the provisions of the German Copyright Law of September 9, 1965, in its current version, and permission for use must always be obtained from Springer-Verlag. Violations are liable for prosecution under the German Copyright Law. Springer is a part of Springer Science+Business Media springeronline.com ° Springer Berlin ´ Heidelberg 2006 Printed in Germany The use of general descriptive names, registered names, trademarks, etc. in this publication does not imply, even in the absence of a specific statement...

Words: 158632 - Pages: 635

Premium Essay

Mcgraw-Hill - Marketing Demystified

...MHID: 0-07-171391-3. All trademarks are trademarks of their respective owners. Rather than put a trademark symbol after every occurrence of a trademarked name, we use names in an editorial fashion only, and to the benefit of the trademark owner, with no intention of infringement of the trademark. Where such designations appear in this book, they have been printed with initial caps. McGraw-Hill eBooks are available at special quantity discounts to use as premiums and sales promotions, or for use in corporate training programs. To contact a representative please e-mail us at bulksales@mcgraw-hill.com. This publication is designed to provide accurate and authoritative information in regard to the subject matter covered. It is sold with the understanding that neither the author nor the publisher is not engaged in rendering legal, accounting, securities trading, or other professional services. If legal advice or other expert assistance is required, the services of a competent professional person should be sought. —From a Declaration of Principles Jointly Adopted by a Committee of the American Bar Association and a Committee of Publishers and Associations Trademarks: McGraw-Hill, the McGraw-Hill Publishing logo,...

Words: 128470 - Pages: 514

Free Essay

The Review of a Business Model

...The review of a business model  Bachelor assignment        THE REVIEW OF A BUSINESS MODEL   Research on changing the business model for a Dutch tour operator    Leon van der Heijden ‐ June 2010                                          University of Twente  Faculty: School of Management and Governance  Education: Industrial Engineering & Management  Drienerlolaan 5  7522 NB Enschede  www.mb.utwente.nl    Supervisor: Dr. K. (Kasia) Zalewska‐Kurek  Co‐reader: Dr. J. (Joris) M.J. Heuven              Mensink Capital B.V.  World Trade Center Amsterdam  A Tower – Level 5  Strawinskylaan 509  1077 XX Amsterdam  www.mensinkcapital.nl    Principal: Drs. H. (Hugo) J.T. Mensink    Author: L. (Leon) E. van der Heijden  Willem‐Alexanderstraat 39  7511 KJ Enschede  l.e.vanderheijden@student.utwente.nl          Frontpage: Smith, Alan (2009). The Movement. www.businessmodelgeneration.com              Management summary    The travel industry is one of the largest and also one of the fastest changing industries in the World.  The emergence of the internet has radically changed the way business is conducted throughout the  industry. This research focuses on a Dutch tour operator which is having trouble adjusting to the fast  changing  business  environment.  This  tour  operator  did  not  make  the  transition  to  online  direct  selling  but  still  sells  its  products  via  retail  partners  only.  Due  to  fierce  competition  of  online ...

Words: 27366 - Pages: 110

Premium Essay

Marketing

...TE AM FL Y Praise for Marketing Insights from A to Z “The bagwan of Marketing strikes again. Leave it to Phil Kotler to revisit all of our blocking and tackling at just the right time . . . and as all great marketers know: ‘timing is everything.’” —Watts Wacker Founder and CEO, FirstMatter Author, The Deviant Advantage: How Fringe Ideas Create Mass Markets “Wide-ranging, readable, pithy, and right on target, these insights not only are a great refresher for marketing managers but should be required reading for all nonmarketing executives.” —Christopher Lovelock Adjunct Professor, Yale School of Management Author, Services Marketing “Kotler tackles the formidable challenge of explaining the entire world of marketing in a single book, and, remarkably, pulls it off. This book is a chance for you to rummage through the marketing toolbox, with Kotler looking over your shoulder telling you how to use each tool. Useful for both pros and those just starting out.” —Sam Hill Author, Sixty Trends in Sixty Minutes “This storehouse of marketing wisdom is an effective antidote for those who have lost sight of the basics, and a valuable road map for those seeking a marketing mind-set.” —George Day Geoffrey T. Boisi Professor of Marketing, Wharton School of Business “Here is anything and everything you need to know about where marketing stands today and where it’s going tomorrow. You can plunge into this tour de force at any point from A to Z and always come up with remarkable insights and...

Words: 53807 - Pages: 216

Premium Essay

Management Skills, Leadership Skills.

...Instructor’s Manual Jane Murtaugh College of DuPage BUSINESS IN ACTION 3rd Edition COURTLAND L. BOVEE JOHN V. THILL & BARBARA E. SCHATZMAN Introduction This Instructor’s Manual brings together a set of completely integrated support materials designed to save instructors the trouble of finding and assembling the resources available for each chapter of the text. 1. Course Planning Guide Included in the guide are suggestions for course design, classroom activities, and supplemental teaching aids. 2. Learning Objectives and Summary of Learning Objectives For each chapter, learning objectives and the summary of the learning objectives are listed. 3. Brief Chapter Outlines For each chapter, a brief chapter outline is provided. 4. Lecture Notes and Chapter Outlines For each chapter, a comprehensive outline is provided, as well as a variety of stimulating lecture enrichment materials. 5. Real-World Cases At least two real-world cases related to chapter material are included for each chapter. 6. Answers to End-of-Chapter Questions Answers to the end-of-chapter questions are provided, as well as suggested teaching tips when appropriate. 7. Answers to See It on the Web Exercises Following the end-of-chapter questions, answers to the See It on the Web Exercises can be found, along with tips for the instructor. Answers to Boxed Features In each chapter, students are presented with at least two supplemental “boxes,” both containing questions about the material discussed. Answers...

Words: 156200 - Pages: 625

Free Essay

Nit-Silchar B.Tech Syllabus

...NATIONAL INSTITUTE OF TECHNOLOGY SILCHAR Bachelor of Technology Programmes amï´>r¶ JH$s g§ñWmZ, m¡Úmo{ à VO o pñ Vw dZ m dY r V ‘ ñ Syllabi and Regulations for Undergraduate PROGRAMME OF STUDY (wef 2012 entry batch) Ma {gb Course Structure for B.Tech (4years, 8 Semester Course) Civil Engineering ( to be applicable from 2012 entry batch onwards) Course No CH-1101 /PH-1101 EE-1101 MA-1101 CE-1101 HS-1101 CH-1111 /PH-1111 ME-1111 Course Name Semester-1 Chemistry/Physics Basic Electrical Engineering Mathematics-I Engineering Graphics Communication Skills Chemistry/Physics Laboratory Workshop Physical Training-I NCC/NSO/NSS L 3 3 3 1 3 0 0 0 0 13 T 1 0 1 0 0 0 0 0 0 2 1 1 1 1 0 0 0 0 4 1 1 0 0 0 0 0 0 2 0 0 0 0 P 0 0 0 3 0 2 3 2 2 8 0 0 0 0 0 2 2 2 2 0 0 0 0 0 2 2 2 6 0 0 8 2 C 8 6 8 5 6 2 3 0 0 38 8 8 8 8 6 2 0 0 40 8 8 6 6 6 2 2 2 40 6 6 8 2 Course No EC-1101 CS-1101 MA-1102 ME-1101 PH-1101/ CH-1101 CS-1111 EE-1111 PH-1111/ CH-1111 Course Name Semester-2 Basic Electronics Introduction to Computing Mathematics-II Engineering Mechanics Physics/Chemistry Computing Laboratory Electrical Science Laboratory Physics/Chemistry Laboratory Physical Training –II NCC/NSO/NSS Semester-4 Structural Analysis-I Hydraulics Environmental Engg-I Structural Design-I Managerial Economics Engg. Geology Laboratory Hydraulics Laboratory Physical Training-IV NCC/NSO/NSS Semester-6 Structural Design-II Structural Analysis-III Foundation Engineering Transportation Engineering-II Hydrology &Flood...

Words: 126345 - Pages: 506

Premium Essay

Philip Kotler Book

...itself. It does not cover the individual selections herein that first appeared elsewhere. Permission to reprint these has been obtained by Pearson Custom Publishing for this edition only. Further reproduction by any means, electronic or mechanical, including photocopying and recording, or by any information storage or retrieval system, must be arranged with the individual copyright holders noted. This special edition published in cooperation with Pearson Custom Publishing Printed in the United States of America 10 9 8 7 6 5 4 3 2 1 Please visit our web site at www.pearsoncustom.com ISBN 0–536–63099-2 BA 993095 PEARSON CUSTOM PUBLISHING 75 Arlington Street, Suite 300, Boston, MA 02116 A Pearson Education Company SECTION ONE Understanding Marketing Management Marketing in the Twenty-First Century We will address the following questions: ■ What are the tasks of marketing? ■ What are the major concepts and tools of marketing? ■ What orientations do companies exhibit in the marketplace? ■ How are companies and marketers responding to the new challenges? C hange is occurring at an accelerating rate; today is not like yesterday, and tomorrow will be different...

Words: 231198 - Pages: 925

Premium Essay

Problem Solving for Manager

...Creative Problem Solving for Managers Second edition How can managers tackle complex problems? How do you encourage innovation? How do you implement new solutions? Is creativity the key to management success? This accessible text provides a lively introduction to the essential skills of creative problem solving. Using extensive case studies and examples from a variety of business situations, Creative Problem Solving for Managers explores a wide range of problem solving theories and techniques, illustrating how these can be used to solve a multitude of management problems. Thoroughly revised and redesigned, this new edition retains the accessible and imaginative approach to problem solving skills of the first edition. Features include: ■ ■ ■ ■ ■ Blocks to creativity and how to overcome them Key techniques including lateral thinking, morphological analysis and synectics Computer-assisted problem solving Increased coverage of group problem solving techniques New website containing in-depth cases and a PowerPoint presentation As creativity is increasingly being recognised as a key skill for successful managers, this book will be welcomed as a readable and comprehensive introduction for students and practising managers alike. Tony Proctor is Professor in Marketing at Chester University College Business School and was formerly Senior Lecturer in Marketing and Head of the Department of Management at Keele University. Creative Problem Solving for Managers Developing skills...

Words: 109777 - Pages: 440