Monday, October 12, 2009

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.

Key requirements would include:


• Ensuring data availability
• Involving key users throughout the whole project
• Ensure data quality.
• Relying on a pragmatic governance framework
• 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?

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




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

• choose best customer.
• Determine which customers to target with special promotion offers.
• 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.

1 comment:

  1. Problem: HP Printer not connecting to my laptop.

    I had an issue while connecting my 2 year old HP printer to my brother's laptop that I had borrowed for starting my own business. I used a quick google search to fix the problem but that did not help me.
    I then decided to get professional help to solve my problem. After having received many quotations from various companies, i decided to go ahead with Online Tech Repair (www.onlinetechrepairs.com).
    Reasons I chose them over the others:
    1) They were extremely friendly and patient with me during my initial discussions and responded promptly to my request.
    2) Their prices were extremely reasonable.
    3) They were ready and willing to walk me through the entire process step by step and were on call with me till i got it fixed.
    How did they do it
    1) They first asked me to state my problem clearly and asked me a few questions. This was done to detect any physical connectivity issues with the printer.
    2) After having answered this, they confirmed that the printer and the laptop were functioning correctly.
    3) They then, asked me if they could access my laptop remotely to troubleshoot the problem and fix it. I agreed.
    4) One of the tech support executives accessed my laptop and started troubleshooting.
    5) I sat back and watched as the tech support executive was navigating my laptop to spot the issue. The issue was fixed.
    6) I was told that it was due to an older version of the driver that had been installed.

    My Experience
    I loved the entire friendly conversation that took place with them. They understood my needs clearly and acted upon the solution immediately. Being a technical noob, i sometimes find it difficult to communicate with tech support teams. It was a very different experience with the guys at Online Tech Repairs. You can check out their website www.onlinetechrepairs.com or call them on 1-914-613-3786.
    Would definitely recommend this service to anyone who needs help fixing their computers.
    Thanks a ton guys. Great Job....!!

    ReplyDelete