Abstract
Point of Sales (POS) terminals are provided by the banking and financial institutes to perform cashless transactions. Over the time due to different conveniences, use of digital money and online card transactions increased many folds. After each successful payment transaction at the POS terminals, a transaction log is sent to the POS terminal provider with payment-related financial data such as date and time, amount, authorization service provider, cardholder’s bank, merchant identifier, store identifier, terminal number, etc. These data are useful for analytical processing which are useful for business. This paper proposes to process these huge transactional data using ETL process and thereafter construction of a data warehouse (DW) which enables the POS provider to employ certain analytical processing for business gain such as knowing own market share as well as position in market with respect to card payments, geographic location-wise business profiling, own as well as competitor’s customer segmentation based on monthly card usage, monthly amount spent, etc.
Keywords
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsReferences
FirstData, Payments 101: Credit and Debit Card Payments, A First Data White Paper, Oct 2010
Herbst-Murphy, S.: Clearing & settlement of interbank card transactions: a MasterCard tutorial for Federal Reserve payments (2013)
Sen, S., Ghosh, R., Paul, D., Chaki, N.: Integrating XML data into multiple Rolap data warehouse schemas. AIRCC Int. J. Softw. Eng. Appl. (IJSEA) 3(1), 197–206 (2012)
Sen, S, Roy, S., Sarkar, A., Chaki, N., Debnath C.N.: Dynamic discovery of query path on the lattice of cuboids using hierarchical data granularity and storage hierarchy. Elsevier J. Comput. Sci. 5(4), 675–683 (2014)
He, M., Li, J., Shao, B., Qin, T., Ren, C.: Transforming massive data to pragmatic target marketing practice. In: 2013 IEEE International Conference on Service Operations and Logistics, and Informatics (SOLI), pp. 408–412. IEEE, July 2013
Avcilar, M.Y., Yakut, E.: Association rules in data mining: an application on a clothing and accessory specialty store. Can. Soc. Sci. 10(3), 75 (2014)
Xie, Y., Zhang, D., Fu, Y., Li, X., Li, H.: Applied research on customer’s consumption behavior of bank POS machine based on data mining. In: 2014 IEEE 9th Conference on Industrial Electronics and Applications (ICIEA), pp. 1975–1979. IEEE, June 2014
Zuo, Y.: Prediction of consumer purchase behaviour using Bayesian network: an operational improvement and new results based on RFID data. Int. J. Knowl. Eng. Soft Data Paradig. 5(2), 85–105 (2016)
Pousttchi, K., Hufenbach, Y.: Enabling evidence-based retail marketing with the use of payment data—the Mobile Payment Reference Model 2.0. Int. J. Bus. Intell. Data Min. 8(1), 19–44 (2013)
Leonard, M., Wolfe, B.: Mining transactional and time series data. Abstract, presentation and paper, SUGI, 10-13 (2005)
Berhe, L.: The Role of Data Mining Technology in Electronic Transaction Expansion at Dashen Bank SC (Doctoral dissertation, AAU) (2011)
Bizhani, M., Tarokh, M.: Behavioral rules of bank’s point-of-sale for segments description and scoring prediction. Int. J. Ind. Eng. Comput. 2(2), 337–350 (2011)
Singh, A., Rumantir, G.W.: Two-tiered clustering classification experiments for market segmentation of EFTPOS retailers. Australas. J. Inf. Syst. 19 (2015)
Singh, A., Rumantir, G., South, A.: Market segmentation of EFTPOS retailers. In: The Proceedings of the Australasian Data Mining Conference (AusDM 2014), Brisbane (2014)
Smith, W.R.: Product differentiation and market segmentation as alternative marketing strategies. J. Mark. 21(1) (1956)
Doyle, C.: A Dictionary of Marketing. Oxford University Press (2011)
Maji, G., Sen, S.: A Data warehouse based analysis on CDR to depict market share of different mobile brands. In: 2015 Annual IEEE India Conference (INDICON). IEEE (2015)
Maji, G., Sen, S.: Data warehouse based analysis on CDR to retain and acquire customers by targeted marketing. In: 5th International Conference on Reliability, Infocom Technologies and Optimization (2016)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2019 Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Maji, G., Dutta, L., Sen, S. (2019). Targeted Marketing and Market Share Analysis on POS Payment Data Using DW and OLAP. In: Abraham, A., Dutta, P., Mandal, J., Bhattacharya, A., Dutta, S. (eds) Emerging Technologies in Data Mining and Information Security. Advances in Intelligent Systems and Computing, vol 813. Springer, Singapore. https://doi.org/10.1007/978-981-13-1498-8_17
Download citation
DOI: https://doi.org/10.1007/978-981-13-1498-8_17
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-13-1497-1
Online ISBN: 978-981-13-1498-8
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)