Preview

Rei Data Warehousing

Good Essays
Open Document
Open Document
716 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Rei Data Warehousing
1. What is a data warehouse and why is REI building one?

A data warehouse can be described as a “database that stores current and historical data of potential interest to decision makers throughout a company. The data originate in many core operational transaction systems, such as systems for sales, customer accounts, and manufacturing, and may include data from Web site transactions.1” REI is building a data warehouse to improve the company and to meet the needs of the customers. REI’s data warehouse will allow the company to view current and past data on sales, products, and customer information. The data warehouse will allow for the company to get to know the customers better and help in seeing which products are selling. The data warehouse will allow REI to become closer to the consumer and tailor goods to the needs of the consumer.

2. What are some of the disadvantages of consumer cooperatives compared to ‘traditional firms’?

Consumer cooperatives have some disadvantages in comparison to traditional firms. Consumer cooperatives require a high level of organization. Because the consumers are helping to make many decisions there are more legal responsibilities for the company. The company must listen to the consumers and also provide rules that the consumer cooperative must follow as a whole. While it is great for the consumers to be so involved, traditional firms have less of a hassle and don’t need to take so many extra steps when making decisions.

3. Describe some of the marketing strategies that REI’s data warehouse will allow them to use. Would these have been possible before the data warehouse was built?

REI’s data warehouse will allow them to create more marketing strategies, specifically on their online shopping Website. With the use of the data warehouse, REI’s website will be able to recognize customers when they log on to the Website. By doing this, REI can tailor products or information to the customer each time they log on.

You May Also Find These Documents Helpful

  • Powerful Essays

    Supplyco/561 Week 4

    • 2342 Words
    • 10 Pages

    1. SupplyCo. is a supplier to a number of firms in an industry. By carefully mining its customer data warehouse, SupplyCo. reveals a plausible new model for manufacturing and distributing industry products that would increase the overall efficiency of the industry system, reduce costs of production (leading to greater industry profits and more sales for SupplyCo.), and result in greater sales and profits for some of the industry's manufacturers (SupplyCo.'s customers).…

    • 2342 Words
    • 10 Pages
    Powerful Essays
  • Powerful Essays

    Ibm 211 Week 3

    • 4383 Words
    • 18 Pages

    IBM® Telecommunications Data Warehouse V8.4 delivers the following capabilities to communication providers: • • • Common customer view: Helps integrate customer identifiers, organizational structures, and account hierarchies across lines of business and functions. Product life cycle management: Helps integrate product management and performance measurement across lines of business and functions. Campaign performance management: Helps improve program planning, tracking of sales and marketing activities, and performance metrics across channels and touch points. Service management: Helps analyze usage, availability, and customer experience of new services, self-service, and new monetary services.…

    • 4383 Words
    • 18 Pages
    Powerful Essays
  • Satisfactory Essays

    This document is a proposal for building a data warehouse architecture that will consolidate and transform data into useful information for the purpose of decision-making and for establishing a new function that offers a broad array of decision support services to all units at ABC Retail Chain Corporation. Executives and decision-makers often need information to analyze the past, describe current circumstances, and anticipate the future. Presently, decision-makers across the Institute rely on hard copy reports or Excel Sheets to provide information. Typically, any request for information is forwarded to the operational areas of the Organization, which provide hard copy reports reflecting the data gathered in their functional area. To analyze and transform data into useful information, decision-makers and their staff have to manually re-enter the non-integrated data into their own mini-systems. This type of operation hinders the ability of decision making and the executives are either drowning in too much data with no option to analyze it or too little data, which means they are back to square one and must request additional information. Often executives receive multiple, conflicting information or information that is based on incomplete assumptions about the types of analysis required.…

    • 641 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    For companies has been using the analytics of data to reduce cost and drive innovation. Data has now become more available and with the help of technology better to understand though a computer. Stores such as Home Depot, Lowe’s, and Walmart analyze data to tailor products and price markdowns for customers located in curtain demographic areas. Fed-Ex use data on their delivery truck and planes, to help manage delivery times and traffic for better delivery schedules.…

    • 321 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Chapter 5 Quiz

    • 334 Words
    • 5 Pages

    A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:…

    • 334 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Assignment #1 Hrm 530

    • 634 Words
    • 3 Pages

    HR Data warehouse - Selected Candidate will be responsible for design, implementation and systems expertise of the data warehouse components focusing primarily on business objects Xi. The scope of technical expertise includes design and development of BO reports, security set-up of medium to high complexity levels as well as the ability to coordinate projects with business personnel and other members of the project teams within the organization to ensure that system requirements, deadlines…

    • 634 Words
    • 3 Pages
    Good Essays
  • Good Essays

    The most important aspect of having data warehousing is the fact that it allows for data storage and presentation of this data enabling executives to make sound decisions. Another important use of data warehousing is it takes the separate areas the company is divided up in and takes it all and lumps it in to one single entity. One great benefit of data warehousing is that Huffman will be able to handle server task connected to all queries which is not commonly found in all systems. “Another powerful benefit of data warehouses is that they allow companies to use data modeling for querying tasks that are quite difficult for transaction processing” (Exforsys, 2007). Huffman trucking is already successful but by implementing a success data warehousing system they would be able to understand and analyze all data coming in and leaving the system better and at a more efficient rate. Attached to this report is a…

    • 891 Words
    • 3 Pages
    Good Essays
  • Good Essays

    IM Macy s 2

    • 599 Words
    • 2 Pages

    To implement the kind of customer-centricity envisioned a customer data strategy was a prerequisite. So was needed to consolidate the various data repositories that had accumulated from predecessor companies, and for realizing the foundational importance of this work on a long-term macys.com need to turn to IBM to provide guidance and tools. To finish the virtually transformation macys.com worked to put in place the architectural elements needed for a 360 degree view of its customers to support a strategy of multichannel integration.…

    • 599 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Bis Midterm Sheet

    • 1467 Words
    • 6 Pages

    A data warehouse is to extract and clean data from operational systems and other sources to store and catalog that data for processing by BI tools. Data warehouses can include external data purchased from outside sources. Meta data is kept in the data warehouse. Physically, a data warehouse consists of a few fast computers with very large storage devices.…

    • 1467 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    REI - CAHPTER 4, CASE 2

    • 2464 Words
    • 9 Pages

    Describe some of the marketing strategies that REI’s data warehouses will all them to use. Would these have been possible before the data warehouse was built?…

    • 2464 Words
    • 9 Pages
    Satisfactory Essays
  • Good Essays

    If I were to design Ben & Jerry's data warehouse I would use several dimensions of information. The first dimension would consist of the company's products; ice cream, frozen yogurt or merchandise. The marketing department has to know which products are selling, if Ben & Jerry's didn't know that their T-shirts are selling out as soon as they hit the stores, then they wouldn't be able to take advantage of the opportunity to sell the shirts. The second dimension would consist of the different areas of sales; US, Canada, Mexico, or Europe. I am not sure if they sell their ice cream in Mexico, but with data collection they can find out if their ice cream would be a better seller in the hot climate, rather than pushing for greater distribution in Canada. The third dimension would consist of the "specifics"; where the sale was made, when the sale was made, and who purchased the product. This information can help in the design of the product to focus on the buyer; it can tailor flavors to seasons, and packaging to buyer who looks for the better-looking product. If Ben & Jerry's could know when a season was coming to an end in a specific area, then they could forecast the need or the decline in need and speed up, or slow down distribution to those areas. The focus of the information is that it needs to be useful, and almost any information is useful.…

    • 605 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Closing Case Study One

    • 1065 Words
    • 5 Pages

    To redesign Ben & Jerry’s data warehouse the dimensions of information include frozen yogurt, ice cream, merchandise, locations, sales and shipping. This company should track all the different types of ice cream and yogurt flavors. They should also monitor these areas with the highest and lowest sales to make adjustments to save money. There should be information gathered on the merchandise being sold by Ben & Jerry. Ben & Jerry will monitor sales from stores in other locations ensuring the right merchandise is being shipped to the right location. The different dimensions are merchandise and locations.…

    • 1065 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    The Voip Adoption

    • 1699 Words
    • 7 Pages

    development that occurs? In order for real time data warehousing to work many elements are required. These include the mainframe reservation system, satellite feeds from airplanes, central customer database and all other data sources such as their website, customer service applications, frequent flyer programs and reservation systems. Each of these works together and for every change that is made it is sent back to the data warehouse and displayed or is available to all customers within minutes (Brown, DeHayes, Hoffer, Martin, and Perkins, 2003).…

    • 1699 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    A data warehouse is a database that stores current and historical data of potential interest to decision makers throughout the company.[1] In the Terrorist Watch List Database case, the information about suspected terrorists are consolidated and standardized from multiple government agencies so that the information can be centralized into a single list, from which different agencies can communicate and share information with each other. This centralized database is a specific example of data warehouse. In this case, the data warehouse containing the relevant information of individuals from each agency’s list enhancing effectiveness of communication between agencies as well as increase the consistency of information from separate databases.…

    • 860 Words
    • 4 Pages
    Good Essays
  • Better Essays

    Hilton Hotels-Case Study

    • 1034 Words
    • 5 Pages

    References: Loveman, G. (2003). Diamonds in the data mine. Harvard Business Review. Retrieved April 9, 2006 from http://harvardbusinessonline.hbsp.harvard.edu/…

    • 1034 Words
    • 5 Pages
    Better Essays