APPROACHES TO CUSTOMER DATA MANAGEMENT AND KNOWLEDGE DISCOVERY IN SMALL RETAIL ANALYTICS: THE CASE OF A TINY COFFEE SHOP IN BANGKOK, THAILAND

Authors

อ.ดร.อัครนันท์ พงศธรวิวัฒน์, นายPakawat Paiboon

Published

The 8th Business, Economics and Communications International Conference

Abstract

Although coffee shop is the highest competition comparing to others in Thailand for the past four years, only 10% of all new restaurants are success. To increase a success rate, data as an important resource needs to be significantly used to increase sales and maintain advantages. However, complications of data processing and lacking analytical models are common challenges to small businesses management as it requires huge investment on data management system. This study proposed data management framework as economically solutions to processing existing customer data into actions. Data from the tiny coffee shop in Bangkok as our case study are used for illustration. In data management, existing data were designed to combine all daily transactions into one structural file by using python script and use it as a data source for reporting. As of reporting, LINE chatbot was selected as a channel to send quick reports and analytic results of co-occurrence items, and Dashboards with interactive filtering ability via Power BI are employed for detailing sale information. These approaches can help owners to have deep understanding on sale and customer data which leads to better profits, and be applied to any retails that face with similar issues of customer analytics.

APPROACHES TO CUSTOMER DATA MANAGEMENT AND KNOWLEDGE DISCOVERY IN SMALL RETAIL ANALYTICS: THE CASE OF A TINY COFFEE SHOP IN BANGKOK, THAILAND. faculty of Business, Economics and Communications, Naresuan University, Phitsanulok, THAILAND., The 8th Business, Economics and Communications International Conference (27-36).