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

Case Study Questions:

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

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

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

Solutions:
1.
a. A database management system is a set of computer programs that controls the creation, maintenance, and use of the databases of an organization. Major uses are database development, database interrogation, database maintenance, and development of application programs.
b. Key requirements would include:
• Those involved in building the data warehouse should have the right skills and experience.
• Ensure data quality.
• Determine on the front-end the information the potential business users need access to and the reports they want to see.
• Analyze the old paper reports and the condition of the data housed in the company’s core transaction system.
• Standardize transactional codes in order to produce reports needed.
• Developing and testing summary tables to make queries work faster.

2. Key software tools need would include:

• Data extraction software.
• User query and reporting software.
• Data transformation and loading software.

3. The business value would include:

• Determine the most profitable customers.
• Determine which customers to target with special promotion offers.
• Analyze the business by product category, sales territory, etc.
• Determine which customers should be included in specific direct marketing efforts.
• Ability of a user to add more fields to reports as they are using the system.

Finals (to be passed on examination day & blog) - pdf files

MUST READ THIS

click on the link to download the pdf file:

(note: you may download a .file extension, pero open as adobe reader lang xa>> select from the list)

to be passed on examination day - print ninyo ang answer ninyo ani, to be passed on examination day / or you may read the case study on my blog>> click here

post on blog - blog ni xa pagpasa, pag tapos na og post, send your blog url to Sir Geo's email >>> geonso@yahoo.com, dapat clickable siya para direct na xa muad2 sa inyong blog.. thx for reading / or you may read the case study on my blog>> click here

e.i. njbasan-mis.blogspot.com and send to geonso@yahoo.com