Functional Salon Website for Service Display and Online Booking Management for Gold and Gorgeous Salon using Prescriptive Analysis and K-Means Clustering

The system was designed to address issues related to manual booking processes, inconsistent service promotion, and lack of customer data utilization. By incorporating Prescriptive Analysis, the system provides intelligent recommendations for staff scheduling, promotional offers, and service optimization based on real-time customer and business data. The K-Means Clustering algorithm categorizes customers into segments according to their booking frequency, preferred services, and spending behavior. These insights enable the salon to implement personalized marketing strategies and loyalty programs that strengthen customer engagement and satisfaction. Gold and Gorgeous Salon, a local full-service salon located in Pasig City, faces challenges in digital promotion and appointment handling. The lack of an organized online platform makes it difficult for customers to book services and for the salon to consistently promote its offers. The business currently relies on walk-ins, referrals, and manual social media replies, which are time-consuming and prone to missed inquiries. The system also features a dynamic dashboard and automated report generation that visualizes key performance indicators such as service demand, booking trends, and revenue distribution. The integration of analytics into the website helps administrators make data-driven decisions, improving both operational management and customer service quality. To ensure system effectiveness, a total of 150 participants composed of one owner, ten employees, one hundred customers, twelve IT professionals, and twenty-seven IT students evaluated the system using the ISO 25010 quality model, focusing on five characteristics: functionality, reliability, usability, efficiency, and maintainability. Results from the Likert-scale evaluation revealed high satisfaction levels across all dimensions, confirming that the system met both user and technical expectations.
The findings demonstrate that combining prescriptive analytics and machine learning algorithms can significantly improve service industry operations, particularly in appointment-based businesses. The developed system not only digitizes booking and service management but also introduces intelligent insights for business growth and strategic planning. It also provides a framework for integrating data analytics into small and medium enterprises (SMEs), encouraging digital transformation in traditional service sectors. Overall, the project offers a scalable and innovative approach that bridges technology and customer relationship management, positioning Gold and Gorgeous Salon for improved competitiveness in the digital marketplace.

Prescriptive Analysis, K-Means Clustering, Salon Website

1. Chiu, C. M., Hsu, M. H., Lai, H., & Chang, C. M. (2017). Re-examining the influence of trust on online repeat purchase intention: The moderating role of habit and its antecedents. Decision Support Systems, 53(4), 835–845. [Google Scholar] [Crossref]

2. Davenport, T. H., & Harris, J. G. (2017). Competing on analytics: The new science of winning. Harvard Business Press. [Google Scholar] [Crossref]

3. Han, J., Kamber, M., & Pei, J. (2012). Data mining: Concepts and techniques (3rd ed.). Morgan Kaufmann Publishers. [Google Scholar] [Crossref]

4. Jain, A. K. (2010). Data clustering: 50 years beyond K-Means. Pattern Recognition Letters, 31(8), 651–666. [Google Scholar] [Crossref]

5. Kumar, S., & Singh, R. (2023). Customer segmentation using K-Means clustering for data-driven marketing decisions. International Journal of Computer Applications and Artificial Intelligence, 15(2), 45–58. [Google Scholar] [Crossref]

6. Liao, S. H., Chen, Y. J., & Wu, C. H. (2015). Mining customer knowledge for product line and brand extension in retailing. Expert Systems with Applications, 36(1), 886–894. [Google Scholar] [Crossref]

7. Lopez, M. A., & Rivera, D. P. (2021). Adoption of online booking systems in local enterprises: Enhancing accessibility and service convenience. Asia-Pacific Journal of Information Systems, 28(4), 201–214. [Google Scholar] [Crossref]

8. Provost, F., & Fawcett, T. (2013). Data science for business: What you need to know about data mining and data-analytic thinking. O’Reilly Media. [Google Scholar] [Crossref]

9. Raghupathi, W., & Raghupathi, V. (2014). Big data analytics in healthcare: Promise and potential. Health Information Science and Systems, 2(1), 3. [Google Scholar] [Crossref]

10. Xu, R., & Wunsch, D. (2005). Survey of clustering algorithms. IEEE Transactions on Neural Networks, 16(3), 645–678. [Google Scholar] [Crossref]

• Smart Iot Device for Weather And Health
• Merlarchive: A Web-Based Academic Hub for UDM With AI-Powered Natural Language Processing
• Enhanced Social Network Security System: Integrating Biometric Authentication for Improved User Verification and Privacy Protection
• Smart Budget Allocation in Public Policy: A Data-Driven Approach for Equitable Resource Distribution
• Decision Support System for Faculty Selection, Promotion, and Reclassification Using Predictive Analytics