Upload any sales or business dataset. Get instant KPIs, visualisations, and an AI analyst you can ask questions in plain English. Export a full business report in minutes.
Try it live (No installation required — runs in your browser)
A sales manager shouldn't need to know Python or SQL to answer "which region is underperforming this quarter?"
I built InsightIQ so that anyone — a Sales Ops lead, a commercial analyst, a regional manager — can upload their data and get real, grounded answers in under five minutes. No code. No dashboards to configure. Just questions and answers.
Upload a CSV or Excel file and the app gives you:
- Instant KPI summary — row counts, revenue totals, key metrics auto-detected from your columns
- Auto-generated visualisations — bar charts, line charts, and correlation heatmaps built from your data
- AI Analyst chat — ask questions like "Which region is underperforming?" or "What are the top three revenue drivers?" and get data-grounded answers
- Structured report export — Executive Summary, Sales Performance, Risk Analysis, and Strategic Recommendations, exported as Markdown, Word, or PDF
| Layer | Tool |
|---|---|
| UI Framework | Streamlit |
| LLM | Llama 3.3 70B via Groq API |
| Data Processing | Pandas |
| PDF Export | ReportLab |
| Word Export | python-docx |
| Environment | python-dotenv |
The AI prompt layer adapts to your context:
| Mode | Focus Areas |
|---|---|
| SaaS | MRR, churn rate, LTV, trial conversion |
| Retail | Sell-through, basket size, returns |
| Ecommerce | Cart abandonment, AOV, fulfilment |
| Marketing | CAC, ROAS, channel attribution |
| General | Revenue, volume, trend analysis |
1. Clone the repo
git clone https://github.com/sundusafreen/business-insight-generator.git
cd business-insight-generator2. Install dependencies
pip install streamlit groq pandas python-dotenv reportlab python-docx openpyxl3. Add your Groq API key
Create a .env file:
GROQ_API_KEY=your_key_here
Get a free key at console.groq.com
Disclaimer: "The live demo uses Groq's free API tier — if you hit a rate limit, try again in a minute or run locally with your own key."
4. Run
streamlit run app.pyBuilt during my MSc in Business Analytics at Trinity College Dublin. The core design question was: how do you make commercial data analysis accessible to the people who actually make the decisions — not just the people who write the queries?
The industry mode system came from noticing that a retail analyst and a SaaS analyst care about completely different metrics. Rather than one generic AI prompt, InsightIQ switches the analytical lens based on your business context.
Sundus Afreen
MSc Business Analytics — Trinity College Dublin
AI & Analytics Consulting — EY Ireland
LinkedIn ·
Portfolio