Closing Case Study One

Closing Case Study One Information Systems in Enterprise (ISYS 3001 3) Group B Participants-Matthew Gilliss, Arlene Gulley, Renee Hicks Kemara Mcintyre, and Andrew Ginn Walden University February 10, 2013 Abstract This will be a paper that has been a concourse effort with Matthew Gilliss (organizer and website account setup, homepage and student webpage template), Arlene Gulley (editor/poster), Renee Hicks (compiler), Kemara Mcintyre (summary), and Andrew Ginn (editor). The universal resource locator of our website is http//faboulousgroupb. weebly. com/.Our goal will be to respond to specifics questions in regards to two slick studies the first, being Ben & Jerry and secondly, Bigelow Teas. Ben & Jerrys produce 190,000 pints of ice cream and frozen yogurt daily. It has 50,000 stores in the United States and 12 otherwise countries. The company employments an Oracle database and parentageObjects for tracking of communication channel trading operations. They perform various tr ansformation steps to organize retentive term goals for the business. It prepares strategies to stay line with technological advances.They have applied this engineering science to storing and manufacturing ice cream with energy efficiency warehouses. This new strategy enhances node satisfaction, minimize inventory, and reduce manpower. (Haag & Cummings, 2009). Closing Case Study One fountainhead 1 To redesign Ben & Jerrys data warehouse the dimensions of information intromit frozen yogurt, ice cream, merchandise, locations, gross revenue and shipping. This company should track all the varied types of ice cream and yogurt flavors.They should also monitor these areas with the highest and lowest gross 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 antithetical dimensi ons are merchandise and locations. (Haag & Cummings, 2009). Question 2 When looking at Ben & Jerrys ice cream stores, they would have to have a record of the diverse types of ice cream and frozen yogurt they offer.Along with the different products they would have to be commensurate to track individual sales, the dates of those sales, and the store locations where the sale was made. When looking at primary coil keys you privy see that the store number, order number and hand truck number could be primary keys. When looking for foreign keys to connect with the primary keys, you dope see that store numbers, truck numbers, and order numbers can all be seen to be foreign keys. These are important because they would admit for Ben & Jerrys to locate the exact order files of what they shipped, who drove it and where it went.Also then they could behave the primary keys even farther and connect directly to the store and adhere other feedback that is directly correlated with the store. ( Haag & Cummings, 2009). Question 3 Because of their familiarity of Microsoft Excel, it was easier to learn business line Objects and they were to a greater extent inclined to learn the new way of using the Business Objects. They were able to substitute different functions on the Business Objects with Microsoft Excel, which created a more familiarity to them and they were able to be more comfortable with the task.Because of the area of their job, they were required to use spreadsheets, rather than using word processing software. (Haag & Cummings, 2009). Question 4 Bigelow Teas could widen to use Business Objects and they cooperate with each other so they can better understand its in-house and outside strengths and weaknesses. Bigelow Teas should make sure that their suppliers and resellers are set out of the information partnership. This would allow the suppliers and resellers to be in contact with each other and to make the necessary adjustments or changes that are required. Haag & Cummings, 2009). According to (Haag & Cummings, 2009), business cognition is collective information about customers, your competitors, your partners, your competitive environments, and your own internal operationsthat gives you the ability to make effective, important, and often strategic business finishs. (p. 87). Bigelow Teas would not regard their suppliers or resellers to know about their strategic business finiss. (Haag & Cummings, 2009).There might be a person who is a supplier or reseller who might restitution this information and use it for themselves and/or sell the information for a profit. The suppliers and resellers should exclusively have information that will help Bigelow Teas in regards to implementing cost reduction, and be helpful with their resources. Question 5 Neil Hasties belief that most boldnesss decision making is a lot of trial by error. In a sense that could be true, but good decision making sticks from the vellicate and makes it way down.Lets not lose sight on what decision making really is finding a logical choice of decisions from on tap(predicate) options. A CEO or even management of any diversity of organization would have to be good at decision making. If you were to turn of events Neils narrative about decision making into a corroboratory one, then one would agree that an organization or whoever is running the organization would need to keep an open-mind. Keeping an open-mind would include training, presenting timely information and everyones wide assortment of data-mining tools. Haag & Cummings, 2009). Conclusion This assignment was both a accomplishment experience and growing experience. As a group we were able to come together and tackle our case study and the creation of our group webpage. We were able to look at the information about the two companies and use the association that we have acquired with the class discussions and assignments and come up with responses to each question. We were able to und erstand what tables and files that Ben & Jerrys should use and what primary and foreign keys they should use.With Bigelow Teas we took a look at personal productivity software tools and how best they could open up business intelligence with buyers and suppliers. Also we were able to take a general statement made and turn it into one that could be used in the unremarkable business world. Overall, this experience allowed the members of the group to get closer looks into different industries and allowed the group members to use the information that we have acquired so far in our studies. mention Haag, S. , & Cummings, M. (2009). Information Systems Essentials. New York McGraw-Hill/Irwin.