Skip to content
View abhishekjain2004's full-sized avatar

Block or report abhishekjain2004

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

👋 Hi, I'm Abhishek Jain

Aspiring Data Analyst · Python · SQL · Power BI · Advanced Excel


🎓 PG Program in Data Science & Analytics with Gen AI @ Imarticus Learning, Delhi-NCR (Mar 2026 – Present) 🏛️ B.A. (Hons.) Economics · Ramanujan College, University of Delhi (2022–2025) 📍Delhi-NCR · 📧 abhishek2004.jain@gmail.com 🔗 [LinkedIn]www.linkedin.com/in/abhishek-jain-297014277


I'm passionate about transforming raw data into clear, actionable insights. I work across the full analytics workflow — from data wrangling to visual storytelling — with a strong focus on solving real-world business problems across e-commerce, healthcare, and retail domains.


🛠️ Tech Stack

Languages & Libraries

Python Pandas NumPy Seaborn Matplotlib Plotly

Database

SQL

BI & Spreadsheet Tools

Power BI DAX Power Query Excel

Core Skills

Data Cleaning · EDA · Statistical Analysis · Dashboard Design · Data Storytelling · Star Schema Modelling · KPI Development


📊 Projects

Tools: Advanced Excel  |  Domain: E-Commerce

Analysed 500 transactions across 8 cities covering revenue, delivery timelines, and coupon effectiveness. Built interactive KPI dashboards revealing ₹3.49L total revenue, 42% late delivery rate, and city-wise sales breakdown using Pivot Tables, SUMIFS, and dynamic slicers.


Tools: Python · Pandas · Seaborn · Plotly  |  Domain: SaaS / Subscription

EDA across 5 datasets (7,500 activity records, 478 customers) to map a full 6-stage conversion funnel. Uncovered a 44% drop-off at checkout and a 14.4-day average cart-abandonment gap — with stage-wise transition days and city-wise breakdowns using Plotly interactive visuals.


Tools: Power BI · DAX · Power Query  |  Domain: Retail / Consumer Electronics

3-page interactive Power BI report tracking mobile sales by brand, region, and period. Features MTD calculations using TOTALMTD() and Year-over-Year comparison using SAMEPERIODLASTYEAR() — with dynamic slicers for Brand, City, Payment Method, and Month.


Tools: Power BI · DAX · Star Schema  |  Domain: Retail

Single-page Power BI dashboard built on a star schema (Fact_Sales + 4 dimension tables). DAX KPIs include Profit Margin, Total Profit, Sales LY comparison, and Quantity. Features map visual, pivot table, donut chart, and drill-through by brand, region, and store type.


Tools: Power BI · DAX · ZoomCharts Custom Visuals  |  Domain: Healthcare

3-page healthcare report across Patient Demographics, Key Trends, and Treatment & Cost. Tracks 5 YoY KPIs (Admissions, Rooms, Doctors, LOS, Billing) using SAMEPERIODLASTYEAR(). Includes test result rate analysis (Normal / Abnormal / Inconclusive) and ZoomCharts interactive custom visuals.


Tools: Power BI · DAX  |  Domain: Healthcare Operations

Operational hospital dashboard tracking patient admissions, bed occupancy, billing vs. insurance coverage, doctor workload, and follow-up scheduling. Features a Q&A Visual for natural language querying — enabling non-technical staff to explore data without slicer knowledge.


🏅 Certifications

  • 🏅 Python Programming — IT Skills, Delhi-NCR (July 2024)

📚 Currently Learning

Machine Learning Generative AI Advanced Analytics Statistics


📬 Let's Connect

💼 Open to Data Analyst · Business Analyst · BI Analyst opportunities

Email [LinkedIn]www.linkedin.com/in/abhishek-jain-297014277 GitHub


"Without data, you're just another person with an opinion." — W. Edwards Deming

Pinned Loading

  1. ecommerce-kpi-dashboard ecommerce-kpi-dashboard Public

    E-Commerce KPIs & Sales Dashboard built with Advanced Excel — revenue, delivery, and coupon analysis.

  2. customer-funnel-analysis customer-funnel-analysis Public

    Customer conversion funnel & subscription EDA across 5 datasets using Python, Pandas, and Plotly

    Jupyter Notebook

  3. mobile-sales-dashboard mobile-sales-dashboard Public

    Interactive Power BI dashboard tracking mobile sales by brand, city & period with DAX measures — MTD and Year-over-Year comparisons

  4. national-health-analysis national-health-analysis Public

    3-page Power BI healthcare report — patient demographics, YoY KPIs, treatment & cost analysis with ZoomCharts custom visuals.

  5. retail-sales-dashboard retail-sales-dashboard Public

    Retail Sales Power BI dashboard with star schema data model — profit margin, sales growth, and regional analysis using DAX.

  6. hospital-performance-dashboard hospital-performance-dashboard Public

    Power BI hospital dashboard tracking patient admissions, bed occupancy, billing vs. insurance, doctor workload and follow-ups with Q&A visual.