Back to Portfolio
FLAGSHIP AI PROJECT

InsightGPT

AI-powered Business Intelligence Copilot that transforms natural-language business questions into SQL analysis, data-driven insights, visualizations and actionable recommendations.

Python SQL FastAPI Gemini AI Streamlit Machine Learning

The Business Problem

Business teams often depend on analysts to translate business questions into SQL queries, reports and dashboards before they can make decisions. InsightGPT reduces this gap by allowing users to ask business questions in natural language and receive analytical results, insights and recommendations.

The Solution

InsightGPT combines Business Intelligence, SQL analytics, Generative AI, REST APIs, interactive visualization and predictive analytics into a single decision-support platform.

AI Business Copilot

Ask business questions in natural language instead of manually writing SQL queries.

InsightGPT AI Business Copilot

From Question to Business Decision

Natural Language

Users ask business questions using everyday language without writing SQL.

SQL Generation

Gemini converts the business question into an analytical SQL query.

SQL Validation

Generated SQL is validated before execution to provide a safety layer for database operations.

PostgreSQL Analytics

Validated analytical queries are executed against the PostgreSQL business database.

Result & Visualization

Query results can be explored through tables and interactive visualizations.

Business Insight

Analytical results are translated into business insights and recommendations.

Executive Business Intelligence Dashboard

Interactive KPI monitoring and business performance analysis across revenue, orders, categories and customers.

InsightGPT Business Intelligence Dashboard

Key Business Metrics

$16.0M

Total Revenue

99.4K

Total Orders

$160.99

Average Order Value

100K+

Order Records

AI-Generated Business Analysis

InsightGPT connects the generated SQL result with business interpretation instead of returning raw data alone.

InsightGPT AI generated business insight and result

Transparent AI-Generated SQL

The generated SQL can be inspected by the user, providing transparency into how the AI produced the result.

InsightGPT generated SQL query

Business Intelligence Capabilities

Revenue Analytics

Analyze total revenue, monthly trends, average order value and category performance.

Customer Analytics

Analyze customer reviews, ratings and customer-related business patterns.

Product Analytics

Identify high-performing product categories and revenue contributors.

Geographic Analytics

Compare business performance across different states and geographic segments.

Predictive Analytics — Revenue Forecast

Historical revenue is combined with machine-learning-based forecasting to provide a forward-looking view of business performance.

InsightGPT revenue forecast

Technology Stack

Data & Database

PostgreSQL · SQLAlchemy · Psycopg2

Analytics

Python · Pandas · NumPy · SQL

AI

Google Gemini API · Generative AI · Natural Language to SQL

Backend

FastAPI · REST APIs · Uvicorn

Visualization

Streamlit · Plotly

Machine Learning

Scikit-learn · Revenue Forecasting

Testing

Pytest · HTTPX

Deployment

Git · GitHub · Render

From Data to Decision

Data

Business data stored and analyzed through PostgreSQL and SQL.

Analysis

Python and analytical SQL transform raw records into measurable results.

Intelligence

Generative AI interprets results and enables natural-language interaction.

Decision

Insights and recommendations help stakeholders move from analysis to action.

Explore InsightGPT

Explore the complete source code, architecture, analytics modules, AI Copilot and deployed application.