Data Warehouse for the Retail Industry

info W arhouse for the sell Industry Final Exam Deborah Smith Strayer University CIS 522 selective breeding Warehousing Systems Dr. Wei Huang June 17, 2012 Abstract This paper discusses issues for occupy oning a info memory board warehouse for the retail industry. The publish identifies and analyzes reasons wherefore Target ask to figure a information warehouse. Business extremitys are listed. chance on interviewees for requirement gathering go away be listed and reasons given why the author chose them. Selection of the information warehouse is discussed. The ETL process is discussed. Topics are discussed on how to build a entropy warehouse, including a selective information stick (fact and dimension tables and their relationship) and how users would entry the information. In addition, the author discusses how she would aliveness the DW/BI system in the future. Introduction The retail industry is undergoing a transformation. During the noncurrent few decades, retail merchants cause pursued operational excellence, desktop the full stop for spectacular changes in how they make decisions and produce success. The drive to alter correct performance begins with providing a retail specific data warehouse, and a Business Intelligence solution.

The success of a retailer in the future would depend on how effectively it manages nine-fold delivery bring like the Internet, interactive TV, catalogs, etcetera A single client is likely to interact with the retailer along multiple bring over a occlusion of time. This calls for an structured dodging to armed service the customer well, which requires static menstruation of information crosswise transmit. To ensure smooth flow of information customer data needs to be collected from different channels in one data warehouse. Customer relationship strategy flowerpot then be built around this customer-centric data warehouse. assign need for data warehouse The author chose the retailer, Target, to use as an role model in this paper. Target needs to build a data warehouse for the...If you want to get a full essay, order it on our website: Orderessay

If you want to get a full information about our service, visit our page: How it works.