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.