Search for collections on Repository Library PCR

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

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.

[thumbnail of Bab1.pdf] Text
Bab1.pdf

Download (216kB)
[thumbnail of Bab2.pdf] Text
Bab2.pdf

Download (338kB)
[thumbnail of Bab3.pdf] Text
Bab3.pdf
Restricted to Repository staff only

Download (1MB)
[thumbnail of Bab4.pdf] Text
Bab4.pdf
Restricted to Repository staff only

Download (2MB)
[thumbnail of Bab5.pdf] Text
Bab5.pdf
Restricted to Repository staff only

Download (180kB)
[thumbnail of DaftarPustaka.pdf] Text
DaftarPustaka.pdf

Download (156kB)
[thumbnail of LembarPengesahan.pdf] Text
LembarPengesahan.pdf
Restricted to Repository staff only

Download (888kB)
[thumbnail of Dokumen Tesis - Rahul Joshua Damanik.pdf] Text
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

Actions (login required)

View Item
View Item