A conversational data analysis system using large language model

Abstract

In today’s data-driven environment, the ability to explore and manipulate datasets is essential, however, many existing data analysis tools require technical expertise in platforms such as Excel, Python, or Power BI, creating accessibility barriers for non-technical users. This project presents Quiksight, a web-based conversational data analysis system powered by Large Language Models (LLMs) that enables users to interact with datasets using natural language. The objective of this work was to develop an intuitive system that simplifies data analysis by allowing users to upload Excel or CSV files and perform operations such as filtering, sorting, summarization, column modification, missing-value handling, and data export without writing code. The system was implemented using Google Gemini as the LLM, FastAPI for backend processing, and HTML, JavaScript, and Tailwind CSS for the frontend interface.Evaluation showed that Quiksight successfully interpreted and executed a wide range of natural language data manipulation queries with high accuracy. Testing recorded an average query response time of approximately 2 seconds, while dataset uploads up to 30MB remained below 20 seconds under suitable network conditions. Compared with existing platforms such as Julius.ai and PowerDrill.ai, Quiksight demonstrated advantages through its lightweight architecture, simplified interaction model, and focus on everyday users. The project demonstrates the feasibility of LLM-powered conversational interfaces for democratizing data analysis. Future improvements include database integration, support for larger datasets, and advanced analytical capabilities such as statistical modelling.