Skip to content

harleenkaurkambojgandhi-design/talking-rabbitt-crm-analytics

Repository files navigation

๐Ÿฐ 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

About

AI-powered CRM & Sales Analytics dashboard built with Streamlit. Includes customer segmentation, KPI tracking, AI insights, and automated email notifications using SendGrid.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages