Pengembangan Dashboard Penjualan Direct Sales Menggunakan Streamlit dan MySQL di PT Indosat Tbk Jawa Timur

Widison, Daffin Tanjiro (2024) Pengembangan Dashboard Penjualan Direct Sales Menggunakan Streamlit dan MySQL di PT Indosat Tbk Jawa Timur. Project Report (Praktek Kerja Lapang dan Magang). UPN Veteran Jawa Timur. (Unpublished)

	Text (Cover) 22083010010-cover.pdf Download (791kB)
	Text (Bab 1) 22083010010-bab1.pdf Download (167kB)
	Text (Bab 2) 22083010010-bab2.pdf Download (419kB)
	Text (Bab 3) 22083010010-bab3.pdf Restricted to Repository staff only until 19 July 2029. Download (1MB)
	Text (Bab 4) 22083010010-bab4.pdf Restricted to Repository staff only until 19 July 2029. Download (121kB)
	Text (Daftar Pustaka) 22083010010-daftarpustaka.pdf Download (121kB)
	Text (Lampiran) 22083010010-lampiran.pdf Restricted to Repository staff only until 19 July 2029. Download (875kB)

Abstract

Field Work Practice (PKL) at PT Indosat Tbk East Java aims to provide direct experience in the world of work as well as produce solutions to technical problems faced by the Direct Sales Division. This division has the main responsibility in selling postpaid products directly to customers. During the PKL implementation, the author identified various obstacles in managing and analyzing sales data, including data processing that is still done manually using Excel, ineffective data visualization, and limitations in presenting information quickly and accurately. As a solution, the author developed a web-based sales dashboard using Streamlit framework and MySQL database management system. This dashboard is designed to simplify data management, provide interactive visualization, and improve the division's operational efficiency. The development process includes several stages, namely problem identification, data preparation, data processing, analysis, and implementation of analysis results into the dashboard. Raw data received from the head office was processed using Python, with libraries such as Pandas for data cleaning and Plotly for visualization. The developed dashboard presents key features such as daily sales trends, cumulative revenue analysis, performance comparison among Retail Channel Executives (RCEs), and sales agent performance statistics. In addition, the dashboard is also equipped with the ability to upload new data and manage the database directly, allowing users to update data easily. The implementation of this project provides significant benefits to the company, especially in making faster and more precise data-based decisions. Through this PKL, the author not only gained practical experience in data-driven application development but also gained insight into the importance of technology integration to support company operations. This project is expected to be a sustainable solution that can be improved in the future to support the company's business needs.

Item Type:

Monograph (Project Report (Praktek Kerja Lapang dan Magang))

Contributors: