A comprehensive mobile and web application that provides AI-powered insights into inventory listed in CSV through natural language queries.
- Natural Language Queries: Ask questions about customers, orders, and inventory in plain English
- AI-Powered Responses: Uses Google Gemini AI for intelligent query understanding
- Real-time Data: Integrates with Google Drive for live CSV data access
- Scalable Architecture: Optimized for large datasets with caching and indexing
- Cross-Platform: React Native mobile app + web dashboard
- Backend: Python, FastAPI, Pandas, Google Drive API, Google Gemini AI
- Mobile: React Native, Expo
- Web: React, Material-UI
- Data: Google Drive, CSV files
How many customers do we have?
Name all the customers
Tell me about Melissa Wang
Number of customers from LA
What is the status of our inventory?
Price of blanket
I have an endpoint that generates report in a JSON format
http://localhost:8000/api/reports/text/executive_summary
Future enhancements for reports: Integrate in the UI as a different section where users can ask about specific report generation and analysis.
- Data-Grounded Responses: All AI responses are validated against actual CSV data
- Performance Optimization: LRU caching, data indexing, and query optimization
- Scalability: Handles large CSV files with pagination and background processing
- Error Handling: Robust fallback mechanisms and data validation