Background
A global manufacturing leader in North America sought to simplify access to complex transportation data spread across loads, stops, and cost tables. The company’s business teams relied heavily on technical staff for SQL query generation, which slowed decision-making and limited agility. To accelerate insights, the client needed an AI-powered solution that could translate natural language into SQL, execute queries securely, and generate analytics in plain English—without requiring advanced technical knowledge.
Challenges
The organization faced multiple barriers to achieving data democratization:
- SQL Dependency: Business users lacked SQL skills, creating bottlenecks and over-reliance on IT teams.
- Complex Data Models: Transportation data was distributed across multiple tables, complicating queries and analysis.
- Accuracy Risks: Direct AI-to-SQL translation risked incorrect queries and misleading outputs.
- Operational Complexity: Multi-environment flows involving query generation, execution, and analysis introduced latency.
- Visualization Gaps: No real-time dashboards to monitor KPIs or visualize analytics dynamically.
Solution
Narwal designed and implemented a ChatGPT Enterprise Analytics Bot integrating Custom GPT, Azure Functions, and Snowflake:
- Natural Language to SQL Conversion
- Enabled business users to query data in plain English, automatically generating Snowflake-optimized SQL queries aligned to transportation tables.
- Human-in-the-Loop Validation
- Added a checkpoint for users to confirm SQL correctness before execution, ensuring trust and accuracy in outputs.
- Secure Execution & Storage
- SQL queries executed within Snowflake via Azure Functions, with results stored securely as CSVs in Azure Blob Storage and shared through controlled URLs. Auth verifications (3x) enabled secured data flow across all 3 environments.
- AI-Powered Data Analysis
- GPT retrieved query results, performed descriptive and advanced analytics, and summarized findings in natural language, highlighting trends and KPIs.
- Scalable and Governed Architecture
- Leveraged serverless Azure Functions for scalability and Snowflake for secure, governed data operations.
Outcomes
The analytics bot delivered transformative benefits:
- Ease of Use: Business users accessed insights directly without needing SQL expertise.
- Accuracy and Trust: Human validation reduced risks of incorrect queries and misleading analytics.
- End-to-End Workflow: Enabled a seamless pipeline from natural language query → SQL execution → CSV generation → AI-powered insights.
- AI-Driven KPIs: Provided automated trend analysis and custom KPI generation to support decision-making.
- Operational Reliability: Architecture balanced automation with oversight, ensuring scalable, governed processes.
- Trade-Offs Identified: Slightly higher latency due to multi-environment flow; missing real-time dashboards and monitoring in current release.
Conclusion
By implementing the ChatGPT Enterprise NL2SQL and Analytics Bot, Narwal empowered the client’s business teams with intuitive, AI-driven access to transportation data. The solution not only reduced dependency on technical resources but also delivered faster, more accurate insights, enabling smarter decisions at scale. With a clear roadmap for role-based security and live dashboards, the organization is positioned to further enhance operational visibility and responsiveness.
Partner with Narwal today to democratize data access and transform analytics with AI-powered natural language interfaces.
