Closing Case Study One

Closing Case training One Information Systems in go-ahead (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 typography that has been a group effort with Matthew Gilliss ( readyr and website account 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//faboulousgroupb. weebly. com/.Our finale will be to respond to specifics questions in regards to two case studies the first, creation Ben & group A Jerry and secondly, Bigelow Teas. Ben & Jerrys produce 190,000 pints of ice cream and stock-still yogurt daily. It has 50,000 cut ins in the United States and 12 another(prenominal) countries. The friendship uses an oracle entropybase and demarcationObjects for tracking of business operations. They perform various transforma tion steps to organize long term goals for the business. It prepargons strategies to stay line with technological advances.They extradite apply this technology to storing and manufacturing ice cream with energy efficiency warehouses. This new system enhances customer satisfaction, minimize inventory, and reduce manpower. (Haag & Cummings, 2009). Closing Case Study One Question 1 To redesign Ben & Jerrys data warehouse the dimensions of cultivation include frozen yogurt, ice cream, sell, locations, sales and shipping. This company should track all the antithetic types of ice cream and yogurt flavors.They should to a fault monitor these demesnes with the highest and lowest sales to authorise adjustments to save money. There should be discipline 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 disparate dimensions are merch andise and locations. (Haag & Cummings, 2009). Question 2 When attend toing at Ben & Jerrys ice cream stores, they would have 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 fitting to track individual sales, the dates of those sales, and the store locations where the sale was made. When looking at principal(a) keys you shadower see that the store number, order number and truck number could be primary keys. When looking for foreign keys to connect 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 important because they would lay off for Ben & Jerrys to locate the exact order files of what they shipped, who drove it and where it went.Also wherefore they could take the primary keys even farther and connect directly to the store and get other feedback that is directly correlated with the store. (Haa g & Cummings, 2009). Question 3 Because of their familiarity of Microsoft Excel, it was easier to learn Business Objects and they were more inclined to learn the new focussing 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 continue to use Business Objects and they cooperate with severally other so they can better understand its in-house and outside strengths and weaknesses. Bigelow Teas should depict 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 changes that are required. Haag &am p Cummings, 2009). According to (Haag & Cummings, 2009), business intelligence 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 decisions. (p. 87). Bigelow Teas would not want their suppliers or resellers to screw about their strategic business decisions. (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 reformative with their resources. Question 5 Neil Hasties belief that most arrangings decision fashioning is a lot of trial by error. In a feel that could be true, but good decision making summons from the top and makes it sort down.Lets not lose sight on what decision making really is finding a logical choice of decisions from available options. A CEO or even management of any kind of organization would have to be good at decision making. If you were to turn Neils statement about decision making into a positive one, indeed one would agree that an organization or whoever is running the organization would aim to keep an open-mind. Keeping an open-mind would include training, presenting timely information and everyones grand assortment of data-mining tools. Haag & Cummings, 2009). Conclusion This assignment was both a nurture 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 acquaintance that we have acquired with the class discussions and assignments and come up with responses to each question. We were able to tick what tables and files that Be n & 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 widely distributed 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.