Section $3$: Data Marts

You are a summer intern in the information technology group of a regional chain of sandwich shops. The company has been in business for fifteen years and operates $200$ locations in eight states. The $200$ locations are organized into five regions $($A$,$ B$,$ C$,$ D$,$ and E$)$ of $40$ stores each. Regional managers are responsible for inventory management, procurement of inventory, sales, and marketing for their particular region. The company has been processing all transactions electronically $($with customers and suppliers$),$ and it has captured all the data in a large data warehouse. Unfortunately, the regional managers are complaining that there is now so much information in the data warehouse that it has become somewhat difficult to sort through it and extract meaningful data. You have just been placed on the team that will be designing a new data strategy for the company.

Setting up data marts would probably help with the accessibility of information. What type of data marts would you suggest setting up for this company? Make sure you explain who will benefit from the data marts you suggest. $[4$pts$]$

Clfck to enter text

For the data marts you identified in the previous question, list the data that should be stored in each data mart and explain how the regional managers could make use of that information to manage their group of stores. $[4$pts$]$