...Data Warehouse A data warehouse has many different processes that require several different technologies. Batch and transaction processing data has to first be taken out of the operational databases and then it can be cleaned up. Then the data is uploaded onto a relational database. Data warehouses are the basis for customer relationship management systems because they can be used for consolidating customer data and identifying areas of customer satisfaction and frustration. These warehouses can be used for fraud detection, production analysis, profit center, and corporate management. For retailers, a data warehouse can help identify customer demographics, identify shopping patterns, and improve mailing responses. Data Warehouse REI The data warehouse REI is building is going to have many different types of information about its customers. In order to better serve its clientele, REI has to know what their customers do outdoors. With the help from IBM, REI thinks that their data warehouse will help them better identify their individual’s needs and help them better as a company. This will also help them identity what the customers bought online or in the retail stores. The warehouse will also give them insight whether they attended special training for equipment and outdoor activities, or even what items a particular customer has returned. Data Warehouse Concerns There are many issues that are surrounding a data warehouse that companies need to...
Words: 665 - Pages: 3
...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
...· 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
...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
...NORAZASMIRABT OSMAN 2014192231 Chapter 6: 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...
Words: 1156 - Pages: 5
...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
...Executive summary The dream of the Strategic Center Firm (SCF) has quickly become a reality. This firm’s objective now includes the building of a decision support structure that supports the following areas: 1. “Formal reporting relationships and procedures” (FLA Grading Rubric, n.d., p. 2) 2. “Managing complex, cooperative interactions among network partners” (FLA Grading Rubric, n.d., p. 2) 3. “Aligning incentives among networked partners to have a reason to stay connected” (FLA Grading Rubric, n.d., p. 2) 4. “Managing the strategic network and controlling its operations” (FLA Grading Rubric, n.d., p. 2) These areas should help catapult your company to the status of a fortune 500 company. We would be known worldwide as one of the companies in America that has what it takes to not only compete in a global market, but be sustainable in a global market. “Fortune magazine takes into account the businesses' growth, as measured by stock earnings and investment returns, assets, revenue and profit when compiling the list.” (Tran, n.d., para. 3) Strategic Outsourcing If order to businesses to remain competitive, they must walk a fine line between costs and quality. Outsourcing plays an intricate part in this process. First off what is outsourcing? “Outsourcing has evolved beyond being viewed as a purely tactical exercise to reduce costs and increase operational efficiencies.” (Singhal, n.d., para. 1) SCF plans on utilizing strategic outsourcing to “adapt flexibly to business...
Words: 3096 - Pages: 13
...understand what drives database design, you must understand the difference between data and information. Data are raw numbers or other findings which, by themselves, are of limited value to decision makers. Information, on the other hand, is the result of organizing, processing, and interpreting data, thus transforming the findings into facts that are useful to decision makers. For example, the number of new users your clinic serves in a month means little until you compare it with the number of new users from previous months and years to see whether there has been an increase or decrease in the trend over time. Data are transformed into information by: Selection: Choosing the data that are useful and adequate for answering the questions that have been posed, and ignoring the data that are useless or inadequate for that purpose. Interpretation: Analyzing the data to put them into context, uncover patterns or problem areas, and reflect on the meaning of these patterns in relation to the questions being asked. The overall objective of converting data to information is to describe, explain, predict, and/or evaluate a program and its results. In this “information age” production of accurate, relevant and timely information is the key to good decision making. In turn, good decision making is the key to business survival in a global market. We are now said to be entering to “knowledge age”. Data are the foundation of information which is bedrock of knowledge that is, the body of...
Words: 4278 - Pages: 18
...511: IS DATA, CODING, AND INFORMATION Data and information Data. ← Items about things, events, activities, and transactions are recorded, classified, and stored but are not organized to convey any specific meaning. ← Data items can be numeric, alphanumeric, figures, sounds, or images. Information. ← Data that have been organized in a manner that gives them meaning for the recipient. They confirm something the recipient knows, or may have “surprise” value by revealing something not known. Internal and External data ← Internal data ← An organization internal data are stored in one or more places. Internal data is normally accessible via an organization computer network and may reside in user’s PC, databases and people’s memory. Internal data relates to: ← People e.g. employees – corporate database ← Products - sales ← Services ← Processes ← External data relates to activities outside the organisation. The data is critical in the management of the organization. Source include: Commercial databases e.g. data available on CD-ROMS, Internet servers, pictures, diagrams, atlases, television, Government reports, Commercial databases that normally charge for access to specialized databases Internal and External data ■ External data must be monitored and captured to ensure that important data is not overlooked...
Words: 7046 - Pages: 29
...Paymentech, was integrated with Yahoo! to validate credit cards and process payments for Cliptomania. Marketing was another issue encountered. With the dot-com bust in the early 2000s, the cost of listing the website in search engines increased based on the number of “clicks.” The Santos soon found, however, that this increased cost resulted in increased sales and now consider it an acquisition cost. Cliptomania also ventured into search engine advertising and pay for searches based on keywords that are selected by the company. ------------------------------------------------- SOLUTIONS (Taken by the company) (20 Points)* * Invest in an enterprise data warehouse and moving real-time data to warehouse. * Fare Design: Continental uses real-time data to optimize airfares. * Ticket Facsimile * The warehouse team developed an application for...
Words: 1007 - Pages: 5
...How can small and medium- sized companies benefit from the use of business technology software? The purpose for the majority of the small and medium-sized companies is to improve their sales or growth. Nowadays, the online sales and the electronic data analysis represent a crucial phase to achieve this. Since a considerable number of years now, the use of software in the decision making by the large companies has been a regular practice. The competition this business faces is fearful, and the decisions are in some cases critical. On the other hand this scenario does not always apply for the small and medium ones. There are three main reasons for this. First, their sales are not as considerable as they can be for the large business. This means they do not confront the same decision-making pressure as the large ones do. Furthermore the potential negative consequences from bad decisions do not impact as hard as it does in large business. Second, the characteristics inherent to this type of business such as the attraction of customers according the location and design of the facility, or the extensive display of goods to facilitate the selection of them (1) generates often a switch of consumers. Ergo, purchases from another business due to attractive circumstances, for instance provisional especial price in a product or service are common situation. As a result the potential “single-time custo{NOTE:no se si es correcto poner esto entre comillas}mers” can provoke a significant...
Words: 1637 - Pages: 7
...Benefits of data mining to the businesses: Data Mining. Assignment 4 Mustafa Abdullah Strayer University Dr. Jodine Burchell 08/30/2012 Data Mining is a useful tool in the business world today. Data Mining is a process that uses statistical information to gather useful information knowledge from data warehouses. Data Mining can be used for many reasons when gathering information. Businesses that use it are finance, retail and banks for the purpose of finding information on a company or individual. Most business use data mining to predict sales, credit card fraud and to find out what makes the patient ill. HR departments use data mining to predict the value of the employee. Robert (2006)” The eventual goal is to project how much workers will produce over their careers”(para6). This tactic helps companies predict employees who will stay longer in the company as time goes by. The information is then stored into their database to help in the hiring process. “ Robert(2006)”Companies will be able to carry out cost-benefit studies on recruiting, training, and employee retention (along with its counterpart, layoffs)”.Base on this information companies are tired of playing the guessing game but data mining gives them a more accurate look. All the data gathered such as videos email, social media helps the HR understand the person and gives the business clues. Data Mining gives HR the ability to understand a person and search for the best job candidates through social media...
Words: 316 - Pages: 2
...CRM的核心是客户价值管理，它将客户价值分为既成价值、潜在价值和模型价值，通过一对一营销原则，满足不同价值客户的个性化需求，提高客户忠诚度和保有率，实现客户价值持续贡献，从而全面提升企业盈利能力。 4. Give an example of an experience that you have had with a company that uses a CRM system? IBM全球企业咨询服务部 IBM商业价值研究院 招商银行借咨询之力， 以CRM系统推进转型 尽管银行对批发业务的CRM(客户关系管理)需求旺盛，但是银行 界却鲜有成功案例。招商银行借助IBM的帮助，采用咨询与开发 同步的创新模式，成功地构建了批发业务CRM系统，并为其批发 业务管理的提升以及招商银行二次转型奠定了坚实的基础。不仅 如此，招商银行的创新举措再次创中国银行业的风气之先。 5. Provide an example of an organization with a CRM system that seems to increase comfort or satisfaction. Provide an example of an organization using a CRM system that may cause customer concerns over the loss of privacy. 10. What is the difference between a data warehouse, a data mart and a database? Database 1. Used for Online Transactional Processing (OLTP) but can be used for other purposes such as Data Warehousing. This records the data from the user for history. 2. The tables and joins are...
Words: 545 - Pages: 3
...materials. In an effort to reduce waste, all e-mails will be water marked "Please consider the environment before printing this e-mail." This is an important piece in the hospital ERP system and implementation of reasons to reduce paperwork. The Fund's policies and procedures outlined manually equipment tracking asset inventory, including risk assessment, use of equipment, employee training in the use, equipment maintenance agreement, compliance. The various hospital departments are individually responsible for the procurement of equipment, training, and all electrical and mechanical equipment maintenance costs for their area. Chief compliance officer, Frederick Adair, monitors personal data privacy issues that require hospitals to keep private personal health information (PHI). Access to patient data is restricted to those with a need to know. These parties are involved in the process such as insurance companies to pay claims and business partners which will have the bare minimum information necessary to meet contact requirements. Therefore, insurance companies and other...
Words: 2633 - Pages: 11
...and well wishers, income levels of parents, etc. Later in the literature review, I would be going through some reviews about few of the journals I have researched. There I would be discussing about the topics that have been researched upon. There will always be certain areas which will be left out without researching. I would be discussing about few research areas that haven’t been addressed by these journals. Then I would be discussing about the design aspects of the data mart I am going to develop for my research project. This would depict all those entities, attributes and relationships between these entities. Then I would be discussing about all those sources based on which I have done my research. Later I would be discussing about the dimensional modeling wherein I would make it clear as to what dimensions I am going to use and how I am going to use them in predicting the enrollment behavior of prospective students. Then I would be going through the data mining techniques and decide on which data mining...
Words: 2324 - Pages: 10
