Closing Case Study One

Closing baptistry 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 throng 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 URL of our website is http//faboulousgroupb. weebly. com/.Our aspiration will be to respond to specifics questions in regards to two case studies the first, being Ben & Jerry and secondly, Bigelow Teas. Ben & Jerrys produce 190,000 pints of scratch cream and frozen yogurt daily. It has 50,000 investment trusts in the get together States and 12 other countries. The company uses an Oracle database and BusinessObjects for breeding of business operations. They perform various transformation steps to organiz e long term goals for the business. It prepares strategies to stay bend with technological advances.They have applied this technology to storing and manufacturing ice cream with energy efficiency warehouses. This new strategy 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 selective teaching include frozen yogurt, ice cream, merchandise, locations, sales and shipping. This company should track all the various 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 pull together 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. (Haag & Cummings , 2009). Question 2 When looking 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 able to track individual sales, the dates of those sales, and the store locations where the sale was made. When looking at primary keys you bottom see that the store number, piece 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 allow for Ben & Jerrys to locate the exact 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 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 Objects and they were more 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 maintain 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 re loters 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 & Cummings, 2009). According to (Haag & Cummings, 2009), business intelligence is collective infor mation close to 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 know just 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 helpful with their resources. Question 5 Neil Hasties tactile sensation that most organizations decision fashioning is a lot of trial by error. In a sense that could be true, but good decision making comes 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 accessible 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, then one would agree that an organization or whoever is running the organization would need to go along 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 learning 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 knowledge that we have acquired with the class 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 best they could open up business intelligence with buyers and suppliers. Also we were able to take a usual 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.