Generic Data Warehousing for Consumer Electronics Retail Industry

Habte, Samson and Ouazzane, Karim and Patel, Preeti and Patel, S. (2017) Generic Data Warehousing for Consumer Electronics Retail Industry. In: 19th International Conference on Database Management Systems Engineering, July 27-28, 2017, Zurich, Switzerland.

[img]
Preview
Text
Journal_paper_generic-data-warehousing-for-consumer-electronics-retail-industry.pdf - Published Version
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (223kB) | Preview
Official URL: https://www.waset.org/Conferences

Abstract

The dynamic and highly competitive nature of the consumer electronics retail industry means that businesses in this industry are experiencing different decision making challenges in relation to pricing, inventory control, consumer satisfaction and product offerings. To overcome the challenges facing retailers and create opportunities, we propose a generic data warehousing solution which can be applied to a wide range of consumer electronics retailers with a minimum configuration. The solution includes a dimensional data model, a template SQL script, a high level architectural descriptions, ETL tool developed using C#, a set of APIs, and data access tools. It has been successfully applied by ASK Outlets Ltd UK resulting in improved productivity and enhanced sales growth.

Item Type: Conference or Workshop Item (Paper)
Uncontrolled Keywords: consumer electronics retail, dimensional data model, data analysis, generic data warehousing, reporting
Subjects: 000 Computer science, information & general works
300 Social sciences > 330 Economics
300 Social sciences > 380 Commerce, communications & transportation
600 Technology > 620 Engineering & allied operations
Department: School of Computing and Digital Media
Related URLs:
Depositing User: Bal Virdee
Date Deposited: 09 Oct 2017 09:39
Last Modified: 09 Oct 2017 09:39
URI: http://repository.londonmet.ac.uk/id/eprint/1268

Actions (login required)

View Item View Item