Browsing by Author "Contreras Alqui, Jessica del Rocío"

Filter results by typing the first few letters
Now showing 1 - 1 of 1
  • No Thumbnail Available
    Item
    Business intelligence aplicando la plataforma Zoho Analytics para la toma de decisiones dentro de la empresa Holviplas S.A.
    (Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas, Electrónica e Industrial. Carrera de Ingeniería en Sistemas Computacionales e Informáticos, 2024-08) Contreras Alqui, Jessica del Rocío; Chicaiza Castillo, Dennis Vinicio
    Holviplas S.A. is a corporation created in 1993, its line of business is the production of PVC compound, to supply as raw material to footwear and profile industries. The objective of this research work was: To apply a Business Intelligence model for decision making in the sales area, applying the Zoho Analytics platform for Holviplas S.A. company. The methodology that followed the research is conformed by a documentary research, based on the review of secondary information of industries that have used BI in their processes, while the field research suggests the collection of primary information, through the defined instruments: Process check sheet, benchmarking and interview to the sales personnel and area manager. The study population is made up of 4 collaborators, who were responsible for providing the information required for the elaboration of the solution proposal. The results show the lack of a software to manage sales in a standardized way, being Excel the most used program by the sales force, however, the limitations of the program are emphasized in terms of long time to keep the account of a single customer, lack of sales tracking tools, does not allow maintaining information on competition, prices, or numerous databases. It was possible to establish that by means of a BI model, the use of scientific tools and techniques for data analysis and trend forecasting, for this purpose, Zoho Analytics was implemented, using ETL methodology, the software consists of the following panels: net sales-analysis, profit-analysis and net sales-profit. It was concluded that methodologies such as ETL, data mining and statistical methods, improve visibility and access to information, due to the integration of data, reports and dashboards in real time, descriptive or predictive analysis, sales team performance, among other specific reports such as sales and marketing analysis, financial performance tracking, supply chain analysis and customer analysis