Wednesday, December 4, 2013

DWBI - A Business Perspective - Day 1

Hi, i would like to drive a series on "DWBI - A Business Perspective" that helps you to look at DWBI technology as a business person, this series will have questions and business cases to work on. I believe in self learning than spoon feeding, because it breaks through the barriers of information availability and helps us explore more.

But still if you prefer the earlier approach, these are the direct references from
"Data Warehousing Fundamentals for IT Professionals" - Paulraj Ponniah, a book that helped my survival as a Business Analyst. I sincerely thank Paulraj Ponniah Garu for his writings and recommend all to go through.

Questions:

1. What do you mean by strategic information? For a commercial bank name five types of strategic objectives.
2. Do you agree that a typical retail store collects huge volumes of data through its operational systems? Name three types of transaction data likely to be collected by a retail store in large volumes during its daily operations.
3. Examine the opportunities that can be provided by strategic information for a medical center. Can you list five such opportunities?
4. Why were all the attempts by IT to provide strategic information failures? List three concrete reasons and explain.
5. Describe five difference between operational systems and informational systems.
6. Why are operational systems not suitable for providing strategic information? Give three specific reasons and explain?
7. Name six characteristics of the computing environment needed to provide strategic information?
8. What types of processing takes place in data warehouse? Describe
9. A data warehouse is an environment, not a product. Discuss.
10.Data warehousing is the only viable means to resolve the information crisis and to provide strategic information. List four reasons to support this assertion and explain them.
11.The current trends in hardware/software technology make data warehousing much more feasible. Explain

Business Cases:

1. You are the IT Director of a nationwide insurance company. Write a memo to the Executive Vice President explaining the types of opportunities that can be realized with readily available strategic information.
2. For an airlines company, how can strategic information increases the number of frequent flyers? Discuss giving specific details.
3. You are a Senior Analyst in the IT department of a company manufacturing automobile parts. The marketing VP is complaining about the poor response by IT in    providing strategic information. Draft a proposal to him explaining he reasons for the problems and why a data warehouse would be the only viable solution.

No comments:

Post a Comment