Reference no: EM132798127
Question:
Case study: Kim Pharmaceuticals Limited (KPL) problematic Enterprise Data Warehouse
Kim Pharmaceuticals Limited (KPL) was established in 2010. KPL has several offices in Korea, Macao and Thailand. KPL had identified the importance of establishing Enterprise Data Warehousing (EDW) in its initial days and established EDW in 2012.The objectives of establishing EDW were significantly shortening of research cycle that leads to a new drug development, breakthrough marketing policies for new and current drugs, identification of potential customers and practitioners, provision of better customer satisfaction policy, process optimization of several practices and strategic planning. KPL progressed by establishing and implementing all functional business processes and ERP. EDW also grew by storing large amount of data. However, during these years KPL couldn't focus on the upgrade of EDW and higher management stated to experience more processing time for analytical reports generations, inaccurate analysis, less flexibility and difficulty in handling of analytical dashboard. Furthermore, ERP and EDW have not been integrated.
Case questions:
a. What necessary steps should be taken for the ERP and EDW integration in KPL?
b. Identify the technical issues which may have resulted in these limitations which KPL higher management is facing?
c. Propose and explain Enterprise Data Warehouse architecture that will suitable for the KPL EDW.
d. What will the hardware requirements for the proposed EDW architecture, explain in detail.
(Answer should must be logical and in detail)
|
Capita consumption of milk in the united states
: According to a recent study annual per capita consumption of milk in the United States is 22.6 gallons. Being from the Midwest, you believe milk consumption
|
|
What was the amount of inventory on January at cost
: At the end of 2019, the branch reported an inventory of P15,000. What was the amount of inventory on January 1, 2019 at cost
|
|
Apply to a forecasting model
: What are some real situations, problems, or subjects that exist in the real world that I can apply to a Forecasting Model?
|
|
Aquatech international corporation erp implementation
: Aquatech International Corporation was established in 1981 and specialized in pure water systems for the power industry.
|
|
Requirements for the proposed edw architecture
: Kim Pharmaceuticals Limited (KPL) was established in 2010. KPL has several offices in Korea, Macao and Thailand. KPL had identified the importance
|
|
Analyze your eating habits and nutrition intake
: Write a nutritional self-assessment paper. In your paper, you will analyze your eating habits, food patterns, and nutrition intake. You will use the MyFitness.
|
|
How much is the total amount for reversal
: Accumulated depreciation 5,000. How much is the total amount for reversal at the start of the next fiscal year relating to these adjusting entries
|
|
Heart disease provide local epidemiological data
: Heart Disease Provide local epidemiological data for the disease - Discussion of the changes to the anatomy and physiology as a result of the disease
|
|
Discuss evaluating the models
: Discuss evaluating the models the ensue their appropriateness for individual and group career development sessions
|