Application: Constructing a Data Warehouse for a Growing Company
Application: Constructing a Data Warehouse for a Growing Company
The merged company described in Unit 4 continues to grow. More stores have been added and Internet sales are growing. The company is now considering expanding internationally.
Before expansion, the company wants to explore new ways to grow, cut costs, and increase profits. In order to study the company’s sales patterns and determine their needs, the management has decided to establish a data warehouse.
The merged data will be moved into the new warehouse. However, the following questions need to be answered prior to warehouse construction. In this Application, write a 2- to 3-page paper to answer the questions listed below.
What other external feeds should be included? These can be from partners, government services, or other available RSS feeds. Explain.
When the data was moved into the merged database, duplicates were eliminated and errors removed. How do we ensure only clean data will be entered into the data warehouse?
How frequently should the data in the data warehouse be updated? Remember the cost is inversely proportional to the time, i.e., the shorter the load interval the higher the cost. Should the update interval be the same for all feeds? Justify your answer.
Can the updates be done in parallel? Do any require sequential order?
……………………….Answer preview…………………….
Data warehouse refers to large store of data gathered from variety of sources within a company which enable management and running of the company. Before data warehouse is put in place there is need to consider some driving factors.
External feeds to be considered before installation of ware house include; flow, accessibility, space and throughput. Enough space should be put in place during planning stage to ensure enough working platform. Working platform may…………………..
APA
646 words
Get instant access to the full solution from yourhomeworksolutions by clicking the purchase button below
