Business AI
Analyze any company and unlock valuable insights.
10+
Data sources supported
< 3s
Report generation time
99.9%
Uptime
96
Lighthouse
The story
An AI-powered business analysis platform that helps users analyze companies and generate valuable business insights. With AI analysis, a smart dashboard and business reports, teams can understand performance at a glance and act with confidence.
Tech stack
The Challenge
Generating trustworthy charts from free-form questions is hard — the AI had to understand the schema, produce valid queries, and render results without hallucinated numbers.
The Solution
I built a schema-aware SQL generator with validation, a deterministic chart-rendering layer, and a confidence check that flags uncertain answers. Insights are derived from real aggregations, never fabricated.
What's inside
AI Business Analysis
Smart Dashboard
Business Reports
Company Insights
Actionable Recommendations
Architecture overview
Next.js + tRPC for end-to-end types
PostgreSQL with Prisma and generated analytics views
OpenAI function-calling → validated SQL execution
Server-side rendering of dashboard charts
Background job queue for scheduled reports
AI Implementation
OpenAI function-calling for schema-aware SQL generation
Confidence scoring to flag uncertain AI responses
Automated business insight extraction from data aggregations
Natural language to SQL with query validation and safety checks
Screens & previews
Replace these generated previews with real screenshots when available.