Data Warehouse for the Retail Industry

info Wareho utilization for the Retail Industry Final run Deborah Smith Strayer University CIS 522 Data Warehousing Systems Dr. Wei Huang June 17, 2012 Abstract This newspaper publisher discusses issues for astonish oning a info storage warehouse for the retail industry. The indite identifies and analyzes reasons why Target involve to piddle a cultivation warehouse. Business extremitys are listed. Key interviewees for requirement collection will be listed and reasons given why the author chose them. cream of the information warehouse is discussed. The ETL process is discussed. Topics are discussed on how to build a data warehouse, including a data stick (fact and proportion tables and their relationship) and how users would access the data. In addition, the author discusses how she would support the DW/BI schema in the future. Introduction The retail industry is undergoing a transformation . During the outdated few decades, retailers have pursued operational excellence, setting the skillful stop for dramatic changes in how they make decisions and get hold of success. The drive to alter better performance begins with providing a retail peculiar(prenominal) data warehouse, and a Business Intelligence solution.

The success of a retailer in the future would depend on how efficaciously it manages nine-fold delivery impart like the Internet, interactive TV, catalogs, etc. A single customer is likely to interact with the retailer along multiple channels over a period of time. This calls fo r an coordinate schema to serve the cust! omer well, which requires smooth flow of information crosswise channels. 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: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper