preview

Case Study-Ben and Jerry's Essays

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, rather than pushing for greater …show more content…

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 you know which flavors are the best sellers, would it make any sense to make a flavor that is ranked number 10 and costs more to make than the number 3 flavor, I don't think so. We could argue that, as long as there is profit, it is worth making, but for cost cutting sake this would be one way the company could find a quick way to cut

Get Access