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.
- Powered by Article Dashboard degree in business management
- Powered by Article Dashboard union general
- Powered by Article Dashboard online business
- Powered by Article Dashboard successful online business
- Powered by Article Dashboard online degree in business
- Powered by Article Dashboard data quality management
- Powered by Article Dashboard fast food industry analysis
- powered by myBB business management information
- powered by myBB union general
- powered by myBB fire station