|
| Case 3: Henry Schein Inc.: The Business Value of a Data Warehouse |
| Sunday, October 11, 2009 |
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.
>>>> The key requirements for building a good data warehouse are those involved in building the data warehouse should have the right skills and experience. 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. What are the key software tools needed to construct and use a data warehouse?
>>>> The key software tools needed to construct and use a data warehouse are the data extraction software, user query and reporting software, and data transformation and loading software
3. What is the business value of a data warehouse to Henry Schein? To any company?
>>>> The business value of a data warehouse to Henry Schein are the following:
- 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. |
posted by Janus Victor P. Tanalgo @ 4:42 AM  |
|
|
|
|
| About Me |
|
Name: Janus Victor P. Tanalgo
Home: Bual Tulunan North Cotabato, Philippines
About Me: Chubby.
See my complete profile
|
| Previous Post |
|
| Archives |
|
|
|
