Skip to content

Isha2605/AI-Driven-CRM-Analytics-System

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

27 Commits
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

AI-Driven CRM Analytics System

A full-stack AI-powered CRM with sales tracking, event management, employee performance prediction, rewards, a PyTorch-based conversational assistant, and lead-classification ML - all in one web application. 82% accuracy lead scoring on 10,000+ customer records.

Python Flask MySQL PyTorch scikit-learn License

CRM home page


๐ŸŽฏ Problem

Small and mid-sized sales teams juggle CRMs, spreadsheets, calendar apps, HR tools, and analytics dashboards as separate products. Context gets lost between them, leads go cold, and employee performance is judged by gut feel instead of data.

๐Ÿ’ก Solution

A single web application that brings everything under one roof:

  • Customer & sales management - add, track, and segment customers
  • Events calendar - schedule follow-ups, demos, team events
  • Employee performance prediction - ML model forecasts rep performance
  • Employee rewards - data-driven recognition tied to predicted performance
  • Lead classification - KNN + Feedforward Neural Net scoring (82% accuracy)
  • Conversational assistant - intent-based PyTorch chatbot for natural-language queries

๐Ÿ“Š Impact / Results

  • 82% accuracy on lead classification (KNN + Feedforward Neural Net)
  • 10,000+ customer and sales records modeled in MySQL
  • 6 integrated modules replacing what would otherwise be 4+ separate tools
  • End-to-end: raw input โ†’ MySQL โ†’ ML features โ†’ web UI โ†’ conversational access

๐Ÿ—๏ธ System Architecture

System architecture diagram


๐Ÿ–ฅ๏ธ Application Walkthrough

Adding sales records

Add sales UI

Events calendar

Events calendar UI

User profiles

User profile page

Employee performance prediction

ML-driven forecasts of rep performance surfaced directly in the admin view - so managers review reps based on model output, not anecdote.

Employee performance prediction

Employee rewards

Recognition tied back to predicted performance and achieved KPIs.

Employee reward module

Conversational assistant

A PyTorch-trained intent classifier (bag-of-words โ†’ feedforward net, defined in model.py, trained via train.py on intents.json) lets users ask the CRM questions in natural language.

Chatbot assistant Chatbot assistant conversation


๐Ÿ“ˆ Analytics & Insights

Trend and segmentation analyses rendered on the dashboard.

Analytics graph 1 Analytics graph 2


๐Ÿ› ๏ธ Tech Stack

Layer Tools
Language Python 3.10+
Database MySQL
Web framework Flask, Jinja2
Data Pandas, NumPy
ML - lead classification scikit-learn (KNN + MLP / Feedforward NN)
ML - chatbot PyTorch (intent classifier over intents.json)
Frontend HTML, CSS, JavaScript

๐Ÿš€ Getting Started

# Clone
git clone https://github.com/Isha2605/AI-Driven-CRM-Analytics-System.git
cd AI-Driven-CRM-Analytics-System/source_code

# Install Python dependencies
pip install -r requirements.txt

# (Optional) retrain models
python train.py       # trains the chatbot intent classifier โ†’ data.pth
python model.py       # trains the lead-classification models

# Run the Flask app
python flaskdemo1.py

Then open http://localhost:5000.

๐Ÿ“ Project Structure

โ”œโ”€โ”€ assets/                 # Screenshots & architecture diagram (for README)
โ”œโ”€โ”€ source_code/
โ”‚   โ”œโ”€โ”€ static/             # CSS, JS, images
โ”‚   โ”œโ”€โ”€ templates/          # Jinja2 HTML templates
โ”‚   โ”œโ”€โ”€ flaskdemo1.py       # Flask entrypoint
โ”‚   โ”œโ”€โ”€ form1.py            # Form handling
โ”‚   โ”œโ”€โ”€ implement1.py       # Business logic
โ”‚   โ”œโ”€โ”€ chatbot.py          # Chatbot runtime
โ”‚   โ”œโ”€โ”€ model.py            # ML model definitions
โ”‚   โ”œโ”€โ”€ train.py            # Training script
โ”‚   โ”œโ”€โ”€ intents.json        # Chatbot intent patterns
โ”‚   โ”œโ”€โ”€ data.pth            # Trained chatbot weights (PyTorch)
โ”‚   โ”œโ”€โ”€ sample.csv          # Sample dataset
โ”‚   โ””โ”€โ”€ bot.js              # Frontend chat widget
โ””โ”€โ”€ README.md

๐Ÿ”ฎ Future Work

  • Swap KNN for Gradient-Boosted Trees (XGBoost) for production
  • Add SHAP explanations alongside predictions in the UI
  • Deploy on AWS (EC2 + RDS) with Nginx + Gunicorn
  • Upgrade chatbot from intent-based to LLM + function calling over the CRM schema
  • Role-based access control (RBAC) for admin vs rep views

๐Ÿ“ฌ Contact

Isha Narkhede ยท Portfolio ยท LinkedIn ยท ishajayant207@gmail.com

๐Ÿ“ License

MIT - see LICENSE.

About

Full-stack AI-powered CRM: sales tracking, events calendar, employee performance ML, rewards, and a PyTorch chatbot. Lead classification with 82% accuracy on 10K+ records. Built with Flask, MySQL, PyTorch, and scikit-learn.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors