Generic Data Warehousing for Consumer Electronics Retail Industry

Authors: S. Habte, K. Ouazzane, P. Patel, S. Patel

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.

Keywords: Consumer electronics retail, dimensional data model, data analysis, generic data warehousing, reporting.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1131163

References:

[1] Ralph Kimball and Margy Ross. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (2nd ed.). John Wiley & Sons, Inc., New York, NY, USA. 2002.
[2] Acuma Training Institute: Data Warehouse Design.
[3] Ruth Sara Aguilar-Savén, Business process modelling: Review and framework, International Journal of Production Economics, Volume 90, Issue 2, 28 July 2004, Pages 129-149, ISSN 0925-5273, http://doi.org/10.1016/S0925-5273(03)00102-6.
[4] http://www.appian.com/about-bpm/definition-of-a-business-process (accessed on 18/04/2017).
[5] John Paredes. The Multidimensional Data Modeling Toolkit: Making Your Business Intelligence Application Smart with Oracle OLAP. 2009.
[6] Connolly, T. & Begg, C. Database Systems - A Practical Approach to Design, Implementation and Management (6th ed.), Pearson Education. 2014.
[7] Michelle C. Dy, Michael W. Hawkins, Mark Humphries ‚Data Warehousing: Architecture and Implementation’ Prentice Hall, Release Date: December 1998.
[8] https://www.etltool.com/list-of-etl-tools (accessed on 3/4/2017).