Aexli Lens - Project Overview

Business Intelligence (BI) tools are historically complex, requiring specialized analysts to write SQL queries and construct dashboards. This creates a bottleneck between decision-makers asking a question ("What were our top-selling products in Q3 by region?") and getting the visual answer.

Aexli Lens eliminates this friction. It's an intelligent interface that translates natural language directly into executable SQL, queries the database, and instantly renders the appropriate charts and metrics in a custom dashboard.

The Challenge

Small startups and solo developers often lack the resources to hire dedicated data engineers. They have data, but no easy way to visualize it without spending weeks on frontend development or paying for expensive enterprise BI tools.

The Solution

We built a system that bridges the gap between raw data and visual insights using advanced Large Language Models (LLMs).

key Features

Text-to-SQL Engine: Users can ask questions in plain English (e.g., "Show me daily active users for the last 30 days"), and the system generates the precise SQL query to fetch the data.
Auto-Visualization: Based on the data returned (time-series, categorical, scalar), the system automatically selects the best visualization type (Line Chart, Bar Graph, KPI Card).
Offline Deployment: Designed for privacy-first environments, the solution can be deployed on offline servers, ensuring sensitive data never leaves the client's infrastructure.

Technical Implementation

Fine-Tuned Model: We fine-tuned the Phi-3 400k model specifically on SQL datasets. This specialized training achieved 93.7% accuracy in generating valid SQL queries from complex database schemas, outperforming many larger, general-purpose models.
Security: The architecture enables full functionality without internet access, a critical requirement for enterprise clients dealing with sensitive proprietary data.
Cost Efficiency: By using a highly optimized small language model (SLM) like Phi-3, we drastically reduced inference costs compared to using giant models like GPT-4, making the SaaS affordable for smaller players.

Impact

Aexli Lens empowers non-technical founders and product managers to build their own analytics tools in minutes, not months. It democratizes access to data intelligence, allowing startups to make data-driven decisions from day one.