Salim, Dzaky Rantisi (2026) Analisis Kinerja Gross Adds, New Customer Acquisition, Subscriber With Event, Survival Rate, Dan Revenue Wilayah East Java Serta Implementasi Sistem Otomasi Video Presentasi Berbasis Kecerdasan Artifisial(AI) Pada PT XLSMART Telcom Sejahtra Tbk. Project Report. [s.n.]. (Unpublished)
![[thumbnail of 5025231271-Project_Report.pdf]](http://repository.its.ac.id/style/images/fileicons/text.png) |
Text
5025231271-Project_Report.pdf - Accepted Version Restricted to Repository staff only Download (1MB) | Request a copy |
Abstract
PT. XLSmart Telecom Sejahtera Tbk merupakan perusahaan telekomunikasi terkemuka di Indonesia yang mengoperasikan merek XL, AXIS, dan Smartfren yang secara gabungan disebut brand XLSMART. Kerja praktik ini dilaksanakan dengan fokus pada analisis lima metrik kinerja bisnis utama: Gross Adds Real (GA Real), New Customer Acquisition (NCA), Subscriber with Event (SWE), Survival Rate, dan Revenue per Layanan, dengan cakupan wilayah East Java (region EAST) yang terdiri dari tiga cluster — E-Greater Malang, E-New Greater Madiun, dan E-New Greater Suramadu — serta 20 Micro Cluster (MC). Seluruh analisis dilakukan menggunakan Microsoft Excel dengan fitur Pivot Table. GA Real XLSMART produk SP 3GB East Java tumbuh dari 719,35 (Agustus 2025) menjadi 5.500,48 (Januari 2026); kenaikan yang sangat tinggi ini terjadi karena SP 3GB merupakan produk baru yang mulai diproduksi dan didistribusikan sejak Agustus 2025, sehingga basis pembandingnya masih rendah. Diukur dari Oktober 2025 saat distribusi mulai masif, kenaikannya mencapai 79,2%. NCA XLSMART SP 3GB mencapai 4.024,58 pada Januari 2026 dengan rasio NCA/GA Real 73,2%, sementara realisasi NCA total terhadap target East Java (9.269,82) mencapai 76,1%. SWE Cluster E-Greater Malang terkoreksi 11,9% sepanjang 2025. Survival Rate XLSMART SP 3GB NCA East Java menunjukkan SR M1 84,8%, SR M2 57,2%, dan SR M3 50,1% — artinya sebanyak 50,1% pelanggan bertahan selama 3 bulan sejak awal aktivasi. Revenue XLSMART East Java tercatat Rp 8,64 triliun pada Januari 2026, terkoreksi 2,5% dari Desember 2025. Sebagai pelengkap alur pelaporan, diimplementasikan pula sistem otomasi video presentasi berbasis kecerdasan artifisial (AI) yang mengonversi dokumen slide laporan hasil analisis (.pptx/.pdf) menjadi video .mp4 ber-voiceover secara otomatis: elemen visual slide diekstraksi melalui LibreOffice Headless dan pdftoppm, narasi suara disintesis oleh model deep learning Google Text-to-Speech (gTTS), lalu dikomposisikan oleh FFmpeg CLI, dengan antarmuka web Streamlit bagi pengguna non-teknis. Pengujian menunjukkan seluruh alur kerja sistem berjalan fungsional sesuai kriteria evaluasi.
=================================================================================================================================
PT. XLSmart Telecom Sejahtera Tbk is a prominent telecommunications company in Indonesia, operating the XL, AXIS, and Smartfren brands, collectively referred to as the XLSMART brand. This internship focused on analyzing five key business performance metrics: Gross Adds Real (GA Real), New Customer Acquisition (NCA), Subscriber with Event (SWE), Survival Rate, and Revenue per Service, covering the East Java region (Region EAST), which comprises three clusters—E-Greater Malang, E-New Greater Madiun, and E-New Greater Suramadu—along with 20 Micro Clusters (MC). All analyses were conducted using Microsoft Excel's Pivot Table features.
The GA Real for the XLSMART 3GB Starter Pack (SP) in East Java grew from 719.35 in August 2025 to 5,500.48 in January 2026. This significant growth is attributed to the fact that the 3GB SP was a newly introduced product in August 2025, resulting in a low baseline; however, since mass distribution commenced in October 2025, growth reached 79.2%. The NCA for the XLSMART 3GB SP reached 4,024.58 in January 2026, with an NCA to GA Real ratio of 73.2%, while the total NCA realization against the East Java target (9,269.82) achieved 76.1%. During 2025, the SWE for the E-Greater Malang cluster experienced a 11.9% correction. The Survival Rate (SR) for the XLSMART 3GB SP NCA in East Java showed an SR M1 of 84.8%, SR M2 of 57.2%, and SR M3 of 50.1%, indicating that 50.1% of customers were retained for three months post-activation. Furthermore, total revenue for XLSMART in East Java was recorded at IDR 8.64 trillion in January 2026, a 2.5% correction from December 2025.
To complement the reporting workflow, an AI-based automated video presentation system was implemented, converting report slide decks (.pptx/.pdf) into voiceover-enabled .mp4 videos. Visual elements were extracted via LibreOffice Headless and pdftoppm, narrative audio was synthesized using the Google Text-to-Speech (gTTS) deep learning model, and final composition was performed via FFmpeg CLI, with a Streamlit web interface provided for non-technical users. Testing confirmed that the entire workflow functions effectively in accordance with established evaluation criteria.
| Item Type: | Monograph (Project Report) |
|---|---|
| Uncontrolled Keywords: | Gross Adds, NCA, SWE, Survival Rate, Revenue, XLSMART, East Java, Pivot Table, Kecerdasan Artifisial, Otomasi Video Presentasi, Text-to-Speech ================================================================== Gross Adds, NCA, SWE, Survival Rate, Revenue, XLSMART, East Java, Pivot Table, Artificial Intelligence, Presentation Video Automation, Text-to-Speech |
| Subjects: | T Technology > T Technology (General) T Technology > T Technology (General) > T57.5 Data Processing T Technology > T Technology (General) > T58.8 Productivity. Efficiency |
| Divisions: | Faculty of Intelligent Electrical and Informatics Technology (ELECTICS) > Informatics Engineering > 55201-(S1) Undergraduate Thesis |
| Depositing User: | Dzaky Rantisi Salim |
| Date Deposited: | 17 Jul 2026 06:05 |
| Last Modified: | 17 Jul 2026 06:05 |
| URI: | http://repository.its.ac.id/id/eprint/134521 |
Actions (login required)
 |
View Item |