Damanik, Rahul Joshua (2026) Design, implementation, and evaluation of a retrieval-augmented generation conversational AI agent for natural language querying in enterprise data warehouse: a case study at Kitabisa.com. Masters thesis, Politeknik Caltex Riau.
Bab1.pdf
Download (216kB)
Bab2.pdf
Download (338kB)
Bab3.pdf
Restricted to Repository staff only
Download (1MB)
Bab4.pdf
Restricted to Repository staff only
Download (2MB)
Bab5.pdf
Restricted to Repository staff only
Download (180kB)
DaftarPustaka.pdf
Download (156kB)
LembarPengesahan.pdf
Restricted to Repository staff only
Download (888kB)
Dokumen Tesis - Rahul Joshua Damanik.pdf
Restricted to Repository staff only
Download (8MB)
Abstract
Business decision making at Kitabisa.com depends on information held in the corporate data warehouse. Operational teams still struggle to retrieve that data themselves because they lack the technical background, leaving daily requests queued with the data team and allowing business terms to be read differently across divisions. This research designs, implements, and evaluates a conversational artificial-intelligence agent built on Retrieval-Augmented Generation. Regression testing closed at 39 cases, all passed. Across 24 conversational scenarios, 20 analytical questions were answered and 4 risky requests refused. All eleven SQL security rules held, and masking withheld identifying columns. A web evaluation of ten scenarios recorded a mean end-to-end latency of 17,323 ms across a range of 5,063 to 28,564 ms, with every scenario reaching its expected terminal state without manual SQL correction. A seven-item usability assessment with two operational-team respondents scored 4.43 of 5.00, or 88.57 percent of the maximum, indicating that the prototype is fit for first-level analytical exploration by the operational team.
| Item Type: | Thesis (Masters) |
|---|---|
| Subjects: | KBK > KBK Jurusan Teknologi Informasi > KBK Software Engineering |
| Divisions: | Magister Terapan > Jurusan Teknologi Informasi > Magister Terapan Teknik Komputer |
| Depositing User: | Mr Rahul Joshua Damanik |
| Date Deposited: | 26 Aug 2026 03:34 |
| Last Modified: | 26 Aug 2026 03:34 |
| URI: | https://repository.lib.pcr.ac.id/id/eprint/6277 |
