Skip to content

Latest commit

 

History

History
172 lines (107 loc) · 3.8 KB

File metadata and controls

172 lines (107 loc) · 3.8 KB

🐰 Talking Rabbitt - Conversational Analytics Dashboard

A powerful Streamlit-based AI-powered Sales Analytics & CRM Dashboard that converts raw CSV data into meaningful business insights, automated reports, customer segmentation, lead scoring, and email notifications.


🚀 Live Demo

🔗 Live App: (https://talking-rabbitt-crm-analytics-b7qeczjenqlwvvpicfttnn.streamlit.app/)


🏷️ Badges

Python Streamlit Pandas Status License


📌 Project Overview

Talking Rabbitt Analytics is an intelligent business analytics dashboard that helps users upload sales data and automatically generate insights, KPIs, reports, and customer intelligence.


✨ Features

📊 KPI Dashboard

  • Total Customers
  • Total Products
  • Total Revenue

🤖 AI Insights

  • Sales activity score calculation
  • Top product detection
  • Retention insight (simulated analytics)

🧹 Data Cleaning

  • Removes duplicate records
  • Handles missing values automatically
  • Numeric → median fill
  • Text → "Unknown"

👥 Customer Segmentation

  • Premium Customers
  • Regular Customers
  • New Customers

⭐ Lead Scoring

  • Scores customers from 0–100
  • Based on revenue contribution

📌 CRM Tracking

  • New
  • Contacted
  • Interested
  • Converted

📈 Sales Forecast

  • Simple predictive forecast using mean-based growth

📄 Automated Reporting

  • One-click business summary generation

📧 Email Notifications

  • SendGrid API integration
  • Send email updates to customers

⬇️ Download Reports

  • Export cleaned dataset as CSV

🛠️ Tech Stack

  • Streamlit
  • Python
  • Pandas
  • Matplotlib
  • SendGrid API
  • python-dotenv

📁 Project Structure

image

⚙️ Installation & Setup

1. Clone Repository

git clone https://github.com/your-username/talking-rabbitt-analytics.git
cd talking-rabbitt-analytics

2. Install Dependencies

pip install -r requirements.txt

3. Add Environment Variables

Create a .env file:

SENDGRID_API_KEY=your_api_key_here

4. Run Application

streamlit run app.py

🖼️ Screenshots

Screenshot 2026-05-21 210025 Screenshot 2026-05-21 210047 Screenshot 2026-05-21 210109 Screenshot 2026-05-21 210125 Screenshot 2026-05-21 225244

🔮 Future Scope

  • AI chatbot integration for queries
  • Machine learning forecasting model
  • Database support (MySQL / MongoDB)
  • User authentication system
  • Real-time dashboards

👨‍💻 Author

Harleen Kaur

📧 Email: harleenkaurkamboj1215@gmail.com 🔗 LinkedIn: linkedin.com/in/harleen-kaur-b612482a2


⭐ Support

If you like this project:

  • ⭐ Star this repo
  • 🍴 Fork it
  • 📢 Share it