Skip to content
View aditya-datahub's full-sized avatar
💭
🟢 Open to Data Analyst / MIS Analyst roles
💭
🟢 Open to Data Analyst / MIS Analyst roles

Block or report aditya-datahub

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
aditya-datahub/README.md

Hi, I'm Aditya 👋

Data Analyst | SQL • Python • Power BI • Excel

Typing SVG


🚀 About Me

I turn messy data into decisions that save companies money and grow revenue.

  • 🚗 Analyzed 195K+ Uber rides — uncovered an 81% rider drop-off by Day 30 through SQL cohort retention analysis
  • ⛽ Built a fraud detection pipeline across 1,00,000 transactions — uncovered a 27.5% fraud rate and physically proved 16,200L of under-dispensed fuel using sensor data
  • 📈 Forecasted $192K Q1 revenue using ARIMA time-series modeling
  • 👥 Segmented riders using K-Means clustering — isolated a High Value tier averaging 4x the platform's average fare
  • 🎓 Microsoft Power BI Data Analyst Professional Certificate (verify) · Google Data Analytics Professional Certificate (verify)

🎯 Open to entry-level Data Analyst / MIS Analyst roles — Remote / Hybrid — available from August 2026


📂 Featured Projects

⛽ FuelGuard – Fraud Detection & Customer Analytics Pipeline

Built an end-to-end fraud detection pipeline analyzing 1,00,000 transactions across 50 fuel stations in 3 cities — uncovered 27.5% fraud rate (peaking at 51.2% in Delhi), physically proved 16,200L of under-dispensed fuel via sensor data, and validated 3 business hypotheses linking fraud to customer retention (fraud-affected customers return at 18% vs. 36% for clean transactions).

Python PostgreSQL Power BI DAX

View Project


🚗 RideIQ – Uber Product Analytics

Analyzed 195K+ NYC Uber rides to diagnose retention, cancellation, and pricing patterns. Wrote SQL window-function queries for cohort retention and completion-funnel analysis — uncovering an 81% rider drop-off by Day 30 (34% D7 → 19% D30 retention). Applied KMeans clustering to segment riders into Low/Mid/High value tiers, isolating a High Value segment averaging nearly 4x the platform's average fare. Built a 3-page Power BI dashboard with 5 DAX measures for executive-level reporting.

Python SQL Power BI scikit-learn

View Project


🔁 Customer Churn Prediction

ML pipeline on 7,043 customers predicting 26.54% churn — trained 4 models with SMOTE balancing; Random Forest selected as optimal.

Python Pandas scikit-learn

View Project


💳 BNPL Risk & Profitability Analytics

End-to-end fintech analytics project on Buy Now Pay Later lending data — cleaned and analyzed loan-level data in Python, then built a Power BI dashboard segmenting customers into High/Medium/Low credit risk tiers, tracking default rate, and surfacing which merchant categories and providers drive the highest loan volume and risk exposure.

Python Jupyter Power BI DAX

View Project


👉 View All Repositories


💻 Tech Stack

Programming & Databases: Python MySQL PostgreSQL Jupyter

Libraries & Analytics: Pandas NumPy Matplotlib scikit-learn SciPy Streamlit

BI & Reporting: Power BI Excel DAX

Tools: Git GitHub VS Code


📊 GitHub Stats


🤝 Let's Connect

LinkedIn GitHub Email

💬 Got a role, a project, or just want to talk data? Reach out to me through LinkedIn or Email — always happy to connect.

Pinned Loading

  1. fuel-analytics-fraud-detection fuel-analytics-fraud-detection Public

    ⛽ End-to-end fraud detection pipeline — identified 27.5% fraud rate & 16,200L under-dispensing across 50 fuel stations using Python, PostgreSQL & Power BI

    Jupyter Notebook 1

  2. bnpl-risk-profitability-analytics bnpl-risk-profitability-analytics Public

    End-to-end fintech data analytics project analyzing Buy Now Pay Later (BNPL) lending data to explore customer behavior, credit risk, and loan performance using Python, Jupyter Notebook, and Power BI.

    Jupyter Notebook 1

  3. customer-churn-prediction-project customer-churn-prediction-project Public

    Machine learning project to predict customer churn using end-to-end data preprocessing, feature engineering, model training, evaluation, and deployment-ready artifacts.

    Jupyter Notebook 1

  4. rideiq-uber-analytics rideiq-uber-analytics Public

    Uber product analytics — 200K NYC rides analyzed using SQL, Python & Power BI to solve retention, cancellation, and surge pricing problems.

    Jupyter Notebook 1

  5. optiflow-end-to-end-sales-performance-target-analysis optiflow-end-to-end-sales-performance-target-analysis Public

    End-to-end sales analytics project using Python, SQL, and Power BI to analyze sales performance vs targets, profitability, and underperforming categories through an interactive dashboard.

    Jupyter Notebook 1 1

  6. media-spend-roi-facebook-vs-google-ads media-spend-roi-facebook-vs-google-ads Public

    Analyzed Facebook vs AdWords ad campaigns using EDA, hypothesis testing, and linear regression to determine which platform delivers better ROI.

    Jupyter Notebook 1