Case Study in Data Warehouse


DATA WAREHOUSE CASE STUDY: FAST FOOD

The Fast Food industry is highly competitive, one where a very small change in operations can have a significant impact on the bottom line. For this reason, quick access to comprehensive information for both standard and on-demand reporting is essential. Exclusive Ore designed and implemented a data warehouse and reporting structure to address this requirement for Summerwood Corporation, a fast food franchisee operating approximately 80 Taco Bell and Kentucky Fried Chicken restaurants in and around Philadelphia. The Summerwood Data Warehouse now provides strategic and tactical decision support to all levels of management within Summerwood. The data warehouse is implemented in Microsoft SQL Server 2000, and incorporates data from two principal sources:

- Daily sales information automatically polled by the TACO system DePol utility.

- Period based accounting information from the Dynamics (Microsoft Great Plains) accounting
database.

click here to read ahead

Register to mark your comments

Data Warehouse Case Study on Fast Food

Comments

Filed under Logistics & Distribution, Operations, Supply Chain