Business Intelligence: Such Possibilities, Such Problems

CLOSING CASE STUDY TWO

Business Intelligence: Such Possibilities, Such Problems

I. Statement of the Problem

1. Which one of the businesses must have the most up-to-date information in its date warehouse? Which business can have the most out-of-date information in its data warehouse and still be effective? Rank the three businesses.

2. How can organizations encourage more effective use of business intelligence tools?

3. What information do you think grocery stores placemen decision on? Could they have determined that information from data warehouse?

4. What data warehouse would you need to predict the use of toppings by time of day and by day of the week? What information would you hope to find in your data warehouse that would enable you to do so?

II. Key Objectives

1. To discuss which businesses must have the most up-to-date and out-to-date information in its date warehouse.

2. To discuss how organizations encourage more effective use of business intelligence tools.

3. To know what information grocery stores placemen decision on, and to determine information from data ware house. To discuss what data warehouse would be needed for the pizza parlor.

III. Areas of Consideration

Internal Factors

Strength | Weaknesses |

* Subject-oriented feature, data warehouses. * Data warehouse gives better quality data such as consistency, accuracy, and documentation * data warehouses integrate all data from different data sources in one place, users don’t need to login many systems, and response time should be reduced. * data warehouses copy some of the operational data and put in separate database, queries from users do not interfere with normal operations, and with the help of OLAP tools, it’s much easier for decision makers to access business data. | * cannot just buy a data warehouse; you have to build one because each warehouse has a unique architecture and a set of requirements from the individual needs of the organization....