Ben & Jerry's, Bigelow Teas, And Business Intelige

790 Words4 Pages
1. If I were to design Ben & Jerry's data warehouse, then I would use several dimensions of information. • As first dimension, I would include the company's products, such as ice cream, frozen yogurt or merchandise. Because the marketing department needs to know which products are selling. For instance; if Ben & Jerry's didn't know that their ice cream scoops are selling out as soon as they’re displayed in stores, then they wouldn't be able to take advantage of the opportunity to sell the ice cream scoops. • The second dimension would consist of various areas of sales such as the United States, Canada, Caribbean, or Europe. Besides Puerto Rico, I am not sure if they sell their ice cream on any other island, but with data collection one could find out if their ice cream would be a better seller in the hot climate of the Caribbean instead of planning on a greater distribution in Canada where the warm period is rather short. • The third dimension would consist of the various details; where sales were made, when the sales were made, and who purchased the product. Such information would assist the development of products that focus on buyers preferences. Ben & Jerry’s could produce flavors to seasonal changes, help with concentration of advertising, and design attractive packaging to get the attention from buyers. Ben & Jerry’s could attain information that will help forecast increase or decline of products due to seasonal changes and adjust production and distribution in the different areas. 2. To create a detailed data base, Ben & Jerry's would need a very large number of files. The files to be created would be individual Store-, Product-, and Employee-files. Store files ought to include information about every store that sells Ben & Jerry's. This would tell me everything about every transaction with a Ben & Jerry's product in every store. The primary key for
Open Document