Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started