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...

Full description

Bibliographic Details
Main Authors: Habte, Samson, Ouazzane, Karim, Patel, Preeti, Patel, S.
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