Generic data warehousing for consumer electronics retail industry
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...
Main Authors: | , , , |
---|---|
Format: | Article |
Language: | English |
Published: |
WASET
2017
|
Subjects: | |
Online Access: | https://repository.londonmet.ac.uk/1268/1/Journal_paper_generic-data-warehousing-for-consumer-electronics-retail-industry.pdf |
_version_ | 1804071654652903424 |
---|---|
author | Habte, Samson Ouazzane, Karim Patel, Preeti Patel, S. |
author_facet | Habte, Samson Ouazzane, Karim Patel, Preeti Patel, S. |
author_sort | Habte, Samson |
collection | LMU |
description | 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. |
first_indexed | 2024-07-09T03:46:41Z |
format | Article |
id | oai:repository.londonmet.ac.uk:1268 |
institution | London Metropolitan University |
language | English |
last_indexed | 2024-07-09T03:46:41Z |
publishDate | 2017 |
publisher | WASET |
record_format | eprints |
spelling | oai:repository.londonmet.ac.uk:12682020-03-18T10:23:25Z http://repository.londonmet.ac.uk/1268/ Generic data warehousing for consumer electronics retail industry Habte, Samson Ouazzane, Karim Patel, Preeti Patel, S. 000 Computer science, information & general works 330 Economics 380 Commerce, communications & transportation 620 Engineering & allied operations 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. WASET 2017-07-25 Article PeerReviewed text en cc_by_nc_nd https://repository.londonmet.ac.uk/1268/1/Journal_paper_generic-data-warehousing-for-consumer-electronics-retail-industry.pdf Habte, Samson, Ouazzane, Karim, Patel, Preeti and Patel, S. (2017) Generic data warehousing for consumer electronics retail industry. World Academy of Science, Engineering and Technology, 11 (7). pp. 828-831. ISSN 1000-7397 https://www.waset.org/Conferences scholar.waset.org/1999.4/10007397 |
spellingShingle | 000 Computer science, information & general works 330 Economics 380 Commerce, communications & transportation 620 Engineering & allied operations Habte, Samson Ouazzane, Karim Patel, Preeti Patel, S. Generic data warehousing for consumer electronics retail industry |
title | Generic data warehousing for consumer electronics retail industry |
title_full | Generic data warehousing for consumer electronics retail industry |
title_fullStr | Generic data warehousing for consumer electronics retail industry |
title_full_unstemmed | Generic data warehousing for consumer electronics retail industry |
title_short | Generic data warehousing for consumer electronics retail industry |
title_sort | generic data warehousing for consumer electronics retail industry |
topic | 000 Computer science, information & general works 330 Economics 380 Commerce, communications & transportation 620 Engineering & allied operations |
url | https://repository.londonmet.ac.uk/1268/1/Journal_paper_generic-data-warehousing-for-consumer-electronics-retail-industry.pdf |
work_keys_str_mv | AT habtesamson genericdatawarehousingforconsumerelectronicsretailindustry AT ouazzanekarim genericdatawarehousingforconsumerelectronicsretailindustry AT patelpreeti genericdatawarehousingforconsumerelectronicsretailindustry AT patels genericdatawarehousingforconsumerelectronicsretailindustry |