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.
Saturday, October 10, 2009
Case 5: 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.
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.
Case 5: 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.
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.
Thursday, July 30, 2009
case 4
1. Do you agree with the argument made by Nick Carr to support his position that IT no longer gives companies a competitive advantage? Why or why not?
I absolutely disagree with Nick Carr, he only focuses on the IT’s disadvantages not thinking about what it helps. However, his expectation about IT was too much that’s why he came up of discouraging people.
2. Do you agree with the argument made by the business leaders in this case in support of the competitive advantage that IT can provide to a business? Why or why not?
Michael Dell was so considerate. He thinks for the better and thinks positively. The emerging technologies helps the people understand IT. IT advanced looking forward to the people’s better performance and services.
What are several ways that IT could provide a competitive advantage to a business? Use some of the companies mentioned in this case as examples. Visit their websites to gather more information to help you answer.
There should be an increase of communication among businesses. It could be the foundation of the business’s development and breakthroughs. The ability of providing new features and information will give the company large profits and increase its efficiency.
I absolutely disagree with Nick Carr, he only focuses on the IT’s disadvantages not thinking about what it helps. However, his expectation about IT was too much that’s why he came up of discouraging people.
2. Do you agree with the argument made by the business leaders in this case in support of the competitive advantage that IT can provide to a business? Why or why not?
Michael Dell was so considerate. He thinks for the better and thinks positively. The emerging technologies helps the people understand IT. IT advanced looking forward to the people’s better performance and services.
What are several ways that IT could provide a competitive advantage to a business? Use some of the companies mentioned in this case as examples. Visit their websites to gather more information to help you answer.
There should be an increase of communication among businesses. It could be the foundation of the business’s development and breakthroughs. The ability of providing new features and information will give the company large profits and increase its efficiency.
Friday, July 17, 2009
case 3
Questions and answers:
1. Why do you think that Aviall failed in their implementation of an enterprise resource planning system? What could they have done differently?
The business and the system are incompatible when it comes to their strategies; the implementation of the system did not support the Business’s supply chain management, a misunderstanding of sufficient system integration among applications.
2.How has information technology brought new business success to Aviall? How did IT change Aviall’s business model?
Answer:
Customers are able to transfer their orders from an Excel spreadsheet directly to the web site.
Customers have access to price and availability information in less thatn five seconds - a real time feature.
Sales force spends more time developing customer relationships than processing routine orders.
3. How could other companies use Aviall’s approach to the use of IT to improve their business success? Give several examples.
Answer:
Reposition a firm as a supply chain management services provider through Web-enabled e-business software systems.
1. Why do you think that Aviall failed in their implementation of an enterprise resource planning system? What could they have done differently?
The business and the system are incompatible when it comes to their strategies; the implementation of the system did not support the Business’s supply chain management, a misunderstanding of sufficient system integration among applications.
2.How has information technology brought new business success to Aviall? How did IT change Aviall’s business model?
Answer:
Customers are able to transfer their orders from an Excel spreadsheet directly to the web site.
Customers have access to price and availability information in less thatn five seconds - a real time feature.
Sales force spends more time developing customer relationships than processing routine orders.
3. How could other companies use Aviall’s approach to the use of IT to improve their business success? Give several examples.
Answer:
Reposition a firm as a supply chain management services provider through Web-enabled e-business software systems.
Thursday, July 16, 2009
Case Study 2
1. Are many of Lufthansa’s challenges identified in the case similar to those being experienced by other businesses in today’s global economy? Explain and provide some examples.
Answer:
Yes, there are some things that somehow can’t be avoided, in order to succeed, we should be aware about these kinds of negative challenges. Like Lufthansa’s challenges, it was also experienced by some business establishments. Company owners should be optimistic regarding their employee’s performance and competitiveness. In addition of employees learning by training and continuity of access to work which will lead them to communication and work effectiveness. Challenges that are being effaced by some businesses nowadays are the effective and vivid communication and negotiation among some other large companies.
2. What other tangible and intangible benefits, beyond those identified by Lufthansa, might a mobile workforce enjoy as a result of deploying mobile technologies? Explain.
Answer:
High technology gadgets like laptops and cameras are some tangible benefits that are constructive for work at home and office as well. The company can save a lot when it comes to expenses and budgeting since they will no longer compensate for training facilities, manuals, travel fares and trainers/teachers. Some intangible benefits would be a more devoted, industrious and effective employees that will move and work in a contended environment.
3. Lufthansa was clearly taking a big risk with their decision to deploy notebook computers to their pilots. What steps did they take to manage that risk and what others might be needed in today’s business environment? Provide some examples.
Answer:Lufthansa was so creative, they came up to a preference that creation of list of parameters that notebook PCs needs to meet before purchasing the laptops that is useful to the business and they have created their own secure network.
Answer:
Yes, there are some things that somehow can’t be avoided, in order to succeed, we should be aware about these kinds of negative challenges. Like Lufthansa’s challenges, it was also experienced by some business establishments. Company owners should be optimistic regarding their employee’s performance and competitiveness. In addition of employees learning by training and continuity of access to work which will lead them to communication and work effectiveness. Challenges that are being effaced by some businesses nowadays are the effective and vivid communication and negotiation among some other large companies.
2. What other tangible and intangible benefits, beyond those identified by Lufthansa, might a mobile workforce enjoy as a result of deploying mobile technologies? Explain.
Answer:
High technology gadgets like laptops and cameras are some tangible benefits that are constructive for work at home and office as well. The company can save a lot when it comes to expenses and budgeting since they will no longer compensate for training facilities, manuals, travel fares and trainers/teachers. Some intangible benefits would be a more devoted, industrious and effective employees that will move and work in a contended environment.
3. Lufthansa was clearly taking a big risk with their decision to deploy notebook computers to their pilots. What steps did they take to manage that risk and what others might be needed in today’s business environment? Provide some examples.
Answer:Lufthansa was so creative, they came up to a preference that creation of list of parameters that notebook PCs needs to meet before purchasing the laptops that is useful to the business and they have created their own secure network.
Saturday, July 4, 2009
case study
1. Could the 2004 Athens Olympics have been a success without all of the networks and backup technologies?
Answer: It’s definitely not. It will not be successful event since the major events were dependent to the system developed by Atos Origin.
2. The 2004 Olympics is a global business. Can a business today succeed without information technology? Why or why not?
Answer:
Absolutely, the competitions among businesses were emphasized nowadays. The difficulties will be prevailed if businessmen will follow the rules of Information Technology. Online businessmen are aggressive when it comes to catering their customers’ needs and anticipations. Raising an online business will help merchants increase their yields. The emerging online businesses will be competition for all.
3. Claude Philipps said dealing with “crazy scenarios of what might happen in every area: a network problem, staff stopped in a traffic jam, a security attack . . . everything that might happen,” was the reason for so much testing. Can you think of other businesses that would require “crazy scenario” testing? Explain.
Answer:
These weird scenarios may occur. Some paranoid will be anticipating these kinds of things. But effacing these kinds of prediction will took place of a more secure possibility of a safe system. We should be optimistic if a certain scenario or circumstance like this occurs, it would also be a help for us if we try to deal with it and try to elucidate things out.
Answer: It’s definitely not. It will not be successful event since the major events were dependent to the system developed by Atos Origin.
2. The 2004 Olympics is a global business. Can a business today succeed without information technology? Why or why not?
Answer:
Absolutely, the competitions among businesses were emphasized nowadays. The difficulties will be prevailed if businessmen will follow the rules of Information Technology. Online businessmen are aggressive when it comes to catering their customers’ needs and anticipations. Raising an online business will help merchants increase their yields. The emerging online businesses will be competition for all.
3. Claude Philipps said dealing with “crazy scenarios of what might happen in every area: a network problem, staff stopped in a traffic jam, a security attack . . . everything that might happen,” was the reason for so much testing. Can you think of other businesses that would require “crazy scenario” testing? Explain.
Answer:
These weird scenarios may occur. Some paranoid will be anticipating these kinds of things. But effacing these kinds of prediction will took place of a more secure possibility of a safe system. We should be optimistic if a certain scenario or circumstance like this occurs, it would also be a help for us if we try to deal with it and try to elucidate things out.
Subscribe to:
Posts (Atom)
