InsightLens

• 

  Home page

• 

  Data Preview

• 

  Analysis Dashboard

• 

  Charts

• 

  Smart AI assistant

🚀 Inspiration

InsightLens was born out of a simple frustration: working with data shouldn't require writing formulas or wrangling pivot tables. We wanted to build a tool that lets anyone talk to their data as if they're chatting with a teammate. No code. No clutter. Just clear insights.

💡 What it does

InsightLens is a web app that lets users:

• Upload a CSV file 📊
  
• Ask questions in plain English 💬
  
• Get AI-generated insights instantly ⚡

Whether it's sales data, survey responses, or a massive export from your app, InsightLens turns it into answers.

🛠️ How we built it

• Frontend: React + TypeScript + TailwindCSS
  
• AI Backend: Google Gemini API (gemini-pro)
  
• Deployment: Netlify
  
• Extras:
  
  • .env support with validation
    
  • User-friendly error handling
    
  • CSV file reader with prompt injection

🧗 Challenges we ran into

• Quota exhaustion on Gemini API (we now handle errors gracefully!)
  
• Prompt size limitations, especially with large CSVs
  
• Securing API keys and managing environment restrictions in dev vs prod

🏆 Accomplishments that we're proud of

• Built a fully functional AI-powered insight tool in a short hackathon window
  
• Designed a clean, minimal interface for a complex task
  
• Developed smart context handling to generate relevant answers from AI

📚 What we learned

• How to structure CSV data effectively for LLMs
  
• Prompt engineering for AI accuracy and tone
  
• Real-world limits of AI APIs and how to design around them

🔮 What’s next for InsightLens

• 🧾 Charts and visualizations alongside text insights
  
• 🗃️ Chat history to track previous questions
  
• 🌍 Multilingual support for global users
  
• 🔁 Refinement loop: ask follow-ups and drill into answers

Built with 💙 for the Bolt World's Largest Hackathon.
Let your data speak—and let InsightLens be the translator.

Built With

• googlegemini
• react
• tailwindcss