Skip to content
View aprajitad's full-sized avatar

Block or report aprajitad

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

Hi, I'm Aprajita 👋

Data Analyst | Business Analyst | SQL · Python · Power BI · Excel

LinkedIn

🔎 About Me

I build end-to-end analytics projects — from cleaning messy data to shipping a dashboard someone can actually make a decision from. My work moves through SQL → Python → Power BI, and I care more about the "so what" than the chart itself.

  • 🛠 Full-stack analytics: data cleaning, EDA, SQL analysis, ML modelling, dashboarding, forecasting, A/B testing
  • 📫 Reach me on LinkedIn

🧰 Tools & Technologies

Languages & Querying

Python SQL SQLite MySQL BigQuery

BI & Reporting

Power BI Tableau Looker Studio Excel DAX Power Query

Python Data Stack

Pandas NumPy Matplotlib Seaborn Scikit-learn Prophet Jupyter

Analytics Methods

A/B Testing Cohort Analysis Forecasting Segmentation Anomaly Detection

Other

Git GitHub Google Cloud

📌 Featured Projects

Project What it does Stack
🛍️ D2C Cohort & Retention Analysis Cohort & retention modelling for Indian D2C brands — retention heatmaps, LTV by cohort, channel-risk analysis, Power BI dashboard Python · Pandas · Seaborn · Power BI
🛒 Blinkit Sales & Delivery Dashboard Interactive Power BI dashboard on 8,500+ delivery records — revenue trends, outlet performance, category insights Power BI · DAX · Power Query
📉 Customer Analytics & Churn Prediction End-to-end pipeline on customer behavior, support efficiency, and churn drivers — ML classification model Python · SQL · Scikit-learn
📈 Retail Sales Intelligence & Forecasting Full retail analytics pipeline with AI-based revenue forecasting and 3-page Power BI dashboard SQL · Python (Prophet) · Power BI
🔍 UPI Fraud & Healthcare Data Analysis Detects and visualises fraudulent UPI transactions in the healthcare sector using anomaly detection Python · SQL · Power BI
🚖 OLA Ride Booking Analysis SQL + Power BI analysis of OLA ride-booking data — revenue, cancellations, driver and customer performance SQL · Power BI

🏅 Certifications

  • 🏆 Google Data Analytics Professional Certificate — Coursera
  • 🥇 SQL (Advanced) — HackerRank
  • ☁️ Oracle Cloud Infrastructure 2025 — AI Foundations Associate
  • ☁️ Oracle Cloud Infrastructure 2025 — Data Science Professional
  • 📊 Microsoft Excel: Beginner to Advanced — Udemy
  • 🌐 Google Cloud Arcade Facilitator — Champion (BigQuery · Looker Studio · Cloud Storage)

Open to Data Analyst and Business Analyst roles across India. Let's connect on LinkedIn!

Pinned Loading

  1. Customer-Analytics-Churn-Prediction-Project Customer-Analytics-Churn-Prediction-Project Public

    End-to-end project of analyzing customer behavior, support efficiency, and churn patterns using Python, SQL, and ML.

    Jupyter Notebook

  2. Retail-Sales-Intelligence-Forecasting-System Retail-Sales-Intelligence-Forecasting-System Public

    End-to-end retail analytics pipeline using SQL for cleaning, Python for forecasting, and Power BI for business reporting.

    Jupyter Notebook

  3. D2C-Cohort-Retention-Analysis D2C-Cohort-Retention-Analysis Public

    Cohort and retention analysis for Indian D2C brands using Python and Power BI

    Jupyter Notebook 1