preview

Ben & Jerry's Data Warehouse

Decent Essays

1. If I were to design Ben & Jerry’s data warehouse I would use several dimensions of information. The first dimension would consist of the company’s products; ice cream, frozen yogurt or merchandise. The marketing department has to know which products are selling, if Ben & Jerry’s didn’t know that their T-shirts are selling out as soon as they hit the stores, then they wouldn’t be able to take advantage of the opportunity to sell the shirts. The second dimension would consist of the different areas of sales; US, Canada, Mexico, or Europe. I am not sure if they sell their ice cream in Mexico, but with data collection they can find out if their ice cream would be a better seller in the hot climate, …show more content…

The primary key for the Store file would be the store number, or code. Some of the foreign keys would be; delivery dates, order dates, sales, and customer complaints. The Employee files primary key would be an employee number. The foreign keys for the Employee files would be; start date, wage, shift, employee address, paid time off, and absences. The Product file would have a primary key of product name, for example, Cherry Garcia. The foreign keys would be product type (ice cream/frozen yogurt), amount in stock, amount sold, ingredients, and comments. Comments sounds like a useless bit of information, but I think it could be one of the most useful. When it comes to a decline in ice cream sales a comment query could tell managers exactly what flavor people really want. In the case Ben & Jerry’s received a large number of complaints that it’s Cherry Garcia ice cream didn’t have enough cherries in it. Using the business intelligence with Business Objects helped them discover a problem with their packaging, and solve the problem.
3. What is the question that any business should be asking itself? How do we cut costs? Using business intelligence, Ben & Jerry’s can look at how they can cut costs. From a financial perspective we could run a query to see what it costs to make the top 5 selling flavors, once

Get Access