Skip to content
View Rishabh11122001's full-sized avatar

Block or report Rishabh11122001

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Rishabh11122001/README.md

Hi, I'm Rishabh Bhagchandani πŸ‘‹

Data Analyst Β· Aspiring Data Scientist Β· AI/ML Enthusiast
Turning raw data into clear insights, useful dashboards and practical AI tools.

Portfolio LinkedIn Email Resume

About me

  • πŸŽ“ MCA student at IIIT Bhopal, with a CGPA of 9.55.
  • πŸ“Š My focus is data analytics, business intelligence and applied machine learning.
  • πŸ› οΈ I work with SQL, Python, Power BI and Excel, from data cleaning and modelling to dashboards and insights.
  • πŸ€– I build AI-powered applications that make data easier to explore and understand.
  • 🀝 Teaching Assistant experience and Smart India Hackathon 2024 & 2025 participation.
  • πŸ’Ό Open to Data Analyst / BI Analyst opportunities, data science roles and analytics collaborations.

Skills & tools

Data analysis & databases

Python SQL PostgreSQL SQLite Pandas NumPy

Business intelligence & visualisation

Power BI DAX Excel Matplotlib Seaborn Plotly

Machine learning & AI applications

Scikit-learn Streamlit Gemini API Groq API

Supporting development tools

Git React TypeScript Node.js Supabase

Featured analytics projects

πŸ€– AI-Powered Data Analyst Copilot

Ask questions in plain English and explore a 99K-order PostgreSQL warehouse through live data, charts and insights.

  • Converts questions into validated SQL with destructive-query blocking and query timeouts.
  • Includes Gemini-to-Groq fallback and 24 automated tests.
  • Tools: Python, PostgreSQL, Streamlit, Gemini, Groq, Plotly.

Repository Β· Live app

πŸ“Š E-Commerce Revenue & Operations Analytics

An end-to-end analytics project using the Olist Brazilian e-commerce dataset, SQL modelling and Power BI reporting.

  • Transformed 9 raw datasets across ~99K orders into a star schema with 4 dimensions and 4 fact tables.
  • Reconciled R$15.84M in order value and investigated a R$165K payment gap.
  • Built a 3-page Power BI dashboard covering sales, products, delivery and customer experience.
  • Tools: PostgreSQL, Power BI, DAX, Excel.

Repository Β· Dashboard walkthrough

πŸ“‰ Customer Churn Analysis & Prediction

A customer analytics and machine-learning workflow built on a 2,000-customer synthetic dataset.

  • Combines data cleaning, exploratory analysis, feature engineering and customer segmentation.
  • Trained Logistic Regression and Random Forest models with leakage-safe train/validation/test evaluation.
  • Improved recall from 35% to 61%, reaching ~92% after threshold tuning; this metric measures churn detection, not overall accuracy.
  • Tools: Python, Pandas, NumPy, SQLite, Scikit-learn, Matplotlib.

Repository Β· View analysis

More things I've built

Project What it does Tools
PulseBoard Interactive analytics dashboard for 50K–250K synthetic transactions, with filtering and virtualized tables. React, TypeScript, Recharts
RecallAI Turns study notes into validated flashcards and quizzes, with safeguards for malformed AI responses. React, TypeScript, Express, Zod, Groq
Spice Garden Restaurant client project covering billing, real-time orders and payment analytics. React, Node.js, PostgreSQL, Socket.io

Let's connect

Interested in data analytics, dashboards or applied AI? I'd be happy to discuss opportunities and collaborate on useful projects.

LinkedIn Β· Portfolio Β· Email

Pinned Loading

  1. customer-churn-analysis-prediction customer-churn-analysis-prediction Public

    End-to-end customer churn analysis and prediction using Python, SQLite, EDA and machine learning.

    Jupyter Notebook 1

  2. ecommerce-revenue-operations-analytics ecommerce-revenue-operations-analytics Public

    End-to-end e-commerce analytics project using PostgreSQL, SQL ETL, Excel QA, Power BI and DAX.

    PLpgSQL

  3. ai-data-analyst-copilot ai-data-analyst-copilot Public

    AI-powered data analyst copilot that converts natural language questions into safe PostgreSQL queries, automated visualizations and grounded business insights.

    Python

  4. recall-ai recall-ai Public

    AI-powered study assistant that turns free-form notes into validated flashcards and interactive quizzes.

    TypeScript 1

  5. pulseboard-performance-dashboard pulseboard-performance-dashboard Public

    Performance-focused React + TypeScript analytics dashboard for exploring up to 250K e-commerce transactions with interactive cross-filtering, single-pass aggregation, debounced search, and a virtua…

    TypeScript