Question: Using Figure 9.2 as a guide - Choose a specific business (restaurant or property management). Next, name three internal and three external databases that you
Using Figure 9.2 as a guide - Choose a specific business (restaurant or property management). Next, name three internal and three external databases that you think should be included in a data warehouse for that company. Support your answer
| Figure 9.2 | Operational (Internal)Databases | Data Warehouse | Data Mart | ||
| General Ledger | General Ledger | Business Intelligence Data Mart (e.g. Competitor analysis, industry analysis) | |||
| Inventory (coffee beans, milk, cream,etc.) | Inventory (coffee beans, milk, cream,etc.) | ||||
| Sales from Point-of-Sale Terminals | Sales from Point-of-Sale Terminals | ||||
| Human Resources | Purchases (amount, costs) | Inventory Data Mart (to facilitate supply chain analysis) | |||
| External Databases | |||||
| Industry Information (restaurant, coffee shops, retail) | Industry Information (restaurant, coffee shops, retail) | Marketing and Sales Data Mart (to help target new and returning customers) | |||
| Competitor Information from McDonald's and Dunkin' Donuts, etc. | Competitor Information from McDonald's and Dunkin' Donuts, etc. | ||||
| General Economy Information (GDP, interest rates, etc.) | General Economy Information (GDP, interest rates, etc.) | Human Resources Data Mart (to help determine appropriate saffing levels) | |||
| Focal Customer demographics and Purchasing Tendencies | Focal Customer demographics and Purchasing Tendencies |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
