Browsing by Author "Pilatasig Ayala, Robinson Eduardo"

Now showing 1 - 1 of 1
  • No Thumbnail Available
    Item
    Sistema de gestión con analítica de datos para optimizar las ventas en la lubricadora “Jonathan” del cantón La Maná
    (Universidad Técnica de Cotopaxi (UTC). La Mana. Sistemas de Información, 2026-10-16) Pilatasig Ayala, Robinson Eduardo; Unapucha Toapaxi, Mireya Cecibel; Cunuhay Cuchipe, Wilmer Clemente
    Automotive microenterprises face limitations arising from the manual management of information, which scatters data and hinders evidence-based decision-making. The objective of this study was to design, develop, and implement a management system with data analytics capabilities to optimize sales at the "Jonathan" Lubrication Shop in La Maná canton (Ecuador), and to assess its impact through operational indicators. A mixed-methods approach with a non-experimental design was adopted, structured as a case study comprising a cross-sectional diagnostic phase and a pre-post evaluation; data were collected from 97 participants through surveys and semi-structured interviews. The diagnosis revealed that 34.83% of customers experienced problems when requesting services, mainly due to poor communication (46.97%) and lack of available products (33.33%), and that 67.39% had abandoned purchases because of stockouts. The system, built with Django REST Framework, Next.js, and PostgreSQL under the Scrum methodology, integrated modules for inventory with automatic alerts, point of sale, CRM with customer segmentation, and interactive dashboards. After three months of operation, a 75% reduction in sales registration time, an 89% decrease in inventory errors, and a 78% reduction in stockout incidents were recorded, along with an increase in staff satisfaction from 2.8 to 4.3 out of five points. The findings provided a replicable, affordable model for the digitalization of SMEs in Latin American contexts. General area of study: Information and Communication Technologies (ICT) / Systems Engineering. Specific area of study: Business Intelligence, Data Analytics, Sales Management Systems. Type of study: Original articles.