InsightAI Dashboard

Challenge

Enterprise teams drown in dashboards that show metrics but not meaning. Leadership wanted a tool that could answer plain-English questions about revenue, churn, and operational health without a SQL translation step.

Approach

I built a Next.js front end backed by a FastAPI service that wraps an LLM with a guarded schema-constrained tool-calling layer. The model translates a user question into a parameterized SQL query against PostgreSQL, executes it, and returns both the data and a plain-English narrative. Interactive charts render the structured payload.

Outcome

• Cut average "question to insight" time from two days to under a minute.
• Adopted by three internal teams in the first quarter.
• Guarded tool-calling kept risky queries off production with zero incidents.