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 to Expert-Tailored 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