Retail and Customer Profile Analysis and Visualization using Data Mining Techniques
A retail store is an establishment owned or run by an individual or manufacturer who sells products directly to the
ultimate consumers. Retail store owners purchase or buy good or products in volumes either directly from the manufacturers
or from wholesalers at discounted amounts and then sell these products to the consumers with a mark-up for profit. Buyers
or customers of retail stores buy products for their personal use without an intention of re-selling them to other customers.
The manufacturing companies, wholesalers, sales agents or offices, warehouses, retailers, buyers or customers, and
employees are the groups responsible for carrying out the voluminous tasks that jointly determine the realization of corporate
plans. Retailers recognize the processes that will likely increase sales and profits, and sales trends determine the
methodology using exclusive data from the wholesaler. This study aims to describe the profile of customers in terms of age,
gender, and address using customer classification techniques; to determine the sales and profit analysis using classification
techniques, and to determine the sales trends within five years using time series model of data mining. The utilization of data
mining software is an effective tool to execute classification techniques, while time series analysis is used to identify the
sales-profit analysis and sales trend for a certain period of time. After carefully interpreting and validating the outputs of the
data mining tool, the researchers were able to successfully identify the sales profit analysis technique and saleable trend from
May 1, 2010 to April 30, 2018.
Keywords - Sales profit, sales trend, sales transactions, data mining tool, classification analysis, time series techniques