Case 3: Henry Schein Inc.: The Business Value of a Data Warehouse

1. What are some of the key requirements for building a good data warehouse? Use Henry Schein Inc. as an example.

Answer:

Some of the key requirements in building a good data warehousing is as Henry Schein Inc. figured out. The $2.8 billion distributor of health care products designed and built a data warehouse with an in-house team of six IS professionals, this professionals is expert and in charge in their different field such us data modeling, front end specialist, user interface and data analysis this will lead the company to ensure data quality.

2. What are the key software tools needed to construct and use a data warehouse?

Answer:

The key software needed to construct and use in data warehousing are the software chooses by harding which is the two key tools for the data warehouse data extraction software from Informatica Corp. and user query, reporting software from MicroStrategy Inc and Data transformation and loading software.

3. What is the business value of a data warehouse to Henry Schein? To any company?

Answer:

The business value of data warehouse to Henry Schein is figure out who his most profitable customers are, target customers for certain types of promotions, and look at the business by product categories or sales territories. Ferraro says the data warehouse also helps select customers for direct-mail marketing campaigns that range “upward of 25 million pieces annually.” Is helps to any company in business users search, sort, and drill down for that information themselves in a fraction of the time.

Case Study 4

1. Do you agree with the argument made by Nick Carr to support his position that IT longer gives companies a competitive advantage? Why or why not?
Answer:

I do not agree on Nick Carr belief, because I think IT is a big advantage in any business company to earn more income

2. Do you agree with the argument made by the business leaders in this case in support of the competitive advantage that IT can provide to a business? Why or why not?

Answer:

I agree in the business leader’s argument, because IT is really an advantage to every business to gain more profit and income but as Michael Dell’s statement it depends on how you use it as tour advantage.

3. What are several ways that IT could provide a competitive advantage to a business? Use some of the companies mentioned in this case as examples. Visit their websites to gather more information to help you answer.

Answer:

Some ways that IT can provide more advantage is in commutations, they can easily communicate with each other to share new information with products, and this leads them to earn more profits.

Case Study No 3

Case Study Questions and Answers:

1. Why do you think that Aviall failed in their implementation of an enterprise resource planning system? What could they have done differently?

Answer:

The reason why Aviall failed might be the ERP system did not work to improve the operational needs of Aviall management.

They could done differently by reviewing the proper needs of the system and analyze the prior business requirements in making a decision in using software such us ERP system.

2. How has information technology brought new business success to Aviall? How did IT change Aviall’s business model?

Answer:

-Information technology bought new business success to Aviall by using common business databases managed by database software from Sybase, Inc.

-Developing a website to reduce the cost of every transaction.

-The IT Changed Aviall from a catalogbusiness to full-scale logistics business and Aviall became a provider of supply chain management services through the integration of a range of Web-enabled e-business software systems.

3. How could other companies use Aviall’s approach to the use of IT to improve their business success? Give several examples.

Answer:

Other companies can use aviall approach of IT to improve their business success by using appropriate approach to improve their services like creating a website in ordering or reservation.

Case Study 2

Are many of Lufthansa’s challenges identified in the case similar to those being experienced by other businesses in today’s global economy? Explain and provide some examples.

Answer:

Yes, the challenges faced by Lufthansa are similar to the other company's faced today some company's

2. What other tangible and intangible benefits, beyond those identified by Lufthansa, might a mobile workforce enjoy as a result of deploying mobile technologies? Explain.

Answer:

Tangible benefits would include a laptop or other technologies to use for work at home. Also, costs will decrease for the company because they would no longer need to pay for training facilities, paper copies of training manuals, travel and teachers. Intangible benefits would include more productive, time-efficient and overall happier employees that could enjoy a more flexible work environment.

3. Lufthansa was clearly taking a big risk with their decision to deploy notebook computers to their pilots. What steps did they take to manage that risk and what others might be needed in today’s business environment? Provide some examples.

Answer:

Lufthansa created a list of parameters that notebook PCs needed to meet before purchasing the laptops. They created their own secure network.

1. Could the 2004 Athens Olympics have been a success without all of the networks and backup technologies?

Answer: I think the events would not be that success because their may be an error that are not detected if they did not use the proper backup and networks.

2. The 2004 Olympics is a global business. Can a business today succeed without information technology? Why or why not?

Answer: Today information technology is very useful in terms of business transaction that's why without information technology business would not be that success because most business today use the technology to sell or advertise their product world wide.


3. Claude Philipps said dealing with “crazy scenarios of what might happen in every area: a network problem,staff stopped in a traffic jam, a security attack . . . every thing that might happen,” was the reason for so much testing. Can you think of other businesses that would require “crazy scenario” testing? Explain.

Answer: The other business that might need crazy scenario and testing are banks because they are prone to hackers, they also need this testing to secure their files and data from outside access.