Skip to content
View ishika-shandilya's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report ishika-shandilya

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.

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
ishika-shandilya/README.md

Hi, I'm Ishika Shandilya 👋

Data Analyst | Economics + Data Science | Delhi University

I turn raw data into business decisions — combining an Economics Honours background with hands-on skills in SQL, Python, and Power BI.

Currently in my final semester at Delhi University, actively seeking Data Analyst roles (remote/international).

🛠️ Skills

Analytics & BI: SQL (CTEs, Window Functions, Subqueries) · Power BI · Excel
Programming: Python (Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn)
Domain: Revenue Analysis · Customer Segmentation · Churn Analytics · Funnel Analysis
Currently learning: Machine Learning · Streamlit · Statistics for Data Science

📂 Featured Projects

🔌 Broadband Analytics: Revenue & Risk

Identified ₹8.77M revenue leakage and ₹12.86M recovery opportunity for a broadband ISP
SQL Python Power BI | 250K+ records across 10 relational tables

🛍️ RFM Customer Segmentation

Segmented retail customers by Recency, Frequency & Monetary value to drive targeted retention
Python Pandas Matplotlib

⚡ EV Charging Network Analytics

Analyzed utilization and profitability patterns across an EV charging network
Python Jupyter Notebook

📊 What I'm Working On

  • 🔨 Building a Telecom Churn Prediction model (XGBoost + SHAP + Streamlit deployment)
  • 📖 Completing B.A. (Hons.) Economics — Delhi University (2025)
  • 🌍 Open to remote data analyst roles in US, UK, and Europe

📫 Let's Connect

LinkedIn GitHub

Pinned Loading

  1. broadband-analytics-revenue-risk broadband-analytics-revenue-risk Public

    End-to-end analytics project identifying ₹8.77M revenue leakage and customer risk using SQL, Python, and Power BI.

    Jupyter Notebook

  2. ecommerce-funnel-analysis ecommerce-funnel-analysis Public

  3. EV-Charging-Network-Utilization-Profitability-Analytics EV-Charging-Network-Utilization-Profitability-Analytics Public

    Operational and profitability analytics for an EV charging network using Python and SQL

    Jupyter Notebook

  4. RFM-Model RFM-Model Public

    RFM model on Superstore Dataset

    Jupyter Notebook