Skip to content

README.md

Latest commit

 

History

History
22 lines (18 loc) · 1.59 KB

README.md

File metadata and controls

22 lines (18 loc) · 1.59 KB

Portfolio

My Data Analyst Portfolio.

NYC Taxi KPI Dashboard

alt text

  • Built ETL on 3M+ TLC trips + Meteostat weather; added pre-aggregations to cut Tableau read time −70%.
  • Project Link

Retail Sales & Fulfillment Analysis

alt text

  • Modeled 120k+ orders across 8 tables using CTEs/window functions; identified 137% YoY growth and 20+ day delivery gaps.
  • Project Link

Ride-sharing Seasonality Tests

alt text

  • Ran t-tests/ANOVA/Chi-squared with Shapiro-Wilk & Levene checks on 10k+ trips; found season & weather significant (p<0.05); translated into dynamic pricing and fleet recommendations.
  • Project Link

Last-mile Route-ETA Feature Pipeline

alt text

  • Engineered scalable feature pipeline for 144K+ delivery records, implementing temporal extraction, geospatial parsing, IQR outlier detection, and multi-dimensional aggregations to enable predictive modeling for India's largest logistics platform.
  • Project Link