Closing Case Study One

Closing eccentric person Study One cultivation 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 generalisation This de mapping be a story that has been a base effort with Matthew Gilliss (organizer and website measure setup, homepage and student webpage template), Arlene Gulley (editor/poster), Renee Hicks (compiler), Kemara Mcintyre (summary), and Andrew Ginn (editor). The URL of our website is http//faboulous rootb. weebly. com/.Our goal go out be to respond to specifics questions in regards to deuce case studies the first, being Ben & Jerry and secondly, Bigelow Teas. Ben & Jerrys get under ones skin in 190,000 pints of applesauce cream and frozen yoghurt daily. It has 50,000 stores in the United States and 12 early(a)(a) countries. The company dos an Oracle database and melodic lineObjects for spaning of vocation operations. They perform vari ous transformation stairs to organize long term goals for the business. It prepares strategies to hold fast line with technological advances.They run through employ this technology to storing and manufacturing grump cream with brawniness efficiency warehouses. This new strategy enhances node satisfaction, minimize inventory, and reduce manpower. (Haag & Cummings, 2009). Closing incase Study One interrogatory 1 To redesign Ben & Jerrys data warehouse the dimensions of cultivation include frozen yogurt, ice cream, ware, locations, gross sales and shipping. This company should track on the whole the contrary types of ice cream and yogurt flavors.They should also monitor these areas with the highest and lowest sales to hazard adjustments to save money. There should be information gathered on the merchandise being sold by Ben & Jerry. Ben & Jerry impart monitor sales from stores in early(a) locations ensuring the sound merchandise is being shipped to the right location. The dissimilar dimensions are merchandise and locations. (Haag & Cummings, 2009). header 2 When sounding at Ben & Jerrys ice cream stores, they would scram to have a record of the different types of ice cream and frozen yogurt they offer.Along with the different products they would have to be competent to track individual sales, the dates of those sales, and the store locations where the sale was made. When aspect at primary feather keys you sess affect that the store number, redact number and transport number could be primary keys. When beliefing for foreign keys to bind with the primary keys, you can see that store numbers, truck numbers, and order numbers can all be seen to be foreign keys. These are of the essence(predicate) because they would allow for Ben & Jerrys to locate the learn order files of what they shipped, who drove it and where it went.Also then they could take the primary keys even farther and connect directly to the store and get other feedback tha t is directly correlated with the store. (Haag & Cummings, 2009). Question 3 Because of their familiarity of Microsoft Excel, it was easier to learn Business Objects and they were more accustomed to learn the new way of victimisation 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 light with the task.Because of the area of their job, they were required to use spreadsheets, kinda than using word processing software. (Haag & Cummings, 2009). Question 4 Bigelow Teas could continue to use Business Objects and they cooperate with each other so they can better understand its in-house and outdoors strengths and weaknesses. Bigelow Teas should make sure that their suppliers and resellers are part 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 ch anges that are required. Haag & Cummings, 2009). gibe to (Haag & Cummings, 2009), business password is collective information slightly customers, your competitors, your partners, your competitive environments, and your own inner operationsthat gives you the ability to make effective, important, and very much strategical business closings. (p. 87). Bigelow Teas would non motivation their suppliers or resellers to know about their strategic business decisivenesss. (Haag & Cummings, 2009).There might be a person who is a supplier or reseller who might take this information and use it for themselves and/or sell the information for a profit. The suppliers and resellers should only 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 nerves decision make is a lot of trial by error. In a sense that could be true, but good decision fashioning get ins from the top and makes it way down.Lets not lose sight on what decision making really is finding a logical choice of decisions from available options. A CEO or even attention of any kind of organization would have to be good at decision making. If you were to consider Neils statement about decision making into a incontrovertible one, then one would agree that an organization or whoever is running the organization would take on to keep an open-mind. Keeping an open-mind would include training, presenting well-timed(a) information and everyones wide categorization of data-mining tools. Haag & Cummings, 2009). Conclusion This assignment was both a learning experience and growing experience. As a group we were able to come together and tackle our case sketch and the creation of our group webpage. We were able to look at the information about the both companies and use the knowledge that we have acquired with the signifier discussions and assignments and come up with responses to each question. We were able to determine 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 scoop 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 everyday 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. Reference Haag, S. , & Cummings, M. (2009). Information Systems Essentials. New York McGraw-Hill/Irwin.