AI Assistant for Report Generation & Visualization

We received a request to develop a comprehensive tool for Business Analysts that offers seamless querying, code generation for visualizations, and effortless database management for up-to-date information retrieval.

Our team’s AI solution helped the client to provide their Business Analysts with the tools needed to independently access and visualize data, significantly reducing their reliance on the IT department. Those efforts streamlined the decision-making process and allowed IT resources to be reallocated to more strategic projects.

• On-fly translation of verbal questions to SQL query (MS SQL, PostgreSQL, 
• AWS Redshift, MongoDB)
• SQL query execution for a selected schema
• Python AI coder – convert final data set to a web-based dashboard/chart
• integrated with Slack, can be deployed to the cloud (AWS, Azure)

We’ve developed a tool as a cloud-based project management platform chatbot and a web-based application, allowing business analysts to ask verbal questions and run queries against different databases through their preferred medium.

Once the dataset is set, the application automatically generates Python code using libraries. This code then creates a comprehensive web-based dashboard featuring charts, time series plots, and graphs, allowing analysts to gain insights quickly and effectively.

By leveraging large language models (LLMs) like GPT and open-source solutions, the tool can automatically fix errors and ensure that the Python code generated meets the required quality standards. 

The application intelligently recognizes database schemas based on user queries and constructs SQL queries using pre-defined SQL Data Definition Language (DDL) stored in VectorDB. Additionally, the system includes a Python-based pipeline that automatically refreshes information about database schemas and table DDLs, ensuring that analysts can always access the most current data.

We developed a comprehensive tool specifically designed for Business Analysts. Our team managed the entire project lifecycle, starting with the discovery phase and proof of concept (POC), resulting in the development of a final product.